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.
SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally
This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
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 – Generate In-Memory OLTP Migration Checklists – SSMS
One of the customers of Comprehensive Database Performance Health Check asked me if I can help them analysis their database for In-Memory OLTP Migration.