Question on sys.dm_db_partition_stats

  • When you create two tables, one is partitioned, one is not. When you look at the usage of the tables using sys.dm_db_partition_stats, both table shows a row where partition_number = 1. If by default, all tables created are using the PRIMARY filegroup, and then the Partitioning Scheme uses a different filegroup (say FG1, FG2 and so on, but no PRIMARY), how will you separate that out? Is there another table to join it with to get the filegroup information?

    Thanks a lot!

  • I've found the answer from this site and even better. The script to find the "Table Disk Space Usage By Filegroup and Partition".

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply