By rlamarch
via simple-talk.com
Published: Aug 24 2009 / 05:06
Programming in SQL can be both a fun and a challenging task. Even seasoned SQL developers and DBAs can get trapped in one of the many pitfalls of the SQL language. My intention with this article was to highlight some of the more common mistakes that I've seen people make when coding SQL. The list reflects my direct experience working with different development teams and developers, performing code review sessions, and so on, as well as the issues I see every day on the newsgroups and forums. The list of common mistakes is far from exhaustive, and is presented in no particular order of severity.
Comments
Travis Dunn replied ago:
Great post. Along the same lines, if you're using ORM magic make sure to review your generated queries to verify they're not magically suboptimal. Active Record, I'm looking at you.
mrjohnson replied ago:
SQL *Server*.
jfernandez replied ago:
The problems and solutions are pretty generic. I don't use SQL Server and the article was fully useful to me.
mrjohnson replied ago:
I just find it really annoying when people call it SQL not SQL Server. It causes confusion... But I suppose that was the point.
chase.saunders replied ago:
Good one.
Voters For This Link (14)
Voters Against This Link (0)