Database Animations: You’ve Heard of Page Splits. Here’s What They Really Mean.
Explains database page splits with animations, their impact on writes and disk order, and historical context with hard drives.
Explains database page splits with animations, their impact on writes and disk order, and historical context with hard drives.
An animated explanation of how SQL Server index seeks work, covering B-tree root pages, intermediate pages, and leaf pages.
Explores database indexing tradeoffs between B-Trees, LSM Trees, and other index types in query engine design.