Re: SQL Server and User Defined Functions

• runstein (runstein_at_biotronik.com):
  > Besides the obvious portability issues, could you guys give me your thoughts
  > on udf's? Am I being paranoid or are there some real reasons for my
  > hesitancy?
  

Performance can go down if you have a lot of data and long running user defined functions. Consider for example:

select myfunction(namecolumn) from mylargetable

The user defined function is applied for *every* row of the result. Udf's are a good tool, but they have to be applied with care...

-- 
Patrick Dehne
patr3ck_at_steidle.net