How to check for an update in SSMS depends on the installed generation. My fintech-customer walkthrough showed SSMS 18 settings.
RESOURCE_SEMAPHORE_QUERY_COMPILE Wait: Check Lock Pages in Memory
RESOURCE_SEMAPHORE_QUERY_COMPILE was the first wait type in a client’s wait statistics. Readers asked how I knew to look at Lock Pages in Memory. Here is the script I used, and the setting that resolved the problem.
How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242
List all DML triggers created or modified in the last N days in SQL Server, and why modify_date moves when nobody edited the code.
SQL SERVER Management Studio – Completion Time in Messages
When the queries end, we know how long the query ran from the duration of the query but we never know their completion time.
Tables Containing a Column: Search by Name in SQL Server
To find tables containing a column, search sys.columns by name instead of opening tables one by one. This post searches one database, then every database on the server, and shows why an underscore in the pattern needs brackets. It also compares the data types of related columns.
How to Use Multiple Hints Together for a Query? – Interview Question of the Week #241
Question: How to Use Multiple Hints Together for a Query?
Answer: Of course, you can use multiple hints for a query. Here is an example of the same.
Query Runs Slow Occasionally: Five Checks to Find Why
When a query runs slow occasionally, the cause sits around the query: a lock, a job, a file growth, tempdb or a shortage of worker threads. This post gives one tested T-SQL check for each and a small demo for blocking and file growth. It also says what to do when all five checks find nothing.






