Quick way to get size of databases on a sql server instance

Here is a dirty little sql that will give you the size of all the databases in your instance :

select DB_NAME(database_id) as DatabaseName, sum((size*8/1024) SizeInMB
from sys.master_files
group by database_id;

This will list all the databases in the instance and add the size of the database file and log file.