tag:blogger.com,1999:blog-5956798.post4645681341390471677..comments2016-10-01T15:34:22.469-05:00Comments on You want fries with that?: Kevin3NFhttp://www.blogger.com/profile/02693334985554374865noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-5956798.post-64625785844432768332010-01-23T03:45:21.557-06:002010-01-23T03:45:21.557-06:00hey kevin
I once had an interview which I didn...hey kevin<br /><br />I once had an interview which I didn't get. The scenario was this. A system was working fine on the trading floor when suddenly it was timing out - I soon found out the limitations of my knowledge but essentialy the correct answer (as I asked at the end) was to drill through the DMV's to find the offending Proc (suffering from data skew) and then pass the proc the parameters (via a table variable) to force a statement level recompilation. Was this what you were referring to when you mentioned 'Being able to force a recompile of a portion of the overall query is really slick' at PASS as presented by Kalen?<br /><br />if so would you like to elaborate on exactly how that works, thanksmatskihttps://www.blogger.com/profile/16608225091837885446noreply@blogger.com