Expert Performance Indexing for SQL Server 2012

by Jason Strate, Ted Krueger

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good 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.

Genres: Reference

376 pages, Paperback

First published July 4, 2012

Reviews

[Tallarico · Rating 5 out of 5]

This book is excellent. Puts very complex subject matter in easily understood terms. Contains real world examples for improving performance in your environment.

This book is a great read and highly recommended for anyone looking to improve their SQL database's performance.

It raised my understanding of SQL indexing and had several code samples that I was able to immediately apply to my databases.

I will be seeking out more books by this author.