<t><br/>
SELECT <br/>
t.name AS TableName,<br/>
s.name AS SchemaName,<br/>
p.rows,<br/>
SUM(a.total_pages) * 8 AS TotalSpaceKB, <br/>
CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,<br/>
SUM(a.used_pages) * 8 AS UsedSpaceKB, <br/>
CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB, <br/>
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,<br/>
CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB<br/>
FROM <br/>
sys.tables t<br/>
INNER JOIN <br/>
sys.indexes i ON t.object_id = i.object_id<br/>
INNER JOIN <br/>
sys.partitions p ON i.object_id = p.object_id AND i.index_id = p.index_id<br/>
INNER JOIN <br/>
sys.allocation_units a ON p.partition_id = a.container_id<br/>
LEFT OUTER JOIN <br/>
sys.schemas s ON t.schema_id = s.schema_id<br/>
WHERE <br/>
t.name NOT LIKE 'dt%' <br/>
AND t.is_ms_shipped = 0<br/>
AND i.object_id > 255 <br/>
GROUP BY <br/>
t.name, s.name, p.rows<br/>
ORDER BY <br/>
TotalSpaceMB DESC, t.name<br/>
<br/></t>
