SQL SERVER 2019 – Disabling Scalar UDF Inlining


I have been blogging for over 13 years and have been working with SQL Server Performance Tuning for an over a decade and everyone always ask me where do I get new content to write from every single day. My answer is very simple, I actually get new things to learn from my clients when I am working on Comprehensive Database Performance Health Check. Today we will learn how I recently helped a client by Disabling Scalar UDF Inlining in SQL Server 2019.

Brief History

Recently I got an urgent call from a client who is a large eCommerce organization. They recently