Дабы не потерять!

DBCC UPDATEUSAGE (0);
create table #t(name varchar(255), row varchar(255), reserved varchar(255), data varchar(255), inxex_size varchar(255), unused varchar(255))
insert into #t
  exec sp_msforeachtable N'exec sp_spaceused ''?'''
select * from #t order by CONVERT(bigint,REPLACE(data,' KB','')) DESC
drop table #t