SQL Server 排序数据表使用空间大小

create table #t(name varchar ( 255 ), rows bigint , reserved varchar ( 20 ), data varchar ( 20 ), index_size varchar ( 20 ), unused varchar ( 20 ))
exec sp_MSforeachtable " insert into #t exec sp_spaceused ' ? ' "
select * from #t order by len (data) desc
drop table #t

转载于:https://www.cnblogs.com/xpp123/archive/2011/07/05/2098075.html