Oh, yeah, UDFs are something that I want a dev to know about but I also want them to understand why most of the time they shouldn't use them ;-) Triggers, too.

Oh, yeah, UDFs are something that I want a dev to know about but I also want them to understand why most of the time they shouldn't use them ;-) Triggers, too. I would say there are some positive cases for using scalar UDFs in live-run queries, but certainly not where the UDF's result is in any way dependent on the value of a field in the dataset. There lies the path to horrendous performance problems....