Presentation Materials – Index Internals
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
Newsletter Sign Up
5 Responses to Presentation Materials – Index Internals
Leave a Reply
You must be logged in to post a comment.
From the sqlity.net blog
-
How to identify the SQL Server Service Account in T-SQL
-
How to Change a SQL Login’s Password
-
Hash Algorithms – How does SQL Server store Passwords?
-
How to Re-Create a Login with only a Hashed Password
-
B+Trees – How SQL Server Indexes are Stored on Disk
-
The Hidden SQL Server Gem: UPDATE from SELECT
-
A Join A Day – Nested Joins
-
Determine the Uptime of a SQL Server Instance
-
A Join A Day – The Left Anti Semi Join
-
Log Reuse Waits Explained: LOG_BACKUP
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