When faced with real-world, less-than-perfect data...
Basic SQL references I keep coming to again and again.