Hands-On SQL Server 2000 : Troubleshooting Locking and Blocking

In this first installment of the hands-on series, SQL Server guru Kalen Delaney walks you through troubleshooting your SQL Server performance problems. In this installment, she dives deep into locking and blocking: what causes them, how to fix them when they are a problem, and how to look into the system tables to troubleshoot problems. The hands-on series has lots of sample code to get you started and debugging your own performance problems quickly! Tech edited by Itzik Ben-Gan.