Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let’s look into the performance gains this offers.
The post Scalar UDF Inlining in SQL Server 2019 – Simpler functions appeared first on Wayne Sheffield.Read More
The case study below was submitted by Bryan Evans, IT Director at Orbit Irrigation Products Inc. Description of Orbit’s SQL Server usage environment: With facilities worldwide, Orbit is the world leader in manufacturing and supplying irrigation, misting, and home improvement products to homeowners in forty countries across five continents. Our SQL environment is critical for…Read More