/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 vote111 views1 answer
Mysql get domain from url
SQL
0 vote111 views1 answer
Fast sql column count
SQL
3 votes111 views2 answers
Oracle sql drop sequence
SQL
2 votes115 views1 answer
How to get weekday from old date in sql
SQL
0 vote124 views1 answer
Define a variable in mysql from select
SQL
23 votes104 views6 answers
Delete all rows from table sql
SQL
0 vote96 views1 answer
Alter column to not null with default value sql server
SQL
0 vote103 views1 answer
Uuid sqlalcomany
SQL
0 vote191 views1 answer
Run mysql xampp shell
SQL
0 vote112 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL