IS there any way to avoid "parameter sniffing" a part from declaring local variables

• John Paul-702936

  SSCrazy

  Points: 2182

  More actions

  August 20, 2009 at 10:53 am

  #203987

  IS there any way to avoid "parameter sniffing" a part from declaring local variables

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 20, 2009 at 11:06 am

  #1042290

  Depends what kind of parameter sniffing problems you have.

  http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass