But do you really know all the effects that choice has on your database and the applications that run against it? What is the default? By default, SQL Server chooses the collation that corresponds to the Windows system locale on … ColA COLLATE Latin1_General_CS_AS = cs.ColA. This will tell SQL Server which collation to use for the join. That's about it. The important thing to remember with collations is that a little thought up front can save you a lot …








