March 2, 2010 at 12:10 pm
Nice question but one niggle about the explanation: if the procedure option RECOMPILE is specified the same plan will NOT be used in subsequent executions. This can be useful if an SP's plan would be heavily influenced by one of its parameters or if some of the tables it accesses changed very rapidly (so that statistics are very different) compared to the frequency with which the proc is called.
Tom
March 3, 2010 at 8:54 am
Thanks for an easy one, I usually need to think alot more. Actually, I was surprised to see how many missed that one. I will be careful to cover that topic a little more carefully in class...
Now to go find another question that I can get wrong... 🙂
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 30, 2010 at 8:27 am
Managed to get this wrong! Oh dear...
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply