C# Corner

Related resources for parameter sniffing
  • Parameter Sniffing In SQL Server8/23/2017 12:00:17 PM. SQL Server uses a process called parameter sniffing when it executes a stored procedure that has parameters. When the procedure is compile or recompiled, the value passed in the parameter is evaluated
  • 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.