dazzim72 (6/26/2013)
I use the function because I have a large amount of .sql files and I prefer to store specific logic in only one point. They help me to have a simpler maintenance.For the moment I never have had performances issue with my function.
Marco
Yes, performance problems can come on suddenly. A slight change in data can result in a totally different execution plan, and bang! You should consider converting your functions to table-valued functions.
John