Parameter Sniffing and Performance in SQL Server 2005
The text of this article is not in this database — only its details are. Read it on the old site: Parameter Sniffing and Performance in SQL Server 2005
4 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.
Gowtham RajamanickamPosted Apr 26, 2016, 3:06 AM
good article
Lajapathy ArunPosted May 9, 2012, 5:29 AM
Thanks Amit :)
Amit ChoudharyPosted May 9, 2012, 4:08 AM
By Enabling forced parameterization you can reduce the frequency of query optimizations, but you may also introduce suboptimal plans for some instances of those queries. I should update the article as well.. I missed this point to mention in article.
Lajapathy ArunPosted May 7, 2012, 11:39 PM
What is the use of "PARAMETERIZATION FORCED"?