Query the size of the SQL Server tablespace to see which tables occupy space

From: blog. csdn. nethtl258articledetails4029767 no droptable ## goexecsp_MSForEachTable @ precommandNcreatetable # (table name sysname, number of records int, reserved space Nvarchar (10), used space varchar (10 ), the index uses varchar (10), but does not use varchar (

From: http://blog.csdn.net/htl258/article/details/4029767 without drop table # goexec sp_MSForEachTable @ precommand = n' create table # (table name sysname, number of records int, reserved space Nvarchar (10 ), use space varchar (10), index use space varchar (10), unused space varchar (

From: http://blog.csdn.net/htl258/article/details/4029767
<无>

Drop table # goexec sp_MSForEachTable @ precommand = n' create table # (table name sysname, number of records int, reserved space Nvarchar (10), use space varchar (10 ), the index uses the space varchar (10), but does not use the space varchar (10) ', @ command1 = n' insert # exec sp_spaceused ''? ''', @ Postcommand = n' select * from # order by record count'