Category: SQL Server Internals

• 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…]

• The Page – How SQL Server Stores Data

  

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

  SQL Server organizes all data into virtual containers called pages. The DBCC PAGE command can be used to explore these pages. This post starts a series about pages in SQL Server.

  [more…]

• Log Reuse Waits Explained: CHECKPOINT

  

  2014-01-13 - General, Log Reuse Wait, Series, SQL Server Internals, Transaction Log

  Is your SQL Server transaction log file growing with a log reuse wait of CHECKPOINT? Read on to find out what is causing this and what you can do about it.

  [more…]