Tag: DBCC IND

• The sys.dm_db_database_page_allocations DMF

  

  2014-07-09 - General, Series, SQL Server 2012, SQL Server Internals, Storage Wednesday

  Are you looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a particular table (or even all tables in a database).

  [more…]

• The Index Allocation Map (IAM)

  

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

  SQL Server tracks the pages that belong to an allocation unit through special index allocation map pages, also called IAM pages. Each IAM page covers a single GAM-interval of the database file. All IAM pages of a single allocation unit together build an IAM-chain. Read on to find out more.

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