/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 vote320 views1 answer
Postgresql transaction discard all
SQL
0 vote295 views1 answer
Get number of table colums in sql query
SQL
18 votes343 views3 answers
Mysql add column default value
SQL
0 vote335 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
8 votes343 views2 answers
Replace string value in sql
SQL
0 vote326 views4 answers
Mysql on kubernetes
SQL
2 votes319 views2 answers
Get all columns from table sql
SQL
0 vote302 views1 answer
Sql right characters
SQL
23 votes327 views1 answer
How remove column in mysql
SQL
0 vote324 views1 answer
Monthly Birthday SQL Query
SQL