Buy new:
-21% $43.33
Delivery Tuesday, July 2
Ships from: Amazon.com
Sold by: Amazon.com
$43.33 with 21 percent savings
List Price: $54.99

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
FREE Returns
No Import Fees Deposit & $18.93 Shipping to Finland Details

Shipping & Fee Details

Price $43.33
AmazonGlobal Shipping $18.93
Estimated Import Fees Deposit $0.00
Total $62.26

Delivery Tuesday, July 2
Or fastest delivery Monday, June 17. Order within 16 hrs 1 min
In Stock
$$43.33 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$43.33
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Sold by
Amazon.com
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$7.09
Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less See less
$22.35 delivery July 1 - 23. Details
Only 1 left in stock - order soon.
$$43.33 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$43.33
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by ThriftBooks-Atlanta.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Other sellers on Amazon
New & Used (16) from   $7.09
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Grant Fritchey
Follow
Something went wrong. Please try your request again later.

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) 1st ed. Edition

by Grant Fritchey (Author), Sajal Dam
4.1 4.1 out of 5 stars 41 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$43.33","priceAmount":43.33,"currencySymbol":"$","integerValue":"43","decimalSeparator":".","fractionalValue":"33","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"9PzIpYKdrpKyXZTi%2FxisJO%2BrdZk%2BHfvCQVXDw7dtduHrAOsEMzt4uHTKQAKRf1eNV2EXRE5gDUk5tYVNxl1%2FTW4hGvQbZReGJ8a1YBpOt%2BDhW7BpnoRirdARHHDNRM%2BQb2TT7mAf0LQ%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$7.09","priceAmount":7.09,"currencySymbol":"$","integerValue":"7","decimalSeparator":".","fractionalValue":"09","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"9PzIpYKdrpKyXZTi%2FxisJO%2BrdZk%2BHfvCGiXUQInNn%2FhHYnGAbUQfamHLY4VF8hSGM55kQP6y5NAClrpj25hBjmgGrNIeG5vLSeMP3mk9aPcT6Aaix5dM55m3ta8ZubzjVUElH80IJ4Fcvi4DQkGdHV6z5A5HxPjm5orCsVnvqr4%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area.

  • Emphasizes the practical. Does not bury readers in theory.
  • Gives readers practical techniques to immediately apply in their daily work.
  • Dedicates a chapter to each of the most common, performance–related problem areas.
Previous page
  1. ISBN-10
    1430219025
  2. ISBN-13
    978-1430219026
  3. Edition
    1st ed.
  4. Publisher
    Apress
  5. Publication date
    March 16, 2009
  6. Language
    English
  7. Dimensions
    7.01 x 1.27 x 9.25 inches
  8. Print length
    628 pages
  9. See all details
Next page

Customer reviews

4.1 out of 5 stars
4.1 out of 5
41 global ratings

Top reviews from the United States

Jose
5.0 out of 5 stars The only book you need for MS-SQL tuning, period!
Reviewed in the United States on October 14, 2009
Verified Purchase
This is book is a masterpiece. It is true that the basic concepts behind Indexes, statistics and query tuning have not changed a lot since probably SQL2000 but those concepts and the way SQL2008 handles them are explained here in an outstanding manner.

The author starts every chapter with a bit of theory (a paragraph or two) about the particular topic he's ready to explain. Next.... there is a demonstration of "why is bad" not following the theory (via a T-SQL statement) and then a similar example but this time following the good MS-SQL practice (again, with another T-SQL query) Very straightforward and practical approach which makes this book a good one because that's exactly what you need on a SQL performance tuning book: quick solutions and answers via examples.

Chapters #4 - Indexes is my favorite. You will get a full explanation of why your queries are running slow or how you can make them run faster; everything with real examples and real code. On this particular chapter author(s) help you to identify potential pitfalls in terms of Index selection and the main differences in query behavior between Non-clustered and Clustered Indexes on your tables and when to apply either of them.

I also love the book organization. There is a logical order that I suggest to follow: from start to finish; very easy and general techniques at the very beginning and more in-depth and detailed tuning techniques at the end. But still if you jump into the subject you want or need you will catch the concepts easily without feeling lost.

Amazing book! This book deserves a slot in your book-shelve.
One person found this helpful
Helpful
 Report
josh168
4.0 out of 5 stars Worthwhile
Reviewed in the United States on November 29, 2013
Verified Purchase
Covers a lot of topics and gives you good background. I would recommend the book, although it is a bit dry at times.
Helpful
 Report
Thomas Leblanc
5.0 out of 5 stars SQL Server DBA Rave Review
Reviewed in the United States on October 2, 2010
Verified Purchase
From a Simple-Talk article to eBook on Query Plans help create a great book from Grant Fritchey. I met Grant at SQL PASS in 2008 and then at SQLSaturday in New York, where he demonstrated addictive enthusiasm about SQL Server. I bought this book as soon as it went on sell. This was a missing piece of information for the SQL Server community until Grant and Sajal brought this book to the market. Please buy and read this book if you are a DBA or developer that has to tune queries in your job.

Thanks,
Thomas LeBlanc, MCDBA & MCITP
2 people found this helpful
Helpful
 Report
Kathi Kellenberger
5.0 out of 5 stars Smarter for reading this book
Reviewed in the United States on March 16, 2010
Verified Purchase
One of the best things for me about this book was that I was able to read most of it while riding the bus to work. Grant did such a good job of explaining the results of each step, I was able to understand each point without trying it out for myself on a computer. I think I am pretty good with T-SQL and query tuning, but, by reading this book, I now have a methodical way to address performance problems.
4 people found this helpful
Helpful
 Report
Edwin Rimapa
1.0 out of 5 stars Cant read the book
Reviewed in the United States on September 28, 2013
Verified Purchase
No letters look good, you can not see the images, it is a scam the've bought, again should digitize to read it properly
Helpful
 Report
-tg
3.0 out of 5 stars SQL Server 2008 Query Performance Tuning Distilled
Reviewed in the United States on May 5, 2009
Verified Purchase
Great book. I've been waiting for the re-write to Sajal Dam's book on SQL Server 2000 performance tuning for a very long time. The only problem with it is that that too many example scripts do not match the code in the book. [case in point: On pg. 289 it references a script called stats_changes.sql. The code in the download is nothing like the code on pg. 290. Ditto for pg. 177 and several others.] This leaves the reader to figure it out for themself. The book includes an email address for the author that rejects all attempts to send him email and I see no updates to the download since it was first published. If these oversites are corrected, this would be a great learning resource for the SQL Server professional charged with performance tuning responsibilities.
23 people found this helpful
Helpful
 Report
Stewart Gordon
4.0 out of 5 stars Good guide to sql server performance monitoring
Reviewed in the United States on December 8, 2009
Verified Purchase
This is a detailed look at how to get the best out of your SQL Server databases. I found it immediately useful in my workplace ... great examples, easy to understand
3 people found this helpful
Helpful
 Report
Daniel Gras
5.0 out of 5 stars In depth but readable
Reviewed in the United States on May 11, 2011
Verified Purchase
I love this book. I have been a SQL Server DBA for 5 years, but I have been learning so much through reading this book. It is well written and easy to understand. It goes into "why" indexes work the way they do, so that a DBA can use that knowledge to make good decisions. It also covers tools that DBAs should know such as Profiler and Performance Monitor.
One person found this helpful
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Maestrat
3.0 out of 5 stars molt ben explicat
Reviewed in Spain on March 4, 2018
Verified Purchase
És un llibre que realment conté molta informació útil, tot i que de vegades embolcallada amb un excés text innecessari. La millor forma de llegir-lo és tenint un llapis per a anar subratllant els paràgrafs relevants o bé fent un resum a banda.
Ara mateix recomanaria millor buscar el llibre equivalent per a una versió més moderna de SQL server.
Report
penben
5.0 out of 5 stars Read Read Read Read
Reviewed in the United Kingdom on July 12, 2011
Verified Purchase
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.
One person found this helpful
 Report
P. Tomer
4.0 out of 5 stars Good Book.
Reviewed in the United Kingdom on December 12, 2009
Verified Purchase
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.
3 people found this helpful
 Report