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

   sunilmadan, May 3, 2006

   #2
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.

   satya, May 3, 2006

   #2
3. FrankKalis Moderator

   You know this one?
   http://support.microsoft.com/default.aspx?scid=kb;EN-US;243586
   
   --
   Frank Kalis
   Microsoft SQL Server MVP
   http://www.insidesql.de
   Heute schon gebloggt?http://www.insidesql.de/blogs
   Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)

   FrankKalis, May 3, 2006

   #2
4. sunilmadan New Member

   Thanks FrankKalis, the link was useful.

   sunilmadan, May 4, 2006

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in