SQL Server Data Storage: Pages, Extents, and More!

Data in SQL Server is stored on pages, but what does that mean? What are pages and how are they structured? What are the different types of pages and how are they used to organize data? What are extents and how are they used to organize pages?

This session is a dive into SQL Server storage fundamentals and how this knowledge can be used to make better decisions with regards to files, filegroups, tables, indexes, and more! What starts as a review of pages and their function will quickly evolve into viewing (and understanding) the contents of pages. Also discussed will be corruption, what causes it, and how knowledge of SQL Server data storage can assist in resolving corruption!

Edward Pollack

Data Architect | Microsoft Data Platform MVP

Albany, New York, United States


Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top