You might have heard that SQL Server user-defined functions are the devil. That’s because someone got burned. They put a scalar function in a WHERE clause on a big table and fed it a column name. And bad things happened. Continue reading
T-SQL Inline User-Defined Functions are Sargable
Leave a reply