SQLPerformance.com - Page 2 of 34 - SQL Server performance articles curated by SentryOne

Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.

Jonathan Kehayias ◆ December 27, 2018

1

Security Features in SQL Server 2017

Glenn Berry talks about a few of the security features in SQL Server 2017 and reminds us to always test and validate the performance impact.

Glenn Berry ◆ December 17, 2018

1

Closest Match, Part 1

Itzik Ben-Gan starts a new multi-part series on solving a reader challenge involving joining between two tables based on closest match.

Itzik Ben-Gan ◆ December 12, 2018

26

SQL Server Join Estimation using Histogram Coarse Alignment

Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.

Paul White ◆ November 20, 2018

1

Understanding log buffer flushes

Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.

Itzik Ben-Gan ◆ November 14, 2018

15

Three Easy SQL Server Performance Wins

Glenn Berry goes over three different tactics you can use to squeeze some extra performance out of SQL Server without a lot of heavy lifting.

Glenn Berry ◆ October 29, 2018

1

End of support for SQL Server 2008 & 2008 R2

Tim Radney talks about some of the things you can do to prepare for the end of extended support for SQL Server 2008 and SQL Server 2008 R2.

Tim Radney ◆ October 12, 2018

1

Reader solutions to Special Islands challenge

Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.

Itzik Ben-Gan ◆ October 10, 2018

0

What to do (or not do) about top wait stats

Aaron Bertrand talks about the top 10 wait types we see among our SentryOne customer base, and where to turn when you're experiencing one of them on your own system.

Aaron Bertrand ◆ October 5, 2018

2

First public preview of SQL Server 2019 : CTP 2.0

Today Microsoft announced the first public preview of SQL Server 2019. I've got some exclusive details over at MSSQLTips.com.

Aaron Bertrand ◆ September 24, 2018

4

Special Islands

Itzik Ben-Gan explains the mechanics behind some different approaches to solving gaps and islands problems in T-SQL.

Itzik Ben-Gan ◆ September 12, 2018

25