02 2021 档案

SQL Server2008R2 死锁进程杀掉处理
摘要：select request_session_id spid,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' AND OBJECT_NAM 阅读全文
posted @ 2021-02-21 10:35 violety 阅读(348) 评论(0) 推荐(0) 编辑
Sql Server 2008R2 查看SQL语句运行时间
摘要：SET STATISTICS TIME ON; SELECT parentcode AS parentid, regionnumber AS id, regionname AS name, regionlevel, provincecode, citycode, areacode, streetco 阅读全文
posted @ 2021-02-01 16:32 violety 阅读(296) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示