【sqlserver】查询 表的大小
renjixinchina
2012-08-31 17:40:43
Linux操作系统
原创
select object_name(id) tablename,
8*reserved/1024 reserved,
rtrim(8*dpages/1024)+'Mb' used,
8*(reserved-dpages)/1024 unused,
8*dpages/1024-rows/1024*minlen/1024 free,
rows,* from sysindexes
where indid=1
order by reserved desc
[sqlserver] 查看表的统计信息
【sqlserver】查询阻塞存储过程sp_who_lock