WITH UDF in Select List
UDF in Where Clause
bySourabh AgarwalTechnical Lead, Microsoft SQL Server
Is there a performance difference bewteen calling a t-sql UDF & a sql-clr UDF for a simple non data access UDF?
Yes, there would a slight difference in the performance of t-sql UDF & a sql-clr UDF. The reason being the multiple switches which need to be made between SQL engine and the CLR runtime. With t-sql UDF everything is within the SQL Engine and no addtional switches are required.
Could you fix a link to the profiler image?
Question is answered here: