Shop now Shop now Shop now Cloud Drive Photos Shop now Learn More Shop now Shop now Shop All Amazon Fashion Summer Savings Up to 25% Off Shop Fire Shop Kindle Oasis Listen in Prime Shop now Learn more

Customer Reviews

4.0 out of 5 stars6
4.0 out of 5 stars
Your rating(Clear)Rate this item


There was a problem filtering reviews right now. Please try again later.

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:

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
0Comment|6 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 19 July 2011
A must have book for both developers and DBAs. Coding is just the first step in development but how to write optimized code is next step in career. Whosoever writes whatever kind of code on SQL Server this book gives an excellent overview on code optimization and tuning.
I would highly recommend this book so far my favourite chapter is on indexes....
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse
on 12 July 2011
This is a great book and I would recommend reading it cover to cover.

It contains all the necessary parts of performance tuning.

The physical quality of the book could be better... but sticky tape can fix that problem.
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse
on 12 December 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.
0Comment|3 people found this helpful. Was this review helpful to you?YesNoReport abuse
on 8 May 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.
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse
on 13 September 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.
0Comment|One person found this helpful. Was this review helpful to you?YesNoReport abuse

Send us feedback

How can we make Amazon Customer Reviews better for you?
Let us know here.

Sponsored Links

  (What is this?)