T-SQL User-Defined Functions: the good, the bad, and the ugly (part 4)

Posted by Hugo Kornelis on SQL Blog See other posts from SQL Blog or by Hugo Kornelis
Published on Fri, 24 Aug 2012 21:07:00 GMT Indexed on 2012/08/27 21:50 UTC
Read the original article Hit count: 360

Filed under:
|
|
Scalar user-defined functions are bad for performance. I already showed that for T-SQL scalar user-defined functions without and with data access, and for most CLR scalar user-defined functions without data access , and in this blog post I will show that CLR scalar user-defined functions with data access fit into that picture. First attempt Sticking to my simplistic example of finding the triple of an integer value by reading it from a pre-populated lookup table and following the standard recommendations...(read more)

© SQL Blog or respective owner

Related posts about clr

Related posts about t-sql