Posted inSQL Server
SQL Server Row Internals
Row Storage A Row is stored on a Page which is 8192 Bytes, and this is broken down in two key areas when considering physical storage. Firstly on all pages…
Posted inSQL Server
SQL Server Max Row Size 8060 Part 2
In my previous post on row maximum length I showed that the largest row size that could be stored on page was 8053 byte. So to recap a table with…
Posted inSQL Server
SQL Server Max Row Size 8060
When asked the size of the largest row that could be placed on to a single SQL Server data page the answer that most give is 8060 bytes. If you…
Posted inSQL Server
Delta and Cumulative IO Stats
Checking IO statistics has always been one of the most important metrics for any DBA. It is no surprise that most people I know will have some version of the…