News Score: Score the News, Sort the News, Rewrite the Headlines

SQL Anti-Patterns You Should Avoid

Today, I will be talking about some of the common and high impact SQL anti-patterns I have seen from experience that can make queries and pipelines difficult to maintain, or have slower than expected performance. These issues can compound, causing erosion in trust in data, and slower query development in general.When working with larger enterprise software, it is common to have large CASE WHEN statements translating application status codes into plain English. For example, status code 1 could me...

Read more at datamethods.substack.com

© News Score  score the news, sort the news, rewrite the headlines