Erin Stellato gives an overview of Automatic Plan Correction in SQL Server 2017 and Azure SQL Database, and assures us that Microsoft is not trying to code us out of jobs.
In an effort to make leading wildcard searches sargable, Aaron Bertrand (@AaronBertrand) plays around with a trigram-type implementation in SQL Server.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
After a recent conversation on Twitter, Aaron Bertrand (@AaronBertrand) shows where excessive comments in your stored procedures might have an impact on performance.
