New
11/11/2026 What Is a Page Split in SQL Server?
A page split happens when an 8 KB data page has no room for a row. Learn how it fragments SQL Server indexes, how to detect it, and when to worry.
Notes on how SQL Server stores data, builds execution plans, and behaves under load. You will find page splits, plan choices, and query rewrites with scripts to run. This is the section for storage internals and query tuning.
1 articles
A page split happens when an 8 KB data page has no room for a row. Learn how it fragments SQL Server indexes, how to detect it, and when to worry.