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.
SQL SERVER – T-SQL Script to Identify TOP 10 Parallel Running Queries
Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check.
Read What My Clients Say About Comprehensive Database Performance Health Check
I am very fortunate that my clients find my consulting services very helpful and carefully crafted for their need. I indeed get a kick out of my profession.
September 2019 Training Updates – Czech Republic, Netherlands, Sweden, Denmark
September 2019 is a very special month as there are three classes scheduled for my most popular training on 21 Essential Scripts: Performance Tuning.
Do Stream Aggregate Operator Always Need Sort Operator? – Interview Question of the Week #240
Question: Do Stream Aggregate Operator Always Need Sort Operator?
Answer: Absolutely No.Before I explain this question a bit more in detail.
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