Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the better option.
Aaron Bertrand introduces Scalar UDF Inlining, a long-awaited feature in SQL Server 2019 that will improve the performance of some workloads.
Guest author Sander Stad walks through PSDatabaseClone, a Powershell alternative to provisioning copies of databases through restore or scripting.
Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads.
Itzik Ben-Gan reviews the logic and performance of user submissions to a reader challenge involving joining between two tables based on closest match.
Erin Stellato shows us how to use the Track Causality session option for more reliable performance troubleshooting with Extended Events.
Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.
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.
Itzik Ben-Gan starts a new multi-part series on solving a reader challenge involving joining between two tables based on closest match.
Paul White dives into histograms and explains how the optimizer uses coarse alignment for cardinality estimates.
Itzik Ben-Gan explains log buffer flushes and shows how to use them to help balance performance, transaction size, and durability.
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.
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.
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 explains the mechanics behind some different approaches to solving gaps and islands problems in T-SQL.