Deep Dive into Changing Database Collation
Changing Database Collation Through Primary keys, Foreign Keys, Default and Check Constraints and more.
2016-03-07
3,059 reads
Collation
2014-11-11 (first published: 2014-07-25)
2,059 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.
2014-05-06
4,752 reads
2014-01-17
1,928 reads
2012-11-01
1,901 reads
2012-09-12
2,344 reads
2011-12-12
1,893 reads
2011-11-01
1,937 reads
2011-08-01
2,530 reads
Change Server Collation in SQL Server 2008
How can I change the collation of SQL Server 2008? Learn how in this short tutorial.
2011-03-15
6,854 reads
Blogs
Daily Coping 28 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Creating a Database Audit Specification can create new users & schemas in the background
I love database audits. They are simple, easy to use, effective, not overly resource...
Alert Filtering in SQL Monitor
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
Forums
How to make += in updates.
I am trying to update a field , which is defined as an INT....
Blue Question Mark on Remote SSMS
I am really starting to regret upgrading to SQL2019. I had to install SQL2017...
Left JOIN Help Revisited
Hello Community, I just received excellent support from a member on this forum called...
Ask SSC