Posted inSQL Server
SQL Server Page Types
There are lots of different page types and Paul Randall list them in his article. However as I tend to have a rather poor memory for remembering them first off…
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 Servers Virtual Columns and Row Cracking
In order to access row structures there are several functions within SQL Server that are beneficial. I have listed these below with the descriptions taken from the actual functions. sys.fn_GetRowsetIdFromrowdump --…
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…