Page - Jon Gurgul's Blog

SQL Index dm_db_index_xxx_stats

There are 3 dm_db_index_xxx_stats objects that can be used to check and investigate index information. sys.dm_db_index_usage_stats can be used to see how beneficial the index is, and its related maintenance…

Jon Gurgul 2014-12-27

SQL 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…

Jon Gurgul 2013-06-02

SQL 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…

Jon Gurgul 2013-05-27

SQL Server

TORN_PAGE_DETECTION Internals (SQL 2005 onwards)

CHECKSUM is in the majority of cases the more appropriate PAGE_VERIFY option as it provides a much more complete check (slightly higher overhead) when compared to TORN_PAGE_DETECTION. I thought today however I…

Jon Gurgul 2012-06-22

SQL 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…

Jon Gurgul 2012-06-09

SQL 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…

Jon Gurgul 2012-04-13