Enter your mobile number or email address 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.
To get the free app, enter your mobile phone number.
Expert Performance Indexing for SQL Server 2012 1st ed. Edition
Use the Amazon App to scan ISBNs and compare prices.
IT Certification Resources
Featured resources for IT Certifications: CCISP, Linux, Cisco, Security, CompTIA, and others. Sponsored by McGraw-Hill.Learn more.
Frequently Bought Together
Customers Who Bought This Item Also Bought
Top Customer Reviews
The reason why I like this book so much, is that it goes more in-depth in terms of Index tuning and theory than any other book in the market. Almost every MS-SQL tuning book talks about Index strategies, but this book talks exclusively about Indexes, so you get much more information and more explanations that maybe you are not able to get on other books because the normal book's size limitation that publisher impose.
The book start with basic theory, which I fully recommend. Even though I'm not new on this topic, I found lot interesting information that gives me a fresh perspective about how my tuning strategy should work (or why is not working as I was expecting) These intro topics are focused but not limited to Index storage, Index fundamentals and T-SQL syntax.
After the mandatory theory, authors talk about Index tuning and good practices, available Tuning Tools for Indexes and how to validate the performance on those Indexes that have been deployed already.
The book ends showing a few examples about how T-SQL queries should be written while keeping performance in mind.
My only minor suggestion is that the book would be even better with much more illustrations than what it currently has. Not saying there are not illustrations at all, but some topics like fragmentation, storage and Index's behavior when inserting or reading data have just a few illustrations that barely show the actual concept. Some lines on those specific chapters are a little bit difficult to follow because that. A book that really shines on that, but is a really a dated one, is MS-SQL 2000 Perf. Optimization and Tuning by Ken England.
In a nutshell, this is a very nice book about MS-SQL Indexes and almost every aspect that falls into that category: theory, storage, tuning, deployment. If you are new into MS-SQL performance tuning or want to take your Index tuning strategies to the next level, this is the right book for that. It benefits DBA and Developers, because touches both aspect of query performance.
Now, if you are serious about the topic or want to expand the knowledge more, I would also like to recommend Grant's book SQL Server 2012 Query Performance Tuning He mentions Index Tuning too, but in a more holistic approach. Grant's is a more "all around" tuning book, while "Expert Performance Indexing for SQL Server 2012" book focus on the Index aspect of the tuning only.
The progression of the book is very logical, from index fundamentals to special types of indexes, index maintenance to a method to analyze and implement changes. The examples and queries that are included are thorough yet understandable. You are given a solid foundation as to why you should do something, and the tools with which to do it. Another outstanding benefit to this book is that Jason and Ted have taken their years of working with business users and distilled that. This book goes beyond the purely technical reasons for doing something and encourages you to think about the impact to the business, the applications, and the users behind the databases.
This book is already one of the most valuable resources in my library. I know it will be referenced frequently (it already has been, and it's littered with Post-It flags). I recommend anyone that works with SQL Server - whether as a developer, a DBA, or any combination thereof - pick up this book and read it. You don't have to be a SQL Server expert to pick up this book and learn from it, and even experienced users will learn something new and interesting. You won't find a more comprehensive index resource anywhere.
I recommend this book to all SQL Server DBAs and developers out there who care about performance!