Top positive review
6 people found this helpful
The single best book on how to improve the performance of your SQL queries
on 25 June 2009
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