How to do a Case-sensitive Search? I was asked this by one of my clients of Comprehensive Database Performance Health Check.
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.
SQL SERVER – Unable to Add Node – Could not find subkey System \ CurrentControlSet \ Services \ MSSQLFDLauncher. Error code 0x851B0001
Running add node on Node2 failed with “Could not find subkey MSSQLFDLauncher”, error 0x851B0001. The cause was a missing Full-Text MSI in the setup media.
SQL SERVER – Full-Text Search Not Working For PDF Documents
A client stored PDF files in a VARBINARY(MAX) column, and Full-Text search could not find text in them. Here are all the steps I used in my lab to make it work.
SQL SERVER – Tips from the SQL Development Series – Wildcard – Querying Special Characters – Day 2 of 35
Tips for Querying Special Characters with wildcards, since some symbols are tricky to pattern match. Examples use the [Grant] table in the JProCo database.
SQL SERVER – Collate – Case Sensitive SQL Query Search
Make a SQL Query Search case sensitive: add COLLATE Latin1_General_CS_AS to the WHERE clause so ‘casesearch’ matches one row instead of all four.