Tuesday, June 28, 2011

Which one are better ? scalar , Table , multiline , inline UDFs

Inline UDFs offer a SET based operation where as multi-line  and scalar udfs offer row-based operation.

Bottom Line : Avoid CURSORs , WHILE LOOPs , multi-line  and scalar udfs

http://www.sqlservercentral.com/articles/T-SQL/73887/
http://jahaines.blogspot.com/2009/10/converting-scalar-user-defined-function.html

1 indicate least recommended and 3 indicates most recommended UDFs


1. Scalar UDF
1. Multilne UDF
2. Table UDF
3. Inline Table UDF
3. Inline UDF

No comments:

Post a Comment