Page view counter

Enabling Full-Text Search in your Text Data

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.

Duration: 38 minutes, 25 seconds

Date: 14 November 2006

Watch the video   |   Download the video

Comments : 8

Leave a Comment

jntiwari9 : On March 31, 2008 8:06 AM said:

Dear Sir,

This is wonderful things for the beginners and it provides everthing what they want.Can you provide me the ready-made software on Visual Basic with coding?

Thanks,

J.N.Tiwari

Uplink : On April 25, 2008 4:20 AM said:

please, where is video link?? thx Uplink

salmanahmedsiddiqui : On June 20, 2008 10:22 AM said:

could please arrange code in c# so that i can store word file into sql batabase

gopikrishnag : On July 15, 2008 6:52 AM said:

Hi

This video is excellent, if the author add 'noise words' details well and good.

this is the link.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/43b5ce7 b-9f09-4443-8a5b-c3da6eb28bcc.htm

Thanks

Gopikrishna G

b.ncube : On July 16, 2008 10:43 AM said:

Hi

Lovely tutorial, time is a valuable commodity and this 38min Tutorial saved me a couple of hours, maybe even days....

muhammed : On July 18, 2008 12:09 PM said:

this was a good video for a beginner like me

Pakistan : On September 10, 2008 5:35 AM said:

Need oledb

Pakistan : On September 17, 2008 6:33 AM said:

How to use Contains clause in Query builder of visual studio? ? ? ? ?

Leave a Comment

You must be logged in to leave a comment. Click here to log in.

Microsoft Communities