Start reading Expert Performance Indexing for SQL Server 2012 on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 [Kindle Edition]

Jason Strate , Ted Krueger

Print List Price: £39.49
Kindle Price: £26.43 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £13.06 (33%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £26.43  
Paperback £39.49  
Earn a Free Kindle Book
Earn a Free Kindle Book
Buy a Kindle book between now and 31 March and receive a promotional code good for one free Kindle book. Terms and conditions apply. Learn more

Product Description

Product Description

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.

What you'll learn from Expert Performance Indexing for SQL Server 2012 will help you understand what indexes are doing in the database and what can be done to mitigate and improve their effects on performance. The final destination is a guided tour through a number of real-world scenarios and approaches that can be taken to investigate, mitigate, and improve the performance of your database.

  • Defines indexes and provides an understanding of their role

  • Uncovers and explains the statistics that are kept in indexes

  • Teaches strategies and approaches for indexing databases

What you’ll learn

  • Fully understand the index types at your disposal

  • Recognize and remove unnecessary indexes

  • Review statistics to understand indexing choices made by the optimizer

  • Properly apply strategies such as covering indexes, included columns, index intersections, and more

  • Write queries to make good use of the indexes already in place

  • Design effective indexes for full-text, spatial, and XML data types

  • Manage the big picture: Encompassing all indexes in a database, and all database instances on a server

Who this book is for

Expert Performance Indexing for SQL Server 2012 is intended for database administrators and developers who are ready to boost the performance of their environments without the need to go in blindly building indexes.

About the Author

Jason Strate is a database architect and administrator with more than 15 years of experience. He has been a recipient of Microsoft's "Most Valuable Professional" designation for SQL Server since July 2009. His experience includes design and implementation of both OLTP and OLAP solutions, as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. Jason is actively involved with his local PASS chapter (SQL Server User Group) and serves as its director of program development. Jason worked with the board to organize the PASSMN SQL Summit 2009 for the local community. Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings. Jason is a contributing author for the Microsoft whitepaper Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition. Jason is an active blogger with a focus on SQL Server and related technologies.

Product details

  • Format: Kindle Edition
  • File Size: 6469 KB
  • Print Length: 354 pages
  • Publisher: Apress; 1 edition (3 July 2012)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B008J8L1KI
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Amazon Bestsellers Rank: #536,448 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.8 out of 5 stars  4 reviews
8 of 8 people found the following review helpful
4.0 out of 5 stars The #1 Index tuning book in the market, at the time of this review. 10 Sep 2012
By Jose - Published on
Format:Paperback|Verified Purchase
I love this book so much, that I have both versions: ebook and the regular paper book version at work.

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.
6 of 6 people found the following review helpful
5.0 out of 5 stars Every SQL Server professional should read this 3 Jan 2013
By Jes Schultz Borland - Published on
This is the only index-specific book that I know of for SQL Server, and it was a long-overdue resource.

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.
4 of 4 people found the following review helpful
5.0 out of 5 stars Indexing for DBA Heroes (or who want to be heroes) 1 Jan 2013
By Kathi Kellenberger - Published on
Format:Paperback|Verified Purchase
Let's face it: indexing is a dry, dry subject. Yet, it is an area that can profoundly impact the performance of your database application or reports. The authors, Jason Strate and Ted Krueger, manage to turn this dry topic into an enjoyable read with many analogies and lots of real-world advice. Besides delving into the different types of indexes, reasons for using them, index tuning, and maintenance, they also provide a nice introduction to internals that won't make your eyes roll up into your head.

I recommend this book to all SQL Server DBAs and developers out there who care about performance!
5.0 out of 5 stars Everything you want to know about indexes and performance 16 April 2013
By Ian Stirk - Published on

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

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.

Below is a chapter-by-chapter exploration of the topics covered, I've given each chapter its own rating.

Chapter 1 Index fundamentals

The chapter provides a comprehensive overview of what indexes are, the different types, and why they are important. The types of index discussed include heaps (sic), clustered, non-clustered, columnstore, xml, spatial, and full-text search. Also covered are primary keys, unique indexes, included columns, partitioned indexes, filtered indexes, and compression.

The various options used for creating an index are covered in good detail. These options include fillfactor, pad_index, sort_in_tempdb, ignore_dup_key, statisitics_norecompute, drop_existing, online, allow_row_locks, allow_page_locks, maxdop, data_compression, on partitions.

A brief overview of the system tables that contain index metadata is provided, including sys.indexes, sys.index_columns, sys.xml_indexes, sys.spatial_indexes, sys.column_store_dictionaries, and sys.column_store_segments.

Throughout the chapter there is an analogy made between indexes and books within a library. For example, the primary catalogue (e.g. book title) being equated with a clustered index, and a secondary catalogue (e.g. author name) with a non-clustered index. This is extended with the example of a large dictionary, where every letter has its own book, to reflect partitioning. Finally microfiche is used to reflect compression. (5/5)
This book probably covers everything you would want to know about indexes, it has great depth and range, is full of relevant examples, and has a methodological approach to performance tuning using indexes. The book is an excellent resource and will be useful to anyone looking to improve the performance of their SQL Server databases.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category