倒排序查看数据库里各个表所占用的空间

create table tmp (name varchar(50),rows int,reserved varchar(50),
  data varchar(50),index_size varchar(50),unused varchar(50))
insert into tmp (name,rows,reserved,
  data,index_size,unused) exec sp_msforeachTable @Command1="sp_spaceused '?'"
select * from tmp order by len(reserved) desc, reserved desc

drop table tmp

-- sp_spaceused 查看库占用空间

-- sp_spaceused table_name 查看表占用空间