Searching for data in our systems is sometimes hard. If you've ever needed to generically search a lot of text, it's not easy to write code to do this in an efficient manner. It's even harder if you try to embed this in an application. If you get into full-text searching, likely you would look beyond SQL Server as the built in full-text indexing and searching isn't great.

What if you had to search in more complex data? Imagine that your users were looking for words in audio files, or they wanted to find images that matched other images. Those are even more complex searches, and I expect that few people have had to deal with this. I know some, and I do expect it to be something customers will do demand across time.

Read the rest of Complex Searching