Authors:
Expert Performance Indexing in SQL Server provides information that every DBA and developer needs to begin investigating the performance of indexes on their databases and developing a strategy for improved performance.
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (15 chapters)
-
Front Matter
-
Back Matter
About this book
This book 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. You’ll better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. The final destination is a guided tour through a number of real life scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database.
- Defines the types of indexes and their implementation options
- Provides use cases and common patterns in applying indexing
- Describes and explain the index metadata and statistics
- Provides a framework of strategies and approaches for indexing databases
About the authors
Bibliographic Information
Book Title: Expert Performance Indexing in SQL Server
Authors: Jason Strate, Grant Fritchey
DOI: https://doi.org/10.1007/978-1-4842-1118-2
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Jason Strate and Grant Fritchey 2015
eBook ISBN: 978-1-4842-1118-2Published: 11 November 2015
Edition Number: 2
Number of Pages: XXIII, 403
Number of Illustrations: 238 b/w illustrations
Topics: Database Management