I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.
SQL SERVER – Query Without Join Showing Query Plan With Join
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.
How to Know If Index is Forced on Query? – Interview Question of the Week #246
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.
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 – 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 – 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 – 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.