C# Corner

Related resources for parameter sniffing
  • Overview Of Parameter Sniffing9/27/2018 11:29:21 AM. Hello Learners. Hope you all are doing great. I am writing this article to get the understanding about the parameter sniffing. What it is all about and how it is related to performance sometimes.
  • Parameter Sniffing in SQL Server11/18/2013 12:10:17 PM. This article is an attempt to explain what Parameter Sniffing is all about and how it affects the performance of a Stored Procedure.
  • Controlling Parameter Sniffing in SQL Server11/11/2013 5:49:22 AM. Parameter sniffing is helpful when there are several parameters in a Stored Procedure and also there is no favorite combination of parameters. If the value of parameters is not known at the time of compilation, there is nothing to be sniffed.
  • 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.
  • Parameter Sniffing and Performance in SQL Server 20054/12/2012 4:24:40 PM. This article describes parameter sniffing and performance in SQL Server 2005.