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
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.
SQL SERVER – Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint
I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint.
SQL SERVER – Security Risk of Public Role – Very Little
During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role.Â
SQL SERVER – Using Query Hint ENABLE_PARALLEL_PLAN_PREFERENCE
There are so many options you should experiment before you opt for query hint. Recently DBA asked me how to use query hint ENABLE_PARALLEL_PLAN_PREFERENCE.Â
SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX
It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.
How to Use a CASE Statement in the WHERE Clause? – Interview Question of the Week #239
Question: How to Use a CASE statement in the WHERE Clause? Answer: First of all – CASE is not a statement but rather an expression.