Scalar UDFs vs Inline TVFs: Measuring the Damage

Scalar user-defined functions are the most natural thing in the world to write. You have a bit of logic, you wrap it in a function, you call it in your SELECT list, and your query…