SQL SERVER – Parameter Sniffing and OPTIMIZE FOR UNKNOWN

(Pinal Dave) I consider myself fortunate that I often receive a follow-up question from my earlier blog posts. Today we will discuss Parameter Sniffing and OPTIMIZE FOR UNKNOWN. In the earlier blog post, I had discussed how one can avoid the parameter sniffing by declaring the local parameter.

Register to Read