/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

2 votes231 views1 answer
Oracle current date without time
SQL
0 vote225 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote362 views1 answer
Sql change a colum to unique
SQL
0 vote227 views1 answer
Mysqldump ignore table
SQL
1 vote243 views2 answers
Get table column names sql laravel
SQL
0 vote242 views1 answer
MySQL INSERT IGNORE Statement
SQL
12 votes254 views6 answers
Distinct in sql server
SQL
0 vote238 views1 answer
Select multiple row from primary key sql
SQL
11 votes247 views3 answers
Sql line numbers
SQL
1 vote245 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL