Improving Availability and enhancing Programmability - Microsoft SQL Server 2008 R2 Administration - page 242

Now, let us work on new collation settings. SQL Server 2008 is fully aligned with Windows
Server 2008 on codepage, where every collation in SQL Server maps to a specific language
locale and ANSI code page for case-sensitive and accent-sensitive data sorts. There are 80
new collations, denoted by *_100 version references to provide up-to-date and accurate
sorting conventions. There may also be some situations where a different collation is required
at the Database Engine Configuration screen:
F Select the BINARY2 collation option if the binary code point based sorting
is required
F Select Windows Collation designator and sort order for a consistent comparison
across the data types
F In addition to instance level and database level collation settings, we can also
configure the individual column level using the COLLATE command within the
column definition
F The specific collations for Windows or SQL use the CREATE TABLE or
ALTER TABLE statements