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 2005 Express Edition. 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.

« Previous Lesson — Getting Started with SQL Server 2005 Express Edition

About this video:

Duration: 38 Minutes, 25 Seconds
Recorded Using: SQL Server 2005 Express Edition