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_2

2. Index Storage Fundamentals

Edward Pollack¹   and Jason Strate²

(1)

Albany, NY, USA

(2)

Hugo, MN, USA

 

Where the previous chapter discussed the logical design and syntax of indexes, this one will focus on the physical implementation of indexes. Understanding how indexes are stored and interact with SQL Server and the storage engine is key to better understanding the benefits of indexes and how to make more effective use of them.

This discussion will start with the basics of data storage in SQL Server, including data pages, their format, ...