/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

0 vote197 views2 answers
How to find max and min salary in sql
SQL
0 vote213 views1 answer
Group by two columns postgres
SQL
0 vote217 views1 answer
Sqlalchemy empty table
SQL
0 vote178 views1 answer
Month mysql
SQL
4 votes228 views1 answer
Oracle nls_date_format
SQL
20 votes200 views5 answers
Reset auto increment mysql
SQL
1 vote209 views1 answer
Tsql find foreign key references
SQL
0 vote208 views1 answer
Mariadb maximum left join
SQL
0 vote205 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
12 votes196 views1 answer
How to change the value of a table in sql
SQL