We do a lot of code reviews and the use of SELECT DISTINCT always comes up as its picked up by many of the static code analysis tools as a known scalability and performance risk. The common question is “Why should I avoid distinct” and “How can I avoid it” During a performance review we … Continue reading TSQL Best Practice – Avoid use of DISTINCT