Related resources for SQL Execution plan
  • 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.