Be Better than SQL Server UDF Inlining

Grzegorz Łyp

The great new tool in SQL Server 2019, named Scalar UDF Inling, changes Scalar UDFs into inline functions that can be processed more efficiently. But not all functions can be inlined including Multi Statement Table Valued Functions. During this session I will present techniques of changing Scalar UDFs and MSTVFs into inline functions in common and less common situations.