SQL Server Performance

Using hint with Stored Procedure

Discussion in 'Performance Tuning for DBAs' started by sunilmadan, May 3, 2006.

  1. sunilmadan New Member

    How can we use a hint with a stored proc., e.g., KEEP PLAN hint which is especially useful when you want to avoid frequent recompilation of a stored proc containing temp tables.

    Thanks
    Sunil
  2. satya Moderator

    What kind of hints you want to use in SP?

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. FrankKalis Moderator

  4. sunilmadan New Member

    Thanks FrankKalis, the link was useful.

Share This Page