SQL SERVER – Collation and Collation Sensitivity – Quiz – Puzzle – 6 of 31

January 7, 2012

Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was a constant request from the Community to take the learning of these books to the next level. Here is an article which discusses the Author’s Perspective.

Beyond Relational has come up with a very interesting concept – they have converted a few of the questions from my book into the SQL Quiz. The quiz is indeed focused on my two goals. In addition, it’s going to put the learning of the book to a higher stage. Looking at this novel concept, Vinod Kumar (Co-author) and I have decided to help every participant and reader by giving a few hints and suggestions to solve the quiz.

SQL Quiz

SQL SERVER - Collation and Collation Sensitivity - Quiz - Puzzle - 6 of 31 6 A DBA had to restore its database on new server runs a query to validate the data. The same query on the same database started to give different results. After a quick research he figured out that collation was different of both the database. What is Collation and Collation Sensitivity inside SQL Server?

Link to participate in SQL Quiz

Notes of Vinod Kumar

The concepts of Collations have not changed for ages now. When it comes to localization and globalization, these concepts really help a lot. Here’s a hint to documentation. Just a small twist, how can you go and explicitly change the collation for a given query?

Notes of Pinal Dave

Language is the most important part of communication. We all communicate with each other through language which both persons understand. If we do not talk in the language which the other person cannot understand, the end result is not fruitful. In a similar way, collation is very important to any database. I have often seen situations when the collation changes from case sensitive and case in-sensitive turning the query result hey-wire and creates chaos on the server.

Additional Notes

SQL Server Interview Questions and Answers ISBN: 1466405643 Page#46-47
Find Collation of Database and Table Column Using T-SQL
SQL SERVER – Cannot resolve collation conflict for equal to operation
Find Database Collation Using T-SQL and SSMS
Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extension Script
Default Collation of SQL Server 2008

Prize

There are exciting prizes awaiting the winners. Click here for Prizes and Frequently Asked Questions.

Link to participate in SQL Quiz

Note: The SQL Quiz, winners and prizes are administrated by Beyond Relational. The goal of this blog post is to provide additional learning pointers only.

Reference: Pinal Dave (https://blog.sqlauthority.com)