Found max big table

found max big table

select object_name(p.object_id), 
(sum(au.total_pages)*8)/1024 as [space_in_mb] 
from sys.partitions p 
join sys.allocation_units au on p.hobt_id = au.container_id 
group by p.object_id 
order by [space_in_mb] desc