SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)
SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) by Grant; Dam, Sajal Fritchey
- Binding:
- Paperback
- Number of Pages:
- 600
- ISBN:
- 1430219025
- Product Group:
- book
- Publisher:
- APRESS
- Publication Date:
- March 23, 2009
- BooksForGeeks.com ID:
- 3964
Reviews for SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)
-
Good Book.
Rated out of 5 stars, December 12th, 2009
It is very good book I have ever found on SQL performance. I would hightly recommend this book. It can be well understood by beginner and advanced user a like. Lots of practicals to be done. Personally for me, Index Analysis, Statistics Analysis, Fragmentation Analysis & Deadlock Analysis are well explained and liked by me. Only thing I didn't like the quality of pages it is printed on. Summary at the end of each book is enough for you to be recalled everything you read. I read lots of books, but keep very privileged books in my library. It is surely one of them for next 3-4 years at least. -
Great Book on Query Performance Tunning
Rated out of 5 stars, September 12th, 2009
Though, a great book on MS SQL Query Performance Tuning, the pages are printed on a dull newspaper print which when not open with care will make the pages to tear. -
The single best book on how to improve the performance of your SQL queries
Rated out of 5 stars, June 12th, 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:
Poor Indexing
Inaccurate Statistics
Excessive Blocking and Deadlocks
Non-Set-Based Operations
Poor Query Design
Poor Database Design
Excessive Fragmentation
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 -
Not as good as the previous version from Sajal DAM !
Rated out of 5 stars, May 12th, 2009
Having already the 2000 version of the book i was really waiting for this one, also knowing Sajal DAM previous book my expectations were up.Unfortunatly this new version does not go as deep as the one writen by Sajal particularly when it comes to practical exemples.

