Comments posted to this topic are about the item Recompile in a stored procedure?
Thank you for the post, really good one. (had to check on the usecounts field to make sure if my analysis is correct)
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Interesting. I like questions that make me think up a bit more.
Igor Micev,My blog: www.igormicev.com
Nice Post!!! Well,got my grey cells thinking,otherwise I would have gone for the first available option.. 😉
Thanks for the link about the details of recompile..
This was removed by the editor as SPAM
Thanks for the good question. Need more coffee.
Like the question, made me think.
Almost went for the "both procs" answer - asking myself "what was this person trying to point out here, usually something unexpected". To me getting both recompiled would be unexpected and worth knowing about.
In the end I decided to trust MS that they designed the logical way and didn't have a bug here -- and got it right.
Hall of Fame
Good Question! Nice to learn something this morning.
Nicely put. thanks for sharing the question. this will certainly bust few myths 🙂
Very interesting question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Good to know that, thanx.
Nice question, thanks.
You cannot get to the top by sitting on your bottom.
Hall of Fame
Thanks, good question. It helps me.
Viewing 15 posts - 1 through 14 (of 14 total)