How to check Database name with Size:
select sys.databases.name, CONVERT(varchar,SUM(Size)*8/1024)+' MB' AS [Total disk space] From sys.databases join sys.master_files on sys.databases.database_id=sys.master_files.database_id group by sys.databases.name order by sys.databases.name