SQL Server DEMO's: SQL Internals Heaps & Indexes!!

Set up a SQL Server 2022 Instance in SECONDS (AND FREE!)

SQL Server Internals: HEAPS VS. CLUSTERED INDEXES! (The Concepts)

chapters
00:00 Introduction
00:38 Create demo database
00:55 Create Clustered Index & Look at the internals
01:26 Split the index
02:09 Look at the Root Page
03:08 Rebuilding an Index
03:41 Create a Heap
04:36 Heaps vs. Clustered Indexes Performance
05:57 Clustered Index Internals w Uniquifier
07:19 Creating Non-Clustered Indexes & Key Lookups
08:41 Heap's RID Lookups & Non-Clustered Indexes
11:55 What did we cover?