SQL & databasesSQL

SQL Server – DB Space Report (T-SQL)

Report SQL Server database space usage.

SQL
-- 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