Note: Lifetime Access

Abstract: After Level 1, here comes Level 2. In Level 1, we understood the basics of SQL Server Indexes – Clustered, Non-Clustered, INCLUDE, SCAN, SEEK, etc. In Level 2, we will go one level deeper into the world of SQL Server Indexes. We will understand the concepts of Page Splits, Fragmentation, etc, along with understanding forward pointers. We will review the internals of the page and how the data is stored. We will see clustered & non-clustered index key choices and non-clustering key choices and discuss best practices along the way. As always, no PPT, 60-minute demo-packed session. This is a level 200 session.