1SELECT
2 OBJECT_NAME([I].[object_id]) AS [object_name]
3 ,[P].[partition_number]
4 ,[FG].[name] AS [filegroup_name]
5 ,[P].[rows]
6 ,[AU].[total_pages]
7 ,CASE [PF].[boundary_value_on_right]
8 WHEN 1 THEN
9 'Less than'
10 ELSE
11 'Less or equal than'
12 END AS [compare]
13 ,[PRV].[value]
14FROM
15 [sys].[partitions] [P]
16JOIN
17 [sys].[indexes] [I] ON [P].[object_id] = [I].[object_id]
18 AND [P].[index_id] = [I].[index_id]
19JOIN
20 [sys].[partition_schemes] [PS] ON [PS].[data_space_id] = [I].[data_space_id]
21JOIN
22 [sys].[partition_functions] [PF] ON [PF].[function_id] = [PS].[function_id]
23LEFT OUTER JOIN
24 [sys].[partition_range_values] [PRV] ON [PF].[function_id] = [PRV].[function_id]
25 AND [P].[partition_number] = [PRV].[boundary_id]
26JOIN
27 [sys].[destination_data_spaces] [DDS] ON [DDS].[partition_scheme_id] = [PS].[data_space_id]
28 AND [DDS].[destination_id] = [P].[partition_number]
29JOIN
30 [sys].[filegroups] [FG] ON [DDS].[data_space_id] = [FG].[data_space_id]
31JOIN
32(SELECT [container_id], SUM([total_pages]) AS [total_pages] FROM [sys] .[allocation_units] GROUP BY [container_id]) [AU] ON [AU].[container_id] = [P].[partition_id]
33WHERE
34 [I].[index_id] < 2;