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!