How to do a Case-sensitive Search? I was asked this by one of my clients of Comprehensive Database Performance Health Check.
I discussed the method to change the database and table collation with my client during the Comprehensive Database Performance Health Check.
Question: How to Do Case Insensitive Search?
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data.
I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated. We are going to about the global variable @@DEF_SORTORDER_ID. Let us see what it is and how it was used once.
One of my blog readers sent email to me asking if there is a way to convert CollationID to Collation name. I replied asking more details about the requirement. Here is her reply.
I am in a trouble right now. Due to a hardware crash, I lost many of database files. Unfortunately, I don’t have backups, but I was able to retrieve MDF files. I was trying to follow your blog