TSQL Tuesday #116 – SQL Server on Linux

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

You can now run SQL Server on Linux. With it being easy to install / update, and running exactly the same as in Windows, it is my choice for...

2019-07-13

9 reads

T-SQL Tuesday #115 – Notes to 20 year old Wayne

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

  There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....

2019-06-28 (first published: 2019-06-11)

208 reads

Working with SQLSaturday SpeedPASSes – revamped!

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....

2019-05-21

31 reads

Working with SQLSaturday SpeedPASSes – revamped!

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes....

2019-05-21

Creating a comma-separated list (SQL Spackle)

• by Wayne Sheffield

• SQLServerCentral.com

• comma separated list

Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.44 (70)

Log in or register to rate

2019-04-04 (first published: 2011-01-12)

36,976 reads

• Discuss

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the...

2019-03-26 (first published: 2019-03-11)

594 reads

Scalar UDF Inlining in SQL Server 2019

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

How does Scalar UDF Inlining affect the performance of scalar functions?
SQL Server 2019 introduces a new feature called “Scalar UDF...

2019-03-14 (first published: 2019-02-25)

2,885 reads

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

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...

2019-03-11

1 reads

Scalar UDF Inlining in SQL Server 2019

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.
The post Scalar UDF Inlining in SQL...

2019-02-25

1 reads

What is your why? – T-SQL Tuesday #111

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Would you believe that it is already the second Tuesday in February? Wow, this month is sure going fast. But...

2019-02-12

174 reads