Listing 2: Saving DBCC IND Output and Retrieving the Most Relevant Columns

TRUNCATE TABLE sp_table_pages
INSERT INTO sp_table_pages
   EXEC ('dbcc ind ( tempdb, hugerows, -1)'  )
SELECT PageFID, PagePID, iam_chain_type, pageType
FROM sp_table_pages