Expert Performance Indexing in SQL Server

  • Authors
  • Jason Strate
  • Grant Fritchey

Table of contents

  1. Front Matter
    Pages i-xxiii
  2. Jason Strate, Grant Fritchey
    Pages 1-14
  3. Jason Strate, Grant Fritchey
    Pages 15-54
  4. Jason Strate, Grant Fritchey
    Pages 55-99
  5. Jason Strate, Grant Fritchey
    Pages 101-114
  6. Jason Strate, Grant Fritchey
    Pages 115-129
  7. Jason Strate, Grant Fritchey
    Pages 131-140
  8. Jason Strate, Grant Fritchey
    Pages 141-151
  9. Jason Strate, Grant Fritchey
    Pages 153-174
  10. Jason Strate, Grant Fritchey
    Pages 175-212
  11. Jason Strate, Grant Fritchey
    Pages 213-235
  12. Jason Strate, Grant Fritchey
    Pages 237-292
  13. Jason Strate, Grant Fritchey
    Pages 293-309
  14. Jason Strate, Grant Fritchey
    Pages 311-343
  15. Jason Strate, Grant Fritchey
    Pages 345-389
  16. Jason Strate, Grant Fritchey
    Pages 391-396
  17. Back Matter
    Pages 397-403

About this book

Introduction

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

Bibliographic information

Industry Sectors
Pharma
Chemical Manufacturing
Biotechnology
Electronics
Telecommunications
Consumer Packaged Goods
Energy, Utilities & Environment