Monthly Archives: April 2016

How big are all databases on this server?

List the sizes of all databases on the server.   select db_name(database_id), physical_name, size, (size / 128) as size_MB, (size / 128)/1024 as size_GB from master.sys.master_files where type_desc = ‘ROWS’ order by db_name(database_id)