Category: Series

• The Extent (A Storage Wednesday Post)

  

  2014-03-19 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server organizes database pages in groups of 8 called extents. An extent is the smallest unit that SQL Server will reserve on disk. However, smaller tables are still possible through mixed extents. Read on to get all the details.

  [more…]

• The Row Header (A Storage Wednesday Post)

  

  2014-03-12 - General, Series, SQL Server Internals, Storage Wednesday

  The row header contains metadata describing the row. It contains information about the row type, the column count and a NULL-bitmap. Read on to get all the details.

  [more…]

• Finding table pages with DBCC IND (A Storage Wednesday Post)

  

  2014-03-05 - General, Series, SQL Server Internals, Storage Wednesday

  Are you trying to use DBCC PAGE and need a way to find all pages that belong to a table? That is exactly what DBCC IND can help with. Read on to get all the details.

  [more…]

• Data Pages and the Row Offset Array

  

  2014-02-26 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server stores actual table data in pages of type 1, data pages. Read on to see how to navigate a data page and how to find each row using the row offset array.

  [more…]

• The Page Header (A Storage Wednesday Post)

  

  2014-02-19 - General, Series, SQL Server Internals, Storage Wednesday

  SQL Server organizes databases in chunks of 8192 bytes, called pages. Each page starts out with 96 byte of meta-information – the page header. Read on to see what kind of information is stored in this special area.

  [more…]