Hmmm, I read the question as

'as the clustered key is included in the leaf level of the non-clustered index do you need to add it to non-clustered indexes explicitly'

to...

Gail, would you mind expanding on that? Would not the answer to this be 'it depends', and the only way to be sure is to see if the optimiser uses...

I was hoping as it was easter this would be worth 7 points 🙂

yes, pretty sure i have seen this when the clocks go back

no problems, good to remind myself about it.

The where clause of database_id > 5 was to omit adventure_works for me, so ensure that value is what you want for your...

I wasn't referring to your reply Gail, we were typing at the same time. Memory:Available MBytes is the counter I intended, but too lazy to type it out!

mlwiller2 (4/15/2014)

---

I tried the permissions fix as well as a few others I found searching. This was just a test VM and after seeing no differences after upgrading (and that...

If your service pack reported an error I would assign those permissions and re-run it if I was you.

It may appear to hang together as its the log file that...

mlwiller2 (4/15/2014)

---

Lots of good info here. Unfortunately, I'm still working on getting the output of that statement on page 1 to say "locked pages in buffer pool" correctly (still 0...

worth a mention (for DBAs anyway) is that backup encryption is available in 2014

the file will not be reduced in size until the very end when the shrink process has completed compacting the data. If you tried to shrink it by the full...

..........which gives me another idea, use the cursor to insert into a temp table then select out of the table.

there are two ways around this I can see - a simple workaround would be run the query so the output is in text mode, does that suit?? Also your...

if you just want database roles users have granted use sp_helprolemember.

This could be put in a cursor which loops through all your databases

as long as its to a different database, yes.