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
Tag: Performance
Thanks to everyone who turned up on Friday for the SQL performance tuning class. I hope that everyone got something out of it and I don;t get blamed for any mad experimenting on production servers now Do watch the Prodata events page. We may have a new set of MasterClasses starting in Oct and even … Continue reading Galway SQL Master Class–Performance Tuning