SELECT o.name as table_name, rv.value as partition_range,<br>fg.name as file_groupName, p.partition_number,max(p.rows) as number_of_rows,<br>sum(au.total_pages) *<em>8/1024.0 [Total MB],sum(au.used_pages)</em>*8/1024.0 [Used MB]<br>FROM sys.partitions p<br>INNER JOIN sys.indexes i ON p.object_id = i.object_id AND p.index_id = i.index_id<br>INNER JOIN sys.objects o ON p.object_id = o.object_id<br>INNER JOIN sys.system_internals_allocation_units au ON p.partition_id = au.container_id<br>INNER JOIN sys.partition_schemes ps ON ps.data_space_id = i.data_space_id<br>INNER JOIN sys.partition_functions f ON f.function_id = ps.function_id<br>INNER JOIN sys.destination_data_spaces dds ON dds.partition_scheme_id = ps.data_space_id AND dds.destination_id = p.partition_number<br>INNER JOIN sys.filegroups fg ON dds.data_space_id = fg.data_space_id<br>LEFT OUTER JOIN sys.partition_range_values rv ON f.function_id = rv.function_id AND p.partition_number = rv.boundary_id<br>group by o.name, rv.value,fg.name, p.partition_number;