I run, an average week being five runs for a total of twenty miles. I've got two young boys, so outdoors at lunchtime functions as my 'gym' time...

Thanks for the article. I've recently inherited a number of SQL Servers, so have had to give this some thought.

Here's a few additional items...

Has a recent DBCC CHECKDB...

Quality or consistency? OK, we know it's not an either/or proposition (focus only on improving quality and you'll never get anything done, focus only on consistency and...

Myself: played clarinet, keyboard, bass guitar, saxophone with varying levels of proficiency throughout my life.

I see lots of overlap between music and IT. The...

SQL Server 2000 doesn't issue CHECKPOINTs against tempdb.

Here's an excerpt from SQL Server 2000 I/O Basics at

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

All databases, except for tempdb are checkpointed. Tempdb does not require recovery (it...