nyf1989的专栏

1、查询死锁 EXEC sp_lock // SELECT TOP 1 * FROM sysobjects WHERE id=1141579105 2、干掉死锁 kill id 3、查询整个数据库中某个字段值在哪个表的哪个字段中存在 CREATE PROCEDURE [dbo].[SP_FindValueInDB] ( @value VARC...

--SQL Server常用的性能计数器 SQLServer:Plan Cache ----Cache Hit Ratio SQLserver:Buffer Manager----Buffer Cache Hit Ratio SQLServer:Locks---- Lock Waits/sec SQLServer:Access Methods----Full Scans/...