Database space and logical files destination

EXEC sp_helpdb N'Baza55';

EXEC sp_databases;

SELECT
name,
size,
size * 8/1024 'Size (MB)',
max_size
FROM sys.master_files
WHERE DB_NAME(database_id) = 'Baza55';

----

SELECT
d.name AS 'Database',
m.name AS 'File',
m.size,
m.size * 8/1024 'Size (MB)',
SUM(m.size * 8/1024) OVER (PARTITION BY d.name) AS 'Database Total',
m.max_size
FROM sys.master_files m
INNER JOIN sys.databases d ON
d.database_id = m.database_id;

---------

EXEC sp_spaceused;