use [tempdb]

go

select * from sys.database_files

select * from sys.master_files where database_id = 2

go

Produces two different "sizes" in pages

select * from sys.database_files

gives me "size" on disk. (free +used)

select * from sys.master_files where database_id = 2

gives me "size" used