SELECT TOP(100) o.[object_id]
              , obj_name = s.[name] + '.' + o.[name]
              , index_name = i.[name]
              , total_space = CAST(i2.total_pages * 8. / 1024 AS DECIMAL(18, 2))
FROM sys.objects o
JOIN sys.indexes i ON i.[object_id] = o.[object_id]
JOIN sys.schemas s ON o.[schema_id] = s.[schema_id]
JOIN (
    SELECT p.[object_id]
            , p.index_id
            , total_pages = SUM(a.total_pages)
    FROM sys.partitions p
    JOIN sys.allocation_units a ON p.[partition_id] = a.container_id
    GROUP BY p.[object_id]
            , p.index_id
) i2 ON o.[object_id] = i2.[object_id] AND i2.index_id = i.index_id
WHERE o.[type] IN ('V', 'U')
    AND o.is_ms_shipped = 0
ORDER BY i2.total_pages DESC