02 2022 档案

SQLServer 查看耗时较多的SQL语句
摘要：SELECT TOP 50 total_worker_time / 1000 AS [总消耗CPU 时间(ms)], execution_count AS [运行次数], qs.total_worker_time / qs.execution_count / 1000 AS [平均消耗CPU 时间( 阅读全文
posted @ 2022-02-28 17:34 iHey 阅读(735) 评论(0) 推荐(0) 编辑
SQL Server搜索存储过程中的文本
摘要：select b.name,TEXT from [dbname].dbo.syscomments a, [dbname].dbo.sysobjects b where a.id=b.id and b.xtype='p' and a.text like '%[text]%' --[dbname]: 您 阅读全文
posted @ 2022-02-19 17:42 iHey 阅读(77) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示
🚀
回顶
➖
收起
  1. 1 404 not found REOL
404 not found - REOL
00:00 / 00:00
An audio error has occurred.