T-SQL Tuesday #120 – What were you thinking? – Invitation

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

In this month's T-SQL Tuesday, I want to know about things that you have seen someone do in SQL Server that has left you wonder "What were you thinking?"
The...

2019-11-05

3 reads

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

11 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)

216 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

36 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)

37,501 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)

605 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,903 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

5 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

5 reads