Scalar UDF Inlining in SQL Server 2019 Aaron Bertrand introduces Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads. Aaron Bertrand ◆ January 22, 2019 6
Cloning Databases with PSDatabaseClone Guest author Sander Stad walks through PSDatabaseClone, a Powershell alternative to provisioning copies of databases through restore or scripting. Guest Posts ◆ January 18, 2019 1
Using Intel Optane Storage for SQL Server Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads. Glenn Berry ◆ January 14, 2019 0
Closest Match, Part 2 Itzik Ben-Gan continues his series on solving a reader challenge involving joining between two tables based on closest match, looking at memory-optimized tables and SQL CLR. Itzik Ben-Gan ◆ January 9, 2019 4
Using Track Causality to Understand Query Execution Erin Stellato shows us how to use the Track Causality session option for more reliable performance troubleshooting with Extended Events. Erin Stellato ◆ January 4, 2019 1
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
