Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!
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.