- 博客(2)
- 资源 (6)
- 收藏
- 关注
原创 SQL Server KILL Sleeping进程
DECLARE @SPID AS INTDECLARE @COUNT AS INT=0DECLARE curSPID CURSOR FORSELECT A.SPID --,DB_NAME(A.DBID) DB,A.login_time,SUBSTRING(SUSER_SNAME(sid),1,30) 登陆帐号,A.CMD,A.open_tran,A.last_batch,A.hostnam
2016-12-13 15:50:22 3474
transaction-log-management
This covers performing transaction log backup and restore, monitoring and managing log growth, including quick diagnosis of the causes of rapid growth, and optimizing log architecture to maximize log throughput and availability.
2013-06-06
How to boost DB server's performance
From this file,you can learn some tips of SQL scricp,useful DBCC commands etc. Besides, you can learn how to use SQL Server Profiler,DTA and so forth.
2008-09-25
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人