34,576
社区成员
发帖
与我相关
我的任务
分享
select top 100
name as indexname
,object_name(id) as tablename
,used
,rows
,indid
from sysindexes
order by used desc
sp_spaceused
/*
database_name database_size unallocated space
---------------------- ------------------ ------------------
master 263.31 MB 257.67 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
5008 KB 2648 KB 1952 KB 408 KB
*/
DBCC SHRINKFILE
( 1 , 10 )
sp_spaceused
/*
database_name database_size unallocated space
---------------------- ------------------ ------------------
master 10.75 MB 5.06 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
5056 KB 2640 KB 1952 KB 464 KB
*/