At which point the CROSS APPLY operator can be used to simulate a normal scalar function call. And as the name implies, inline TVFs are inlined and optimized as normal. Starting with SQL Server ...