Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Collation Rss

   Items 1 to 16 of 16   
 

Collation, Unicode & Joins

By Sean Pearce 2014/07/23 | Category: tsql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,365 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 | 3,565 reads

Database Collation Is Null

By Andy Warren 2014/01/17 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,748 reads

Between & Collation

By G. C. 2013/08/29 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,284 reads

LIKE a vowel

By Tom Thomson 2012/12/03 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,564 reads

character ordering

By Tom Thomson 2012/11/01 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,839 reads

FILTER

By Lokesh Vij 2012/09/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,679 reads

CS Collation

By Rich Weissler 2012/09/12 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 2,292 reads

Variant Order 3

By Tom Thomson 2011/12/12 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,850 reads

Variant Order 2

By Tom Thomson 2011/12/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,012 reads

Collation and SQL_VARIANT

By Paul White 2011/11/01 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 1,895 reads

Niagara Falls

By Ron Moses 2011/08/01 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 2,491 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,904 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,053 reads

Change the collation of Columns

This script changes the collation of columns to default database collation in all the tables  Read more...
By Srini Kolar 2010/09/02 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 1,796 reads

Simple LIKE with wildcard

By Honza Mensdorff 2010/05/25 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 3,399 reads
   Items 1 to 16 of 16   
 
Tags
t-sql (7)    
sql_variant (2)    
administration (1)    
attach (1)    
database (1)    
databasepropertyex (1)    
detach (1)    
join (1)    
sql server 2008 (1)    
tsql (1)    
unicode (1)