查看SQL SERVER表的空间使用情况

查看SQL SERVER表的空间使用情况，特此记录：

 

create table #tmp_1 (name varchar(50),rows int,reserved varchar(50),
  data varchar(50),index_size varchar(50),unused varchar(50))

 

insert into #tmp_1 (name,rows,reserved,
  data,index_size,unused)
exec  sp_MSforeachtable @command1="exec sp_spaceused  '?'"

 

select * from #tmp_1

 

select name,rows,CONVERT(int, REPLACE(reserved,' KB','')) reserved,
  CONVERT(int,REPLACE(data,' KB','')) data,
  CONVERT(int,REPLACE(index_size,' KB','')) index_size,
  CONVERT(int,REPLACE(unused,' KB','')) unused
  into #tmp_2
  from #tmp_1
 
select * from #tmp_2

 

select COUNT(*),SUM(reserved),SUM(data),SUM(index_size),SUM(unused) from #tmp_2

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-735669/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-735669/