Ever have to join on the "closest" value, not an exact match?  This can be tricky and when you need to do it for many a large amount of data things can run very slow if it isn't done right.  Check out my post on Joining on Closest Date for Big Data - http://wad-design.s3-website-us-east-1.amazonaws.com/sql_limits_wp_2.html