Monsters Weekly 217 - Searching Text in SQL Server

When you have a lot of data in your SQL database, searching for substrings in a column can be slow. Don’t worry, Simon has some terrible awful, no good hacks that will get those queries running as fast as possible.