Index Internals

Speaker: Denny Cherry In this session we'll dig into the internal structures of indexes. We'll look at how SQL Server navigates through the index. We'll look at the various types of pages within the index and how SQL Server uses these different pages to access your data. We'll look at what happens within the index as data changes. This session will include numerous demos using undocumented commands as we dive into the depths of the database pages.

Register to view the full article

You have reached some of our most popular content! Register or log in to view.


Registering gives you access to more exclusive content like this article.