In the case of non clustered indexes, each one needs to be maintained for every insert, update and delete - so that the index matches the table data.

So if...

Gail,

Boy, I'm battin a million today. I misspoke and meant the CI value, not the PK value. I definitely know the difference.

I need to measure twice and cut once...

Update stats.

Right. Thanks Gail. <pounding head on keyboard>

I appreciate the clarity and had a funny feeling that I was missing something when I clicked post. Next time, I'll double check first....

Right, the PK is already included in every NCI in a table with a clustered index, so the include is not needed/desired.

See the est exec plan with the include...

Everything gets logged in the tlog in all cases. This is required for the database to be consistent (ACID). Please see today's editorial.

The difference is that in simple mode,...

HA!

If it wasn't for the Murphy's of the world, we wouldn't need a tlog in the first place. But here we are, now everyone gets to become very familiar with...

It is easy to install both instances so that they run side-by-side. Just don't select n upgrade option and specify a different instance name.

If you want to upgrade the...

Right. I should have clarified that rather than understate the rework. Could have saved you the time of posting more clarity.

Ray,

Thanks for bringing out the preshutdown.

Technically, at the end of the day, there is no difference to the recoverability of the data, just when the finalizing of the data...

I was thinking along the lines of lutz. But since this will be slightly harder than a search and replace, try a tool like red gate's SQL search.

And every once in a blue moon, especially in older versions of SQL server, the statistics can become corrupt, causing SQL server to retrieve data 'the slow way' (explained for...

If you only deploy your database to SQL azure and leave your web app on your local server (or hosted elsewhere), then the application may be pretty slow depending on...

Ok, thanks for the clarification.

Google sp_grantlogin. This will help you begin the research process to do what you are doing. The sql login that executes sp_grantlogin and the many...

Ray,

I was not referring to option 1 - the user directly stopping the sql service.

In the example that I was referring to (option 2), I noted that...