摘要： 最近一直纠结于Sqlserver的换行和回车的处理，想了很多办法都不行。最后没有办法，百度了下:网上解答的原话： 中英文空格的ASCII值为32，而对于控制字符，制表符、换行符和回车符分别是是char(9)、char(10)和char(13)。于是selectREPLACE(replace(value,CHAR(32),''),CHAR(13)+CHAR(10),'') 阅读全文

摘要： declare @LgReads bigintselect @LgReads=cntr_value from master.dbo.sysperfinfo where counter_name='Page lookups/sec' if object_id(N'tempdb.dbo.#waits') is not null GOTO InsertTb if object_id(N'tempdb.dbo.#waits') is null GOTO CreateTbCreateTb: create table #waits (type varchar 阅读全文

摘要： SELECT @@SERVERNAME go SELECT @@VERSION go --select process SELECT spid, kpid, blocked , CAST(waittime AS BIGINT) as waittime, lastwaittype, waitresource, dbid, uid , CAST(cpu / 1000 AS BIGINT) as cpu , CAST(physical_io AS BIGINT) as physical_io, memusage, login_time , last_batch , ecid ,... 阅读全文