6 of 6 people found the following review helpful
The single best book on how to improve the performance of your SQL queries,
This review is from: SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) (Paperback)
I tend to specialise in SQL performance tuning, I perhaps have 10+ books on the subject. Without doubt this is the single best book on how to improve the performance of your SQL queries.
Read the first chapter of this book for free at the apress website, it gives an overview of the rest of the book.
The author has a great style of writing, very practical, wide-ranging, with lots of sample code and explanation.
The book covers:
Excessive Blocking and Deadlocks
Poor Query Design
Poor Database Design
Nonreusable Execution Plans
Poor Execution Plans
Frequent Recompilation of Execution Plans
Improper Use of Cursors
Improper Configuration of the Database Log
Excessive Use or Improper Configuration of tempdb