Jeff Moden (6/20/2009)
Nice article and great explanation in the article... too bad they didn't actually test it for performance... 😉 Both of the following UDF's render identical execution plans and they both take turns winning on my desktop. That also means that compared to the inline code, they both make some nasty sucking sounds. 😛 I got the function code below from the article.[/font]
Hey Jeff,
Short answer: Try it with an UPDATE statement as the article does 😉 :w00t:
Long answer in progress 🙂
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi