Enabling Full-Text Search in your Text Data
by Microsoft
Full-Text search allows you to save large portions of text - even Microsoft Word documents, or other file formats - into your database and perform complex queries based on this textual data while expecting great performance. This lesson demonstrates how to set up Full-Text search paying particular attention to the nuances of setting it up within SQL Server Express. Then we move to creating full-text indexes, configuring the index population settings, and performing queries that demonstrate the power of the CONTAINS predicate and its many, many variations.