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).
The Server Configuration Page is the place where SQL Server stores its configuration values (sp_configure). It is of a special page type that is found only once per SQL Server instance. Read on to get all the details.
The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.[more…]
Every SQL Server database file has a dedicated file header page. Read on to discover how to use DBCC FILEHEADER to explore the header of your database files and learn about the one property of file header pages that might just affect your backup and restore strategy.
SQL Server uses the Differential Changed Map to determine, which pages changed since the last full backup. Read on to find out how the DCM is working.