An example of a non-deterministic function ... inline TVFs are inlined and optimized as normal. Starting with SQL Server 2019, scalar functions written in T-SQL may be inlined.