About Collations in SQL Server

This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an existing instance and the trade-offs.

Changing the Collation of the Instance, the Databases, and All Columns in All User Databases: What Could Possibly Go Wrong?

Changing the collation of a SQL Server 2012 database

Server Collation SQL_Latin1_General_CP1_CI_AS versus Latin1_General_CI_AS

Views – 1159