SQL Server 2008 Query Performance Tuning Distilled


One of the finest book on SQL Server Perf Tuning.  A great reference book as I was expecting. Lot of theories and matching examples make this book stand out from the rest. SQL Server is just not SQL Tuning. It includes Database System tuning. This book has given a dedicated chapter in making you understand the same. It gives you a perspective on how to approach to a performance tuning from identification of the performance bottleneck to troubleshooting the problem. I enjoyed reading chapters on indexing and Index, Statistics and Execution Cache Analysis.

I will suggest this book for other DBAs and SQL Programmers who want to know the theories behind Index and Statistics, BLocking and Deadlocking, Fragmentation.

SQL Server 2008 Query Performance Tuning Distilled