So MS SQL Server stores all data in rows that fit onto 8kb pages.There are many different types of pages in MS SQL Server but for this blog we are mainly concerned with three, these are:1. Data Pages2. Text/Image Pages, sometimes referred to as LOB pages.3. Index Pages The names are fairly self-explanatory but forContinue reading “MS SQL Server Page Storage”
SQL Server, AWS, Postgres, Microsoft, NoSQL
The Front-line Database Blog 