Community

sys.dm_db_partition_stats

(Louis Davidson) For the current database, gives you space oriented statistics for each partition of indexes (even if you only have one partion), like row count, page counts, etc. Resembles the sysindexes in previous versions of SQL Server, with more information.

Read More - Register for Free Membership