Account Options

  1. Sign in
 
  Advanced Search
Preferences
Search:  all groups  Google Groups
 GroupsResults 1 - 2 of about 2 for parameter sniffing author:Bart author:Duncan
Sorted by relevance    Sort by date
 

Performance hit - parameters versus variables
microsoft.public.sqlserver.programming  -  5 posts  -  4 authors  - Last post:  Nov 20, 2001
Parameter sniffing allows SQL to insert the known value of parameter @p1 into
the query at compile time before a plan for the query is generated. Because SQL
...
http://groups.google.com/g/fe17feec/t/.../d/ff9e6e72122e1fb?hl=en&ie...

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 ...
http://groups.google.com/g/fe17feec/t/.../d/a3a46be009aa4298?hl=en&ie...


Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google