July, the 31 Days of SQL Server DMO’s – Day 21 (sys.dm_db_partition_stats)
- by Tamarick Hill
The sys.dm_db_partition_stats DMV returns page count and row count information for each table or index within your database. Lets have a quick look at this DMV so we can review some of the results. **NOTE: I am going to create an ‘ObjectName’ column in our result set so that we can more easily identify tables. SELECT object_name(object_id)…