SQL Shack

SEPTEMBER 28, 2020

In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Scalar UDF inlining is a member of the intelligent query processing family and helps to improve the performance of the scalar-valued user-defined functions without any code changing.

Servers 107

Servers Programming Code Software 107

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. As you may recall, back in SQL Server 2016 SP1, they opened up all of the programming surface features to all editions, and many (but certainly not all) of the performance and availability features.

Servers 40

Servers Hardware Database Availability 40

SQL Performance

FEBRUARY 10, 2021

First, as a quick reminder, let’s review the fastest solution from last month’s article, implemented as an inline TVF called dbo.GetNumsAlanCharlieItzikBatch. The fact that you enable Discard results after execution in SSMS doesn’t prevent SQL Server from sending the result rows to SSMS; it just prevents SSMS from printing them.

C++ 124

C++ Servers Testing Code 124