Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 1043
Home > Interviews > Sql Server >

We can RECOMPILE a stored procedure in SQL server. Which of the following situations will NOT trigger recompilation of a stored procedure?

 Posted by Bandi on 11/26/2013 | Category: Sql Server Interview questions | Views: 6038 | Points: 40
Post | Interview FAQs | Exclusive Questions | Interview Home  
Select from following answers:
  1. SQL Server is restarted
  2. Using WITH RECOMPILE when calling SP
  3. Underlying table referenced by procedure has undergone physical design changes
  4. Adding a new index from which the procedure might benefit
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Bookmark It

Comments or Responses

Login to post response

More Interview Questions by Bandi


Latest Interview Questions