Particular String
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
We hit this exact problem today, so it was great to have read about it previously & recently, in trying to research it further (& with the help of bing translate) I found the following article which was useful for some extra details.
http://www.db-berater.de/2017/02/optimierung-von-like-suche/
Oh wow! What a mess. They never should have let strings in the database.