Related resources for Query parameterization
  • Parameter Sniffing in SQL Server11/5/2013 12:04:46 PM. This article explains how to avoid unnecessary compilations by reducing the number of ad hoc query in the cache plan using parameter sniffing in SQL Server.