SELECT DB_NAME(database_id) AS DatabaseName,
       SUM(CASE WHEN type=0 THEN size ELSE 0 END) AS MdfSize,
       SUM(CASE WHEN type=1 THEN size ELSE 0 END) AS LdfSize
FROM sys.master_files
GROUP BY database_id