On this topic I'd like to plug a book that really drove this home for me: "SQL Antipatterns" by Bill Karwin.