Google Groups

Performance hit - parameters versus variables

microsoft.public.sqlserver.programming - 5 posts - 4 authors - Last post: Nov 20, 2001

"Disable" parameter sniffing by using local DECLARE'd variables that you SET
equal to the parameters inside the stored proc, and use the local variables ...
http://groups.google.com/g/fe17feec/t/a6ae4020b1e3621/.../ff9e6e72122e1fb?...

Performance speed - Variables versus Parameters in Stored ...

microsoft.public.sqlserver.programming - 5 posts - 5 authors - Last post: Nov 20, 2001

The reason for the performance difference stems from a feature called "parameter
sniffing". Consider a stored proc defined as follows: CREATE PROC proc1 @p1 ...
http://groups.google.com/g/fe17feec/t/.../d/a3a46be009aa4298?hl=en&ie...8