Can any help me with understanding the difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CP1_CI_AS?
I've read some stuff, but I'm still unclear. If the same collation is used within a single database, does it matter which one of these I use? Is it only performance? If all our data character is english, does it matter which is used?
Is the default collation different for SQL server versions?