How Scalar UDF Inlining in SQL Server 2019 broke SCOM default property values.

What is Scalar UDF Inlining? You can read about Scalar UDF Inlining in great details here: https://docs.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver15, but in general, it’s exactly what how it sounds. UDF is an abbreviation for User Defined Function, and scalar means it returns a single value of simple type. Like int, varchar, float, etc. To improve query performance, SQL… Read More