Books by Dmitri Korotkevitch

SQL Server Advanced Troubleshooting and Performance Tuning

Best Practices and Techniques

Expert SQL Server Transactions and Locking

Concurrency Internals for SQL Server Practitioners

Pro SQL Server Internals