SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats

(Pinalkumar Dave) In the recent Query Tuning project, one of the developers who were helping me out in the project asked me if there is any way that he could know how many pages are used by any Index, and if there is any way I could demonstrate the different levels of B-Tree.

Read More - Register for Free Membership