SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Collation Rss

Search for any content tagged collation

   Items 1 to 10 of 10   
 

Questions About SQL Server Collations You Were Too Shy to Ask

Of course we all like our colleagues to think that we know everything there is to know about SQL Server Collations. However, the truth is that it is a rather complicated topic to fully understand and the cost of getting collation wrong can be great. If only one could ask certain questions on forums or at conferences without blushing. Help is at hand, because Robert Sheldon once again makes the complicated seem simple by answering those questions that you were too shy to ask.  Read more...
By Additional Articles 2017/06/15 | Source: SimpleTalk | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 3,668 reads

Changing SQL Server Collation After Installation

In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps.  Read more...
By Additional Articles 2017/04/11 | Source: MSSQLTips.com | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 2,913 reads

Change the Collation Setting for Clustered SQL Server 2014 Instance

In this post I will show a procedure to change collation settings of SQL Server 2014 cluster instance.   Read more...
By Ganapathi varma Chekuri 2016/11/24 | Source: SQLServerCentral.com | Category: clustering
Rating: |  Discuss |   Briefcase | 448 reads

How to generate T-SQL scripts in SQL Server Management Studio with the collation settings

SQL Server collation is an important setting when creating database objects. One of the best ways to ensure that collation issues do not happen is to ensure that the collation settings are properly specified in the script that generates the database objects - Siddharth Mehta demonstrates how to do this.  Read more...
By Additional Articles 2016/10/07 | Source: MSSQLTips.com | Category: collation
Rating: (not yet rated)  Rate this |   Briefcase | 3,865 reads

Finding Special Characters within Character Strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2016/04/08 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 14,001 reads

Deep Dive into Changing Database Collation

Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.  Read more...
By Lowell Izaguirre 2016/03/07 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 2,163 reads

Finding Special Characters within Character Strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2016/04/08 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 14,001 reads

How column COLLATION can affect SQL Server query performance

Most DBAs, myself included, install SQL Server with the default server collation SQL_Latin1_General_CP1_CI_AS and all of our table columns get created using this default setting. This tip will look at the performance impacts of querying data with this setting as it compares to querying columns with the collation set to SQL_Latin1_General_CP1_CS_AS.  Read more...
By Additional Articles 2014/05/06 | Source: MSSQLTips.com | Category: collation
Rating:  Rate this |   Briefcase | 4,518 reads

Change Server Collation in SQL Server 2008

How can I change the collation of SQL Server 2008? Learn how in this short tutorial.  Read more...
By Kevin Sermijn 2011/03/15 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 5,996 reads

Changing Server Collation on SQL Server 2008

In this article, learn about the risks of changing server collation as well as how to go about making this change.  Read more...
By Blesson John 2010/09/20 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 9,542 reads
   Items 1 to 10 of 10