Home Forums Article Discussions Article Discussions by Author Discuss content posted by David Durant Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2 RE: Stairway to SQL Server Indexes: Step 2, Deeper into Nonclustered Indexes

  • November 26, 2014 at 4:22 am

    #1761040

    Uwe Ricken (11/26/2014)

    Hi Faraz,

    you can use DBCC IND if you use SQL Server < 2012 or sys.dm_db_database_page_allocation for SQL Server >= 2012.

    This will give you a list of allocated pages.

    To have a look at the root node (or any other page of the index you use

    DBCC PAGE

    More details about can be found here:

    http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/12/13/more-undocumented-fun_3a00_-dbcc-ind_2c00_-dbcc-page_2c00_-and-off_2d00_row-columns.aspx

    Helpful as this response may be, it does not answer Faraz' question.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.