Programming Books C Java PHP Python Learn more Browse Programming Books
SQL Server 2008 Query Performance Tuning Distilled and over one million other books are available for Amazon Kindle. Learn more
Buy New
$37.27
Qty:1
  • List Price: $54.99
  • Save: $17.72 (32%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $10.62
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) Paperback – March 15, 2009


See all 4 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$37.27
$33.27 $32.21

There is a newer edition of this item:

SQL Server Query Performance Tuning
$53.99
This title will be released on September 17, 2014.



Frequently Bought Together

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) + Professional SQL Server 2008 Internals and Troubleshooting + Microsoft SQL Server 2008 Internals (Developer Reference)
Price for all three: $121.51

Buy the selected items together

NO_CONTENT_IN_FEATURE

Image
Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at Audible.com. If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at ACX.com.

Product Details

  • Series: Expert's Voice in SQL Server
  • Paperback: 600 pages
  • Publisher: Apress; 1 edition (March 15, 2009)
  • Language: English
  • ISBN-10: 1430219025
  • ISBN-13: 978-1430219026
  • Product Dimensions: 1.3 x 7.3 x 9.1 inches
  • Shipping Weight: 1.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (29 customer reviews)
  • Amazon Best Sellers Rank: #631,232 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Sajal Dam holds a master's of technology degree in computer science from the Indian Institute of Science, Bangalore, and has been working with Microsoft technologies for over 12 years. He has developed an extensive background in designing database applications and managing software development. Sajal also possesses significant experience in troubleshooting and optimizing the performance of Microsoft-based applications, from front-end web pages to back-end databases.

While working at Microsoft, Sajal helped many Fortune 500 companies design scalable database solutions and maximize the performance of their database environments. As an IT strategist at Dell, Sajal manages Dell's vast database infrastructure by optimizing not only the databases, but also the database management processes, tools, and use of best practices. He also works closely with the application development teams and vendors, including Microsoft, in analyzing and resolving performance bottlenecks.



Grant Fritchey works as a development database administrator for FM Global, an industry-leading engineering and insurance company. In his previous time as a database administrator and developer, he has worked at three failed dot-coms, a major consulting company, and a global bank. He has developed large-scale applications in languages such as VB, C#, and Java and has lived with SQL Server from the hoary days of 6.0, right through to 2008. His nickname at work is "The Scary DBA." He even has an official name plate, and he displays it proudly.

Grant volunteers for the Professional Association of SQL Server Users (PASS) and has written and published articles on various topics relating to SQL Server at Simple-Talk, SQL Server Central, SQL Server Performance, the PASS web site, SQL Standard, and the SQL Server Worldwide Users Group. He is the author of the book Dissecting SQL Server Execution Plans. He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG).

Outside work, Grant kayaks, learns and teaches self-defense, brews his own beer, chops wood to heat his house, raises his kids, and helps lead a pack of Cub Scouts.


More About the Author

Grant Fritchey has more than twenty years experience in IT. That time was spent in technical support, development and database administration. Grant currently works as a Product Evangelist at Red Gate Software. Grant writes articles for publication at SQL Server Central and Simple-Talk. He has published books including, "SQL Server Execution Plans" and "SQL Server 2012 Query Performance Tuning." Grant has written chapters for "Beginning SQL Server 2012 Administration", "SQL Server Team-based Development" "SQL Server MVP Deep Dives Volume 2" and "Pro SQL Server 2012 Practices." Grant Fritchey was one of the founding officers of the Southern New England SQL Server Users Group.

Grant has been awarded as a Microsoft SQL Server MVP since 2009.

Customer Reviews

4.7 out of 5 stars
5 star
24
4 star
3
3 star
1
2 star
0
1 star
1
See all 29 customer reviews
If you need to make an application run faster, read the book in order.
Brent Ozar
On the initial chapters, you can find a good introduction on Performance tuning, Performance analysis and on the Database Engine Tuning Advisor.
Rajkumar Ramasamy
I like the way the author explains the different topics this book covers.
Gustavo Alvarez

Most Helpful Customer Reviews

40 of 41 people found the following review helpful By Brent Ozar on April 21, 2009
Format: Paperback
My gauge of an amazing book is simple: if I've got a question, and I reach for the book BEFORE I search the web, then it's an amazing book.

Several times in the last two weeks, I reached for this book first.

Query performance tuning is the art of reading a query's execution plan, figuring out why it's not fast, and then determining the most cost-effective way to make it faster. Anybody can throw more indexes in and just hope it speeds up, but as the book illustrates, sometimes that can hurt more than help.

To do a good job, the tuner needs to know about indexing, statistics, execution plans, compilations, blocking, deadlocks, and query design issues that can force a query to perform poorly. Some of this stuff is covered in abstract terms in college classes, but for the most part, all of us - developers, DBAs, sysadmins - are pretty much unprepared to guess what's going on inside the SQL Server engine.

When you first design and deploy an application, that's a great thing: you don't need to know what's going on inside the black box. SQL Server handles a lot of load with the default settings, with pretty much any application design, before things start to creak and groan. I've seen people build amazingly big SQL Server applications without any knowledge of how indexes or execution plans work. When you start to run into performance problems, you need expert help fast - and that's what this book provides.

Regardless of your seniority level, you're going to find this book's price an extremely worthwhile investment. The book's authors, Grant Fritchey and Sajal Dam, strike a great balance between bringing you up to speed versus diving into advanced concepts. Chapter 4 on Index Analysis is a great example.
Read more ›
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
24 of 25 people found the following review helpful By -tg on May 5, 2009
Format: Paperback 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.
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
9 of 9 people found the following review helpful By Sudheer K. Maharana on November 23, 2009
Format: Paperback
One of the finest book on SQL Server Perf Tuning. To be honest I used to have the SQL Server performance tuning book by Ken England on SQL 2000 and looking for it's sequel on 2005. I went to the book store and ordered the book but it was disappointing. Then this book was given to me by one of my friends. A great reference book as I was expecting. Lot of theories and matching examples make this book stand out from the rest. SQL Server is just not SQL Tuning. It includes Database System tuning. This book has given a dedicated chapter in making you understand the same. It gives you a perspective on how to approach to a performance tuning from identification of the performance bottleneck to troubleshooting the problem. I enjoyed reading chapters on indexing and Index, Statistics and Execution Cache Analysis. However, I wanted to see more detail on tuning XML and Service Broker.

I will suggest this book for other DBAs and SQL Programmers who want to know the theories behind Index and Statistics, BLocking and Deadlocking, Fragmentation.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 5 people found the following review helpful By Rajkumar Ramasamy on December 21, 2009
Format: Paperback
A very good reference book on SQL server performance tuning on diverse directions.

On the initial chapters, you can find a good introduction on Performance tuning, Performance analysis and on the Database Engine Tuning Advisor. There are various analysis and optimization techniques explained in later chapters. There is comprehensive information about most common performance issues that occurs due to Query designs and deadlocks.

We can find more information on tuning indexes like when and where to apply what type of index. Later, the workload optimization techniques explains ways to identify and research expensive queries and jobs and "What not" to do to avoid performance issues. This book helps not only to write individual queries without any performance flaws, it also helps to find where the flaws are in existing queries. I would like to mention that there are good of examples of queries (which everyone look for) which make the reader to understand where performance issues or bottlenecks occur and what to do with it.

One good sense I had when I started reading the book is it isn't that hard to read through the book even you are new to performance tuning in SQL server. I would strongly recommend this book for all database performance professionals (Even the beginners in Performance Tuning).
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Thomas Leblanc on October 2, 2010
Format: Paperback 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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?