SqlServer Database Collation and TempDB

Insightful article (as always) from Kimberly Tripp on changing SqlServer database collation and possible side-effects when joining TempDB tables.