In this session we will examine one of SQL Servers' most fundamental yet most important functions - how does SQL Server store data on disk and how does it find it again when executing a query. Using a combination of demos, lecture and discussions we will begin with the structure of the data on disk by delving into the world of HoBTs and Extends, RIDs and Keys and especially Pages. From there we will tackle topics concerning the retrieval of data such as Index levels, Index Scans and Seeks and Lookups.
You must be logged in to post a comment.
Pingback: 2012-01-24: Index Internals – January 2012 SJ SQL Server Meeting | sqlity.net
Pingback: 2012-03-10: Index Internals – SQL Saturday #110, Tampa, Florida | sqlity.net
Pingback: 2012-04-12: Index Internals – SQL PASS Regionalgruppe Hamburg - sqlity.net | sqlity.net
Pingback: 2012-06-09: Index Internals – SQL Saturday #121, Malvern, Pennsylvania - sqlity.net | sqlity.net