/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

4 votes143 views3 answers
Check if two date ranges overlap sql server
SQL
3 votes158 views2 answers
Oracle sql first day of month
SQL
1 vote131 views1 answer
Right outer vs left outer join
SQL
1 vote148 views1 answer
Sql group by sum with condition
SQL
0 vote82 views1 answer
Psql not found windows
SQL
1 vote139 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
2 votes121 views1 answer
Mysql find tables with name
SQL
0 vote127 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
5 votes123 views1 answer
Mysql select greater than yesterday
SQL
4 votes133 views1 answer
Oracle user tables
SQL