This presentation discusses the basics of SQL Server storage structures and internals.
The scripts reference the CorpDB Database (19 MB) used by the scripts. This is a backup from SQL Server 2012. If you restore to 2014+ be sure to upgrade the compatibility level. Last updated 4 January 2017.
Presentation History:
- SQL Saturday 787 (Sioux Falls, South Dakota), 18 August 2018
- SQL Saturday 778 (Memphis, Tennessee), 6 October 2018
- SQL Saturday 767 (Lincoln, Nebraska), 27 October 2018