Understanding SQL Server Page Structure: How Page Splits Affect Performance - Video Series Video Category: 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:

If you see a file/folder that is blue in color in Windows Explorer that is an indication that the file is compressed SQL Server 2000 Service Pack 4 Features: Includes a new version of MSXML: MSXML 3.0 SP6 SQL Server 2000 Resource Kit - More Helpful Tools: SQL DMO has many nice examples of using DMO to script your SQL Server administration