04 2023 档案

SQL 跨服务器 -查询 修改
摘要：update [Business_TasksAffirm] SET driver_name=b.driver_name,PictureId=b.PictureId,iJsDoneState=1,iSIncluded=1,iSWages=1,UserId=b.UserId,UserName=b.Use 阅读全文
posted @ 2023-04-24 13:50 进步者One 阅读(34) 评论(0) 推荐(0) 编辑
SQLServer 查看耗时较多的 SQL 语句
摘要：SELECT TOP 20 total_worker_time/1000 AS [总消耗CPU 时间(ms)],execution_count [运行次数], qs.total_worker_time/qs.execution_count/1000 AS [平均消耗CPU 时间(ms)], last 阅读全文
posted @ 2023-04-14 17:19 进步者One 阅读(158) 评论(0) 推荐(0) 编辑

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