In this particular case, we had memory issue and after careful investigation, we found the troublemaker as a Lock Pages in Memory settings.
How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? – Interview Question of the Week #242
Question: How to List All DML Triggers Created or Modified in the Last N Days in SQL Server? Let us see the answer of this question in this blog.
September 2019 Trainings – 21 Essential Scripts: Performance Tuning
I will be delivering four classes on my most popular training on 21 Essential Scripts: Performance Tuning in Europe in the month of September 2019.Â
Understanding State of SQL Server Monitoring 2019 Report
Earlier Red Gate launched the industry’s first-ever report into the state of SQL Server monitoring. Recently they released Report for the year.
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.Â
SQL SERVER – Find All Tables Containing Specific Column Name
During the recent Comprehensive Database Performance Health Check, I was asked if I know any trick to identify column with a Specific Name in the database.
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.