Watch Your Column Types

I've been bit by this twice in the past few months: comparing database columns that aren't the same type is really really expensive.  If you've only got a few rows, no big deal, but if you've got a few hundred thousand (or a few tens of millions) it makes a huge difference.  And varchar is NOT the same as nvarchar on SQL Server.