SQL Server 2008: How to query all databases sizes?

with fs

as

(

    select database_id, type, convert(numeric(18,2),round((size * 8.0 / 1024),2)) size

    from sys.master_files

)

select

    name,

    (select sum(size) from fs where type = 0 and fs.database_id = db.database_id) DataFileSizeMB,

    (select sum(size) from fs where type = 1 and fs.database_id = db.database_id) LogFileSizeMB

from sys.databases db