Expert Performance Indexing in SQL Server 2019, 3rd Edition
- Author: Jason Strate
- ISBN: 1484254635
- Year: 2019
- Pages: 615
- Language: English
- File size: 14.8 MB
- File format: PDF, ePub
- Category: SQL
Have a deep dive into perhaps the single most important aspect of superior performance: indexes, and how to utilize them. Recent upgrades to SQL Server have made it possible to create indexes in scenarios that previously would have prevented their use.
Other developments covered in this book include new dynamic management perspectives, the capability to pause and resume index maintenance, and the capability to easily recover from failures during index creation and maintenance operations. This new edition also brings fresh content around the indexing of column store and in-memory tables, showing how these new kinds of tables and the queries that execute from them can also gain from great indexing practices.
The book starts with explanations of the kinds of indexes and how they are stored in databases. Moving deeper into this issue, and further into the novel, you may examine the statistics that are accumulated either by indexes and on indicators. You may better understand what indexes do in the database and what can be done to mitigate and polish their effect on functionality. You’ll find a look at the Index Advisor now available in Azure SQL Database, and find out how to review and take care of the health of your indexes. The final chapters present a guided tour through many of situations showing approaches you can take to investigate, mitigate, and improve the functioning of your database.
What You Will Learn
- Properly indicator row store, column store, and in-memory tables
- Evaluation data to understand indexing options made by the optimizer
- Employ indexing strategies like covering indexes, comprised columns, and indicator intersections
- Recognize and remove unnecessary indicators
- Design effective indexes for full-text, spatial, and XML data types
- Handle the large picture: Encompass all indexes in a database, and all database instances on a host
Who This Book Is For
Database administrators and programmers who are ready to lift the performance of their database environment by thoughtfully building indexes to speed up queries that matter the most and make a difference to the company