ITPub博客

declare @dbid intselect @dbid = db_id()select bjectname=object_name(s.object_id), s.object_id, indexname=i.name, i.index_id            , user_seeks, user_scans, user_look...

DECLARE@USER_ID INT, @KILLCMD VARCHAR(100)-- 根据选择条件，选择出应该取消的进程DECLARE cur_lock CURSOR FORSELECT spid FROM master..sysprocessesWHEREblocked = 0AND spid IN (SELECT blocked FROM mas...

  IF   SERVERPROPERTY('ServerName')<>@@SERVERNAME     BEGIN     DECLARE   @srvname   sysname     SET   @srvname=@@SERVERNAME &nbsp...

use mastergocreate procedure sp_who_lockasbegindeclare @spid int,@bl int,@intTransactionCountOnEntry int,        @intRowcount    int,        @intCount...

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 wher...

sp_autostats 'table_name';

declare  @maxfrag DECIMALselect @maxfrag = 90--声明变量SET NOCOUNT ONDECLARE @tablename VARCHAR (128)DECLARE @execstr VARCHAR (255)DECLARE @objectid INTDECLARE @objectowner VARCHAR(255)DECLARE @i...