Sql Server Tablo Boyutlarını Gösteren Sorgu

Aşağıdaki Sql Scriptini Kullanarak Hangi Tabloda Kaç Satır var MB olarak Ne Kadar Yer Kaplıyor öğrenebilirsiniz

SELECT 
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    (SUM(a.total_pages) * 8) / 1024 AS TotalSizeMB,
    (SUM(a.used_pages) * 8) / 1024 AS UsedSizeMB,
    (SUM(a.data_pages) * 8) / 1024 AS DataSizeMB
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
INNER JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
WHERE 
    t.is_ms_shipped = 0
GROUP BY 
    t.Name, s.Name, p.Rows
ORDER BY 
    TotalSizeMB DESC;