Paul White (8/10/2009)
TheSQLGuru (8/10/2009)
Well, I think (hope) I prefaced my initial stomp on UDFs with that "ancillary data access" statement as the real bugaboo. Perhaps I missed it.Paul, you bring up other points in that you can still get issues if a) you leave out schema binding and b) your query would perform better with parallelism. Just more ways a UDF can harm performnace.
You did mention it I think, or I assumed it. Just to explain: I often reply quoting text that prompted a line of thinking - I wasn't criticising your post. Apologies if it came off that way.
No worries - I was concerned that I had missed that important qualifier and came off as stating that UDFs never had any worthwhile purpose at all, which is not what I intended. They do have use, but one sure better mind his/her P's and Q's when they set off down that path! 🙂
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service