SQL Server - Full-Text Search

While standard indexes (B-Trees) are like the index at the back of a book (sorted lists), Full-Text Indexes are like a search engine (Google/Bing) built inside your database. They are designed to query large amounts of unstructured text. 1. The Probl...