SQLServerCentral Article

Change the Instance Collation by Rebuilding Databases in SQL Server 2017

  • Article

As a part of my DBA activities, I do a lot of SQL Server installations every week. Most of the time, I install the instance with the default collation. A collation is a configuration setting in SQL Server that determines how the database engine should read the data. SQL Server has huge list of collations […]

5 (1)


10,449 reads

External Article

Questions About SQL Server Collations You Were Too Shy to Ask

  • Article

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.


3,969 reads


Daily Coping 5 Aug 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 4 Aug 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What’s next III


In case you didn’t know I was given notice about a month and a...

Read the latest Blogs


Truncate partition table failed due to index not partition. Help please.

By JasonO

I have 1 table which has a partition on Date column. However this table...

Finding Special Characters in Email Address

By sathishkm

Hi All, I have to find the special characters in email address apart from...

Three Mile Island And Your Databases

By Grant Fritchey

Comments posted to this topic are about the item Three Mile Island And Your...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers