In this particular case, we had memory issue and after careful investigation, we found the troublemaker as a Lock Pages in Memory settings.
SQL SERVER Management Studio 18 – Enable Dark Theme
We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio.
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.
SQL SERVER – Sample Long-Running Query for Demonstrations
Today we will talk about a sample long-running query which I use for my demonstrations. I travel across the world presenting on SQL Server.
SQL SERVER – Simple Example of READPAST Query Hint
The required was very unique and we were able to solve the problem with the help of READPAST query hint. Comprehensive Database Performance Health Check
SQL SERVER – Is Stream Aggregate is Same as Gather Streams of Parallelism?
Is Stream Aggregate is Same as Gather Streams of Parallelism? – This was one of the brilliant questions I had received during my recent engagement.