Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

E. Pollack, J. StrateExpert Performance Indexing in Azure SQL and SQL Server 2022https://doi.org/10.1007/978-1-4842-9215-0_3

3. Examining Index Contents

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

With an understanding of how indexes are stored at the physical and logical levels, a deeper view of index storage can be gained by more closely viewing the details and contents of an index.

This deep dive will cross into a set of commands that are rarely used as part of day-to-day work and therefore will provide content that is both challenging and interesting to learn and test.

Warning

The tools used in this section are undocumented and ...