- Amazon Students Members Get an Extra 10% Off Selected Books Here's how (terms and conditions apply)
SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server) Paperback – 20 Jun 2012
Save an extra 10% with Amazon Student*
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Special Offers and Product Promotions
Frequently Bought Together
Customers Who Bought This Item Also Bought
Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
About the Author
pstrongGrant Fritchey/strong 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. /p pGrant 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 emDissecting SQL Server Execution Plans/em. He is one of the founding officers of the Southern New England SQL Server Users Group (SNESSUG)./p pOutside 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./p
What Other Items Do Customers Buy After Viewing This Item?
Top Customer Reviews
It's well structured, clearly written and will improve understanding of why things done one way are better than possible alternatives. Experienced DBAs or developers will find something to learn from this book, people new to the SQL Server or specifically T-SQL may need an intro to T-SQL to go hand-in-hand with this one as it is not set at an introductory level.
I have heard there were some early copies that Amazon managed to print with print-setting issues but they are offering free replacements for all of these so I have no issues with recommending it to anyone.
I have written a chapter-by-chapter review of this book on "[...]" the first part of this review follows:
Indexes are a primary means of making performance improvements on SQL Server. This book aims to tell you all you need to know about indexes, and more importantly, provides a methodological approach to index tuning, turning what is often viewed as an art into a science.
Indexes are typically a dry subject matter, however they are fundamental to both understanding the structure of data and helping improve query performance. The examples provided make the subject interesting and accessible.
Before reading the book, I had a list of questions that I hoped would be covered, this would let me know how detailed the book was. It successfully answered most of my questions - showing me the book had both depth and quality. These questions included:
*Will it use practical examples to illustrate a point?
*Does it mention the plan cache as an input to the DTA?
*Does it identify the limit in the number of missing indexes?
*Will it tell me how to fix a corrupt index?
*Will it provide scripts to automatically optimize my databases?
I did wonder why anyone would want to write a book solely about indexes. After all, if you wanted to know about a given make of car, would you buy a book that's only about the car's engine? The answer I think, from a performance perspective, is yes.