Row-Overflow and LOB: When a Row Leaves the Page
This post is part of the series. The contents page lists every part in order. A data page is 8 KB, and a single row is capped at 8,060 bytes of in-row data.[1] So what…
Seeing Exactly Where SQL Server Stores Each Column
You add a couple of varchar(max) columns to a table because you are not sure how big the values will get. Most rows hold a few dozen characters. A handful hold tens of thousands. Everything…