As Seen Elsewhere - Ben Nadel's Easy Tips For Writing Better, More Optimized SQL

Ben Nadel has written up an excellent post and started a really interesting discussion on SQL best practices. Some techniques apply only to Coldfusion (which is just fine ), but most of them cover SQL in general. Follow the link to indulge.