Understanding SQL Server Page Structure: How Page Splits Affect Performance - Video Series Video Category: SQL Server Architecture: System Databases, System Tables, and SQL Server Internals Skill Level: 500 (Advanced) Versions/Editions Covered: SQL Server 2005 This essential video series will be teaching you about the different types of functions and how, why and what happens when a page splits and how it affects you! Highlights: Building a Clustered Index in TSQL Overview Discussion about Page Types Introduction to the use of the OBJECT_NAME() function Page Types, Byte Length, Page Splits, m_freeCnt Introduction to SQL 2005's Dynamic Management Objects (DMs) About fragementation when page splits occur Detailed explanation of the undocumented FN_DBLOG() function Introduction and explanation of Housekeeping Threads and Ghost Records

Videos in this Series:

Title Skill Length Download Pt. 1 - Understanding SQL Server Page Structures and Clustered Index Structure   500 8 mins. Download Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM,...   500 12 mins. Download Pt. 3 - Understanding What Really Happens (Internally) When a Page Split Occurs   500 11 mins. Download Pt. 4 - How to View (and Understand) the Contents of the SQL Server Transaction ...   500 8 mins. Download Pt. 5 - What Are 'Ghost Records'? What Happens Internally When You Delete a Row?   500 5 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Keyboard Shortcuts: "Windows key" + "E" quickly brings up Windows Explorer SQLDIAG.EXE is a handy tool that ships with your SQL Server that can provide you with detailed information about your SQL Server and its environment. Simply run SQLDIAG.EXE from the command-line Book You Should Probably Own: Ken Henderson's "The Guru's Guide to SQL Server Architecture And Internals"