Tag Archives : collation

How do you check collation and compatibility level for a database?

This entry was posted in Sql Server DBA Sql Server tutorials and tagged collation compatibility database server sql on by .

Scenario There is a common practice in the DBA world to work on a daily basis with back-ups and restoring of databases on different servers with different configurations. In an ideal world you would have the same collation and the same compatibility level on all your machines but for cases when this doesn’t happen here’s […]

Sql Interview question #8 : What is collation?

This entry was posted in Sql Server 2005 Sql Server 2008 Sql Server DBA Sql Server DEV Sql Server Development Sql Server Interview Questions Sql Server tutorials and tagged collation server sql on by .

Sql Server Interview question #8 What is collation? Solution Collation refers to a set of rules that determines how data is sorted and compared. Character data is sorted using rules that define the correct character sequence with options for specifying case sensitivity, accent marks, Kana character types, and character width.   Thanks for reading this […]