Click here to monitor SSC
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 8 of 8   
 

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 | 422 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,710 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 | 13,820 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,012 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 | 13,820 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,348 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,992 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,523 reads
   Items 1 to 8 of 8