As everyone should learn from my 3 hours of Sql server frustration… Sql Server returns different values when you run a CheckSum on the same text for varchar and nvarchar data types.

The above probably isn’t interesting to any of my readers, but should I forget it later I can find it again.