Other
Other
SQL Server Full-Text Search: building blocks and main features
Bart Wullems walks through SQL Server's built-in Full-Text Search, from the inverted index behind it to the query predicates you write against it. The piece explains why leading-wildcard LIKE queries can't seek an index, then shows how to create a full-text catalog and index, filter with CONTAINS and FREETEXT, rank results with CONTAINSTABLE, and control stop words.