随笔分类 -  MSSQL

SQL Performance
摘要：checkpoint [seconds] DBCC DROPCLEANBUFFERS #TABLES WITHOUT PRIMARY KEY USE incrLifeproNew; SELECT SCHEMA_NAME(schema_id) AS [Schema], name AS [Table] 阅读全文
posted @ 2021-12-22 15:02 sam_wang10 阅读(60) 评论(0) 推荐(0)
Top 50 CPU And Disk IO Consuming Queries in SQL Server
摘要：Top 50 CPU Consuming Queries in SQL Server Select st.[text] AS [Query Text], wt.last_execution_time AS [Last Execution Time], wt.execution_count AS [E 阅读全文
posted @ 2021-11-05 10:57 sam_wang10 阅读(61) 评论(0) 推荐(0)
MSSQL
摘要：Recover a lost SA password https://www.sqlshack.com/recover-lost-sa-password/ Use [dbname]gosp_change_users_login 'update_one', 'username', 'username' 阅读全文
posted @ 2021-07-21 09:11 sam_wang10 阅读(61) 评论(0) 推荐(0)