Finding Distinct Values Quickly Paul White explains a few different ways to retrieve distinct values from a table, including some big "it just runs faster" wins in SQL Server 2019. Paul White ◆ March 17, 2020 1
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
Performance Surprises and Assumptions : GROUP BY vs. DISTINCT Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other. Aaron Bertrand ◆ January 26, 2017 15