Presentation Materials – Index Internals

2012-01-22 - Presentations

Abstract

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.

Downloads

Other Resources

Categories: Presentations

5 Responses to Presentation Materials – Index Internals

  1. Pingback: 2012-01-24: Index Internals – January 2012 SJ SQL Server Meeting | sqlity.net

  2. dblumer says:

    Great presentation Sebastian. Thanks a lot. Too bad we didn’t have time to wrap up. I wanted to hear you talk about the Seek vs Scan slide. Hopefully we can catch up and discuss it a little bit more soon.

  3. Pingback: 2012-03-10: Index Internals – SQL Saturday #110, Tampa, Florida | sqlity.net

  4. Pingback: 2012-04-12: Index Internals – SQL PASS Regionalgruppe Hamburg - sqlity.net | sqlity.net

  5. Pingback: 2012-06-09: Index Internals – SQL Saturday #121, Malvern, Pennsylvania - sqlity.net | sqlity.net

Leave a Reply