Server-Level Collation

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 (2)

You rated this post out of 5. Change rating

2022-12-26 (first published: )

18,171 reads

Blogs

Take the SQL Saturday Topic Survey

By

What topics do you want to see presented at a future SQL Saturday (or...

Resetting Git and Abandoning Changes–#SQLNewBlogger

By

I recently had an issue in one of my Git repos, and decided to...

Exploring Window Functions Execution Plans

By

There are quite a few different ways that you’re likely to see window functions...

Read the latest Blogs

Forums

Program Code giving duplicate errors where no duplicates exist

By Andre 425568

On our Java Hibernate program it is giving a duplicate value on an insert...

How to get calculated values from a derived(?) table?

By mjdemaris

Here is my filtered dataset: I would like to calculate the time difference between...

sp_server_diagnostics in ErrorLog

By Casper101

I have the following in the SQL Errorlog, that was never there before: sp_server_diagnostics...

Visit the forum

Question of the Day

Disable Memory Grant Feedback Persistence

In SQL Server 2022, how can I disable memory grant feedback persistence?

See possible answers