We are continuing the discussion of Physical Storage with Part 4 of this topic.
In this installment, Kalen will tell you about Clustered Index storage, using examples from SQL Server 2016 and SQL Server 2017.
Most of the information covered will also be relevant to SQL Server 2014 and SQL Server 2012 as well.
Specific topics include:
- Heaps vs B-Trees
- Clustered index leaf level
- Uniqueifiers
- Upper levels of clustered index
