7 tables partitioned by month, 41 partitions, each month is in its own file and filegroup. The name of the file and the filegroup it belongs to is the same.

The first and the last partitions are always empty. Ideally I want to exclude them and only have the files that became empty as a result of partition switching and archival.