Do UDFs slow performance?
Posted on 2011-03-02
Do user defined functions slow performance? I don't have a lot of experience with SQL Server (Fox & Access background). Because the text functions are so limited, I wanted to create some user defined functions for a process in which I'm comparing a lot of concatenated text. (FYI - I'm creating PADR() & CHRTRAN().) Some of the tables are pretty big, so speed is an issue. But I was told that using UDFs would slow performance. Is this correct?