Dealing with date and time instead of datetime Rob Farley describes a tactic where adding multiple predicates around separate date and time columns can win you some better performance. Rob Farley ◆ March 29, 2018 5
Row Goals, Part 4: The Anti Join Anti Pattern Paul White continues his series on row goals, treating a redundant and problematic TOP (1) that is added to the inner side of an apply anti join. Paul White ◆ March 19, 2018 0
When DISTINCT <> GROUP BY Usually DISTINCT and GROUP BY will yield the same results, but here Rob Farley explains cases that can break the rule. Rob Farley ◆ March 13, 2018 0
Row Goals, Part 3: Anti Joins Continuing his in-depth series on row goals, Paul White explains both why and how they can impact queries involving anti joins. Paul White ◆ March 7, 2018 0
SQL Server and the Spectre/Meltdown Vulnerabilities Glenn Berry explains how the Spectre/Meltdown issues (and their patches!) may affect SQL Server performance, and provides a handy list of mitigation steps to keep your servers protected. Glenn Berry ◆ March 1, 2018 1