Partitioning is not a performance tuning feature, it's for data management and maintenance.

If it's recommending an index that you have exactly, ignore it.

Another point, that query fetches the estimated plan (plan without run-time information) because the run-time info that makes a plan 'actual' isn't stored in cache. It would be too expensive...

Without seeing the current index definitions, the query and the execution plan, no way to say for sure.

Ed Wagner (4/19/2016)

---

Are you thinking something along...

RTaylor2208 (4/19/2016)

---

GilaMonster (4/19/2016)

---

RTaylor2208 (4/19/2016)

---

During fail over though the instance will take slightly longer to come online as it will perform an upgrade \ downgrade between versions. You'll see this...

Yup, that will work fine.

Updates are done in two phases, first a read, then a change. So SQL's read all the data it needs from the table before it starts...

RTaylor2208 (4/19/2016)

---

During fail over though the instance will take slightly longer to come online as it will perform an upgrade \ downgrade between versions. You'll see this reported in...

TheComedian (4/19/2016)

---

Nonetheless I've heard a rumour that after 2016, you won't have any version specific certification of SQL Server. It will just be "SQL Server certification" with a mandatory...

And more homework in the forums. Is it wrong to want to post a sensible-looking but completely incorrect query as answers?

Then hand it in with wrong answers, doesn't bother me.

Have you created tables to test your queries? If not, go and do so now.

Once you've created those tables, run that...

Does that query run?

If you haven't created test tables based on the assignment, you should. You need to test queries, it's very hard when you're starting to be able to...

We're happy to...

djmenon21 (4/19/2016)

---

Can you please try to improve your query for the 3rd question ?

3. Please write an SQL query that will answer the following question:

What’s an average number of comments...

Can you post the execution plans please?