What is collate latin1_general_ci_as in SQL Server?
The Latin1_General_CI_AS collation is a Windows collation and the rules around sorting unicode and non-unicode data are the same. A Windows collation as per this example can still use an index if comparing unicode and non-unicode data albeit with a slight performance hit. What does collate mean in SQL Server? Collations in SQL Server provide sorting rules, case, and accent …