Heh regarding the last point about losing the index if the rebuild fails having disabled first...

That did seem like the gist of the disabled explanation, to save disk space with...

Something worth keeping in mind is that Index reorganization uses the database's transaction log file as a working space.

Rebuilding it allows the option of using the TempDB as working space...

I went to some of the first Sharepoint implementation tutorials at Microsoft campus in Reading UK when it launched. They had some really good ideas for getting people out of...

I found that the Logging to table option was only allowed in "live" profiler traces. I couldn't schedule a regular trace to use this via a SQL command.

But in the...

On a course I was on, the passive server in a database mirroring setup for SQL2005 was said to be acting in unlicensed mode. This would mean that full functionality...