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;