Expert Performance Indexing for SQL Server 2012

by Jason Strate, Ted Krueger

About the Book: Expert Performance Indexing for SQL Server 2012 Expert Performance Indexing for SQL Server 2012 is a deep diveinto perhaps the single - most important facet of good performance:indexes and how to best use them. The book begins in the shallowwaters with explanations of the types of indexes and how they arestored in databases. Moving deeper into the topic and further intothe book, you will look at the statistics that are accumulated bothby indexes and on indexes. All of this will help you progresstowards properly achieving your database performance goals. What you'll learn from Expert Performance Indexing for SQLServer 2012 will help you understand what indexes are doing in thedatabase and what can be done to mitigate and improve their effectson performance. The final destination is a guided tour through anumber of real - world scenarios and approaches that can be takento investigate, mitigate and improve the performance of yourdatabase. Defines indexes and provides an understanding of their role Uncovers and explains the statistics that are kept inindexes 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 theoptimizer Properly apply strategies such as covering indexes, includedcolumns, index intersections and more Write queries to make good use of the indexes already inplace Design effective indexes for full - text, spatial and XML datatypes Manage the big picture: Encompassing all indexes in a databaseand all database instances on a server Contents Index Fundamentals Index Storage Fundamentals Index Statistics XML, Spatial and FULLTEXT Index Myths and Best Practices Index Maintenance Indexing Tools Index Strategies Query Strategies Index Analysis

Genres: Reference

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.