SQL Server Performance

With Recompile

Discussion in 'Performance Tuning for DBAs' started by hooperdba, Oct 20, 2006.

  1. hooperdba New Member

    Has anyone had great performance gains by using 'with recompile' on procedures
    that take 50+ parameters??
    Thanks
  2. satya Moderator

  3. mmarovic Active Member

    I would recommend to create several specialized procedures instead of one (over) general.
  4. Haywood New Member

    You're procedure is probably falling victim to "Parameter Sniffing". If you do a search in BOL or Google you'll get some good documentation that explains what it is and whty the recompile option can sometimes help.

Share This Page