Find Size of all Databases in SQL Instance in GB

SELECT

distinct d.name AS 'Database',

SUM(m.size * 8/1024000) OVER (PARTITION BY d.name) AS 'Database Total Size GB'

FROM sys.master_files m

INNER JOIN sys.databases d ON

d.database_id = m.database_id;

Recent Posts

--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...

select schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...

--Execute the following script against the User Database where you need to find DB User permission. DECLARE @sql VARCHAR(2048) ,@sort INT...