SQL Server 2000
Although SQL Server 2000 has come to end of life and SQL Server 2005/2008 are just so much better products there is a wealth of information to support this platform. Much 2000 code will work unchanged on SQL Server 2005 although this might not be the case going forward.- KB702_SQL Performance Tuning using Waits and Queues
- KB703_SQL Server 2000 P&T Survival Guide
- Dealing with User sp_ procs
- xxx_xxx
- xxx_xxx
- xxx_xxx
These two documents are landmarks in performance tuning published by Microsoft SQLCAT's Tom Davidson. These are the original Microsoft word docs converted to a static web page. I'm putting them here because as far as I know you can't find these on a microsoft site any more.
How to deal with user procs that start sp_ if you can't fix the calling code.
blah blah blah.
blah blah blah.
blah blah blah.