Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mikael Eriksson Parameter sniffing RE: Parameter sniffing

  • October 17, 2013 at 12:05 am

    #1659129

    Here every time in SP GetIt this statement "set @Name = 'Pelle'" is executed.

    So every time record of Pelle will be displayed.

    Please comment on this.

    I have tested this on SQL 2008 R2.