/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

62 votes315 views8 answers
Mysql add column
SQL
2 votes254 views2 answers
How to rename column name in sql server using query
SQL
0 vote273 views1 answer
Uncheck constraints and delete from table
SQL
1 vote256 views1 answer
Media sql
SQL
0 vote270 views1 answer
Edit shchima table in sql
SQL
0 vote254 views1 answer
Sql select rows with different values in one column
SQL
0 vote245 views1 answer
Alter precision
SQL
0 vote208 views1 answer
Check id exist or not in sql
SQL
0 vote262 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote268 views1 answer
Sql select max value from multiple rows
SQL