Usually I just bookmark blog posts via Del.icio.us, but I really wanted to point out one of Ben Nadel's posts Easy Tips For Writing Better, More Optimized SQL. Hopefully he'll supply some examples in future posts, but the concepts he covers are a must for anyone writing SQL with or without ColdFusion.