Parameter Sniffing
SQL

What exactly is “parameter sniffing”? When a stored procedure is initially run, SQL Server examines the input parameters and builds the query plan with their help. This is referred to as “parameter sniffing.” This is OK as long as the input parameters for the initial invocation are typical for consecutive invocations. However, if this is…

Subscribe

Select Categories