-开启执行时间统计
SET STATISTICS TIME ON
-开启IO性能统计
SET STATISTICS IO ON
--查询表的统计索引
SET STATISTICS TIME ON
-开启IO性能统计
SET STATISTICS IO ON
--查询表的统计索引
SELECT * FROM SYSINDEXES WHERE ID=OBJECT_ID('tablename') AND NAME LIKE '_WA%'
--删除索引
DROP STATISTICS tablename.indexname
--查询阻塞进程
SELECT * FROM SYS.SYSPROCESSES WHERE BLOCK<>0
--进程执行语句
DBCC INPUTBUFFER(spid)
--开启执行计划
Ctrl + M