February 16, 2015 at 11:30 pm
Comments posted to this topic are about the item Recompile in a stored procedure?
February 17, 2015 at 12:20 am
Thank you for the post, really good one. (had to check on the usecounts field to make sure if my analysis is correct)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 17, 2015 at 12:48 am
Interesting. I like questions that make me think up a bit more.
Igor Micev,My blog: www.igormicev.com
February 17, 2015 at 1:45 am
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..
February 17, 2015 at 2:20 am
This was removed by the editor as SPAM
February 17, 2015 at 2:37 am
Nice question
February 17, 2015 at 5:29 am
Thanks for the good question. Need more coffee.
February 17, 2015 at 7:36 am
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.
February 17, 2015 at 7:55 am
Good Question! Nice to learn something this morning.
February 17, 2015 at 11:47 pm
Nicely put. thanks for sharing the question. this will certainly bust few myths
February 18, 2015 at 3:43 am
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
February 18, 2015 at 5:25 am
Good to know that, thanx.
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
February 18, 2015 at 3:53 pm
Nice question, thanks.
February 19, 2015 at 5:16 am
nice question...
Manik
You cannot get to the top by sitting on your bottom.
June 8, 2015 at 2:47 am
Thanks, good question. It helps me.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy