Get size of all tables in database

SELECT o.name AS ObjectName, SUM(reserved_page_count) * 8.0 / 1024 AS SizeinMB FROM sys.dm_db_partition_stats AS ps INNER JOIN sys.sysobjects AS o ON ps.object_id = o.id GROUP BY o.name ORDER BY SizeinMB DESC;