SQL Server – DB Space Report (T-SQL)
Report SQL Server database space usage.
-- Run in master
SELECT
DB_NAME(database_id) AS [Database],
CAST((SUM(total_page_count)*8.0)/1024 AS DECIMAL(10,2)) AS [SizeMB]
FROM sys.dm_db_file_space_usage
GROUP BY database_id
ORDER BY [SizeMB] DESC;
From Joseph Nakhle's automation workbench.
More SQL & databases scripts