• With the introduction of sys.dm_db_database_page_allocations in SQL Server 2012 we probably shouldn't be using DBCC IND any more - not because sys.dm_db_database_page_allocations is any less unofficial than DBCC IND (both are totally unofficial as far as I know) but because it (a) provides more information that DBCC IND and (b) gives us the information in the form of a nice system view which we can select from and join with other tables and so on without having to create a temporary table to hold the information.

    Tom