An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.
Question: What is Stored in TempDB?
Answer: In my recent conversation my client asked me if I know what is currently stored in their TempDb.
Recently during the Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.
Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:
EXEC sp_recompile ‘NameofSP’
Let us read more about it.
I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.
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.
My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.