Recompile in a stored procedure?

Question

Recompile in a stored procedure?

bkubicek

SSChampion

Points: 10938
More actions
February 16, 2015 at 11:30 pm

#297840

Comments posted to this topic are about the item Recompile in a stored procedure?
February 17, 2015 at 2:20 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 1

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.

Igor Micev SSC-Dedicated Points: 33109 More actions · Answer 2

Interesting. I like questions that make me think up a bit more.

Igor Micev,My blog: www.igormicev.com

vsagg85 SSC-Addicted Points: 434 More actions · Answer 3

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

Bhushan Kulkarni SSCrazy Points: 2829 More actions · Answer 4

Bhushan Kulkarni

SSCrazy

Points: 2829

February 17, 2015 at 2:37 am

#1777987

Nice question

Ed Wagner SSC Guru Points: 287024 More actions · Answer 5

Thanks for the good question. Need more coffee.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Tony++ SSCarpal Tunnel Points: 4421 More actions · Answer 6

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.