SQL Server 2012 Internals Companion Content
(For SQL Server 2008 Internals files, please go to this page.)
Code snippets for Chapters 1, 3, 4, 5, 6, 7, 8, 10, 12 and 13 are now available.
For Chapter 7, some of the scripts and a sample database were created by Kimberly Tripp for the SQL Server 2008 Internals book and can be used ‘as is’. You can download the IndexInternals sample database and a collection of scripts to analyze the table and index structures. I have left the scripts as Kimberly originally wrote them, and their comments refer to Chapter 6 in the SQL Server 2008 book. The chapter on indexes is now Chapter 7 in the SQL Server 2012 book.
For Chapter 8, in addition to the code snippets, you can download a zipped file containing a script (Partition.sql) and data to build a partitioned table. The file contains partition.zip and two csv files with the data. The size is 2.3 MB.
Other databases mentioned in the book (Northwind, Northwind2, pubs) can be built from these scripts here.