--Database
SELECT SUM(reserved_page_count) * 8.0 / 1024 AS 'Total Reserved Space (MB)'
FROM sys.dm_db_partition_stats
--Objects
SELECT name,
reserved_page_count * 8.0 / 1024 AS 'Total Reserved Space (MB)'
FROM sys.dm_db_partition_stats ps
JOIN sys.objects so
ON ps.object_id = so.object_id