SELECT SCHEMA_NAME(t.schema_id) [Owner],
       t.name AS [表名],
       p.rows AS [行数],
       SUM(a.total_pages) * 8 / 1024 / 1024.00 AS [表总占用(GB)],
       SUM(a.total_pages) * 8 / 1024.00 AS [表总占用(MB)],
       SUM(a.used_pages) * 8 / 1024.00 / 1024 AS [索引占用(GB)],
	   SUM(a.used_pages) * 8.00 AS [索引占用(KB)],
	   SUM(a.used_pages) * 8 / 1024.00 AS [索引占用(MB)]
FROM sys.tables t
    INNER JOIN sys.indexes i
        ON t.object_id = i.object_id
    INNER JOIN sys.partitions p
        ON i.object_id = p.object_id
           AND i.index_id = p.index_id
    INNER JOIN sys.allocation_units a
        ON p.partition_id = a.container_id
WHERE t.name NOT LIKE 'dt%'
      AND t.is_ms_shipped = 0
      AND i.object_id > 255
GROUP BY SCHEMA_NAME(t.schema_id),
         t.name,
         p.rows
ORDER BY [表总占用(MB)] DESC;