select object_name(i.object_id) as objectName, i.name as indexName,
sum(a.total_pages) as totalPages, sum(a.used_pages) as usedPages, sum(a.data_pages) as dataPages,
(sum(a.total_pages) * 8) / 1024 as totalSpaceMB, (sum(a.used_pages) * 8) / 1024 as usedSpaceMB, (sum(a.data_pages) * 8) / 1024 as dataSpaceMB
from sys.indexes i
join sys.partitions p on i.object_id = p.object_id and i.index_id = p.index_id
join sys.allocation_units a on p.partition_id = a.container_id
group by i.object_id, i.index_id, i.name
order by 1, 2
