This question often keeps on coming in my consulting engagements. Let us quickly see the answer about Query Without Join Showing Query Plan With Join.
Question: How to Know If Index is Forced on Query?
Answer: Let me tell you a brief story so you understand the context of the question.
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.
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
I received quite a few interesting emails. One of the emails was about the Limitation of ENABLE_PARALLEL_PLAN_PREFERENCE Hint.
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.
Question: Does NOLOCK Really Applies No Lock?
Answer: The answer is NOLOCK do apply the lock and it is Sch-S lock. Sch-S stands for Schema Stability. Quite a few people say it is actually Schema Shared lock and it is not correct.