While user defined functions can offer great convenience, they can also sometimes hurt performance. This problem with them is that they use row-by-row processing, similar to how ... [Read Full Article]

http://www.sql-server-performance.com/tips/user_defined_functions_p1.aspx