Enforce case-insensitive unique user names in a case-sensitive database using an indexed computed column with an explicit collation.
Case-Sensitive WHERE Clause: COLLATE Without Losing the Seek
A case-sensitive WHERE clause needs a COLLATE on the comparison, but the obvious version scans the index. A demo measures 286 reads against 2, and shows two fixes: keep the plain test beside it, or give the column a case-sensitive collation.
Change Database and Table Collation – SQL in Sixty Seconds #145
I discussed the method to change the database and table collation with my client during the Comprehensive Database Performance Health Check.
SQL SERVER – Change Database and Table Collation
To Change Database collation, I separate its default from existing character-column settings. The customer moved from case-insensitive to case-sensitive behavior.
How to Do Case Insensitive Search? – Interview Question of the Week #267
Question: How to Do Case Insensitive Search?
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.
Smiley in SSMS: Show Emoji in Results and Database Names
To show a smiley in SSMS, type the emoji inside an N-prefixed string and run the query. This post explains how SQL Server stores each emoji as two characters, why two different emoji can compare as equal, and how to find them in a column. It also shows what happens when an emoji is part of a database name.
UTF-8 Collations in SQL Server 2019: When They Save Space
Compare UTF-8 collations with NVARCHAR storage for English, European, and Asian text before converting indexes or clients.