The editorial mentions that "we haven't yet built a good, easy to understand framework that provides good monitoring and auditing in a way the majority of DBAs can understand and...

While I've had more than one employer that's been reluctant ("loath") to provide training resources to employees, I'm not sure I have worked for any that truly hated ("loathed") it.

Great topic. I think there's a perfect metaphor around highway interchanges. I particularly like this description of so-called stack interchanges: "This is not only expensive but also creates an eyesore...

Turns out I may have found the answer, unseemly as it may be. The error message appears to be bogus. The developer went back and checked the stored procedure and...

I think I've found a workaround that might be useful to some of you. After deciding I didn't want to completely uninstall my SQL Server to get replication working, I...

I just spent the better part of a day researching this. Here's my scenario and what I fear is the outcome.

- My development server is SQL 2005 Standard Edition with...

Marker - Further to DavidB's reply about DEFRAG v. REINDEX, if you are running SQL Server 2005 search Books Online for this:

Using sys.dm_db_index_physical_stats in a script to rebuild or reorganize...

You may want to look into the script posted in this Microsoft support article:

http://support.microsoft.com/kb/256650

While the article refers specifically to SQL 7.0, I've used it on SQL 2000 and believe it...