I’ve quietly resolved performance issues by re-writing slow queries to avoid DISTINCT. Often, the DISTINCT is there only to serve as a “join-fixer,” and I can explain what that means using an example.
The post Don’t use DISTINCT as a “join-fixer” appeared first on SQLServerCentral.
