select FILEGROUP_NAME(i.data_space_id) as file_group
, o.name
, i.index_id
, i.name as index_name
, s.size_MB
from sys.indexes i
join sys.all_objects o
on i.[object_id] = o.[object_id] and o.type=’U’
cross apply
(select convert(numeric(10,2),
SUM(in_row_data_page_count
+ lob_used_page_count
+ row_overflow_used_page_count) * 8/1024.0) size_MB
from sys.dm_db_partition_stats where object_id=o.object_id and index_id=i.index_id) s
order by 1,2,3
Simon's SQL 