How to create SQL Server temp tables without collation problems

Using temp tables in Microsoft SQL Server is tricky when your databases don't follow the server collation. This post explains how to create temp tables while avoiding the use of explicit COLLATE statements in your TSQL code.