Q

Changing the language option, part 2

Continued from part 1...

Question 4 -– What are your recommendations?

Although the ability to configure the collation at numerous levels is available, it can quickly cause some confusion. My recommendation is to keep all of these settings consistent at the SQL Server level and consider each setting prior to installing the SQL Servers in your environment. If you are in an organization with a limited amount of resources for SQL Servers and have the need to manage various data sets, at a minimum ensure these settings are consistent at the database level. Seriously consider the need to change the collation settings at the column level and explore all options for the ideal solution.

Needless to say, the collation settings as all other SQL Server settings should be documented and communicated clearly, because with these settings query results among various SQL Servers or databases may yield unexpected results. These unexpected results can cause a great deal of consternation that can be easily prevented with simple communication. For Yukon, the next release of SQL Server, Microsoft is rumored to be applying the same level of flexibility to new configuration parameters to ease the SQL Server management. Check out some of the new Yukon functionality at An Overview of SQL Server Yukon for the DBA.

For More Information

This was first published in February 2004

Dig deeper on Microsoft SQL Server Installation

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close