The default collation of our new server is
SQL_Latin1_General_CP1_CI_AS. However the collation of the other databases which are used as the source to migrate data into the target databases on this server are
To avoid getting the error while we load data from database 1 (collation:
Latin1_General_CI_AS) to database 2 (collation:
SQL_Latin1_General_CP1_CI_AS), I changed the collation of database 2 (the target database) to
However I'm wondering if it might any side-affect?
What is the reason that the server default collation is
SQL_Latin1_General_CP1_CI_AS? Is it any better than other collation, in terms of performance, etc?
Thanks for your help.