/SQL/Check the size of the tables here ordered from the biggest size

Check the size of the tables here ordered from the biggest size

SELECT
t.NAME AS TableName,
s.Name AS SchemaName,
p.rows,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,
CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB
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
LEFT OUTER JOIN
sys.schemas s ON t.schema_id = s.schema_id
WHERE
t.NAME NOT LIKE 'dt%'
AND t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
t.Name, s.Name, p.Rows
ORDER BY
TotalSpaceMB DESC, t.Name

Similar codes

1 vote332 views1 answer
Sql delete all values in a column
SQL
0 vote329 views1 answer
Microsoft word insert sql code
SQL
1 vote429 views1 answer
Mysql get max value and id
SQL
0 vote383 views1 answer
SQL Cut part string
SQL
0 vote372 views1 answer
Oarcale list objects
SQL
2 votes362 views1 answer
Search query in mysql
SQL
1 vote352 views1 answer
Tsql create unique index composite
SQL
15 votes340 views3 answers
Find duplicate keys in mysql
SQL
8 votes332 views1 answer
Mysql restore database
SQL
1 vote337 views1 answer
Mysql count words
SQL