TableSpace.sql

create table #space
(
    tn            varchar(128),
    rows        varchar(128),
    reserved    varchar(128),
    data        varchar(128),
    indexp        varchar(128),
    unused        varchar(128)
)

insert #space
exec sp_msforeachtable 'exec sp_spaceused ''?'''

select * from #space order by convert(int, substring(reserved, 1, len(reserved)-3)) desc
drop table #space