CREATE TABLE #TableSizes (name sysname, rows varchar(16), 
reserved varchar(16), data varchar(16), index_size varchar(16),unused varchar(16)) 
INSERT #TableSizes 
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'" 
SELECT TOP (100) * FROM #TableSizes 
ORDER BY DATA desc 

-- Create a tableSizes table which displays the same information as Disk Usage by Top Tables report.
-- Ben Brugman
-- 20121017
-- Part of the source comes from:  
--             http://database.ittoolbox.com/groups/technical-functional/sql-server-l/tables-sizes-in-a-db-4071428

CREATE TABLE ##TableSizes (name sysname, rows varchar(16), 
reserved varchar(16), data varchar(16), index_size varchar(16),unused varchar(16)) 
INSERT ##TableSizes 
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'" 

update ##TableSizes set
Reserved = replace(reserved,'kb',''),
index_size = replace(reserved,'kb',''),
data = replace(reserved,'kb',''),
unused = replace(reserved,'kb','')

CREATE TABLE ##TableSizes2 (name sysname, rows bigint, 
reserved bigint, data bigint, index_size bigint,unused bigint) 
insert into ##TableSizes2 select * from  ##TableSizes

SELECT TOP (1000) * FROM ##TableSizes2 
ORDER BY reserved desc
drop table ##TableSizes
drop table ##TableSizes2

We walk in the dark places no others will enter
We stand on the bridge and no one may pass