sqlquantumleap.com
Which Collation is Used to Convert NVARCHAR to VARCHAR in a WHERE Condition? (Part B of 2: “Rabbit”)
Who will win “Who’s Collation is it Anyway?” Database Collation is ahead, but Column Collation isn’t about to give up.