Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Collation Rss

   Items 1 to 20 of 23    Older >>
 

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,291 reads

Which properties exist?

By Steve Jones 2016/04/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,182 reads

Finding the database collation

By Steve Jones 2016/03/14 | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 1,223 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 | 1,838 reads

Polybase SQL Server 2016

By Kapil Singh 2015/07/22 | Category: polybase
Rating: (not yet rated) |  Discuss |   Briefcase | 1,196 reads

Change Database Collation

A stored procedure to automate database collation change  Read more...
By Arlo Fuller 2014/11/11 | Source: SQLServerCentral.com | Category: collation
Rating: |  Discuss |   Briefcase | 1,200 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,291 reads

Collation, Unicode & Joins

By Sean Pearce 2014/07/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,897 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,185 reads

Database Collation Is Null

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

Between & Collation

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

LIKE a vowel

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

character ordering

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

FILTER

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

CS Collation

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

Variant Order 3

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

Variant Order 2

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

Collation and SQL_VARIANT

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

Niagara Falls

By Ron Moses 2011/08/01 | Category: collation
Rating: (not yet rated) |  Discuss |   Briefcase | 2,519 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,988 reads
   Items 1 to 20 of 23    Older >>
 
Tags
t-sql (10)    
administration (2)    
sql_variant (2)    
attach (1)    
collationproperty() (1)    
database (1)    
databasepropertyex (1)    
detach database (1)    
join (1)    
polybase (1)    
regular expressions (1)    
special characters (1)    
sql server 2008 (1)    
sql server 2016 (1)    
string manipulation (1)    
unicode (1)