Querying Full Text Indexes Using the FormsOf method

Full text search provides the ability to search documents and text within SQL Server. There are several ways to query full text indexes. This video shows you how to use the FormsOf method to query your full text indexes.

Robert C. Cain is a Microsoft MVP in SQL Development, and works as a Senior BI Architect for ComFrame. His main responsibility is the SQL Server Business Intelligence Data Warehouse for the NASA ARES project. He is also a contributing author to the book "SQL Server MVP Deep Dives". Prior to his current position, Robert spent five years working for a south eastern nuclear power company designing an...

Team FAB on 8/6/2009

would have been nice to see some thesaurus data in the example

4B47653576 on 8/6/2009

very good, nice to have understood the cost as well of the differences

Jonathan Winer on 8/6/2009

Not entirely related to the video, but adding the Top_N_By_Rank parameter to the contains table to further restrict results would have been nice to see. Also, any explanation around the Top_N_By_Rank parameter behavior when used.

wayne dismukes on 8/6/2009

Good information. He spoke slow enough that the concept could be easily understood.

Don Weigend on 8/6/2009

This is an excellent tip!!! It will certainly come in handy with our systems.

bc on 8/6/2009

would have been good to show each query on its own, rather than overwriting the same one. makes it easier to compare the syntax.

borjonx on 8/6/2009

good, clear, consice speaker - but shoulda used a word other than "ride" that DOES have results from thesaurus - since that's what he was freakin' trying to show.

Tim Harms on 8/6/2009

That's perfect! I'm starting to work on a page that requires some pretty intense string searches and knowing this will help a lot. Great video!

Tracy on 8/12/2009

very well presented and very USEFUL!!

Leonard Peoples on 7/26/2010

Great tips and video. Thanks for sharing.

Charlie Bruno on 7/27/2010

Very well explained by the author.

gabirulucas on 7/27/2010

Nothing

32DE12EB89 on 7/28/2010

I had no idea this power existed in SQL server. Thanks!!

Diana Dee on 7/31/2010

Excellent pace and presentation content. Just right!

Dexter Jones on 8/3/2010

Nice job on a murky, under-documented subject. Hope there are more to follow. Thanks!

Christopher Buller on 1/4/2012

I normally Unioned together queries to find the different contains, this saves a lot of work. Thanks!

huruy yohannes on 1/4/2012

It was hard to follow, there were some words used that needed further explanation.

Tahir A. Syed on 1/4/2012

marvelous! I appreciate a great new stuff, thanks...Tahir

Stephen Oesterreicher on 1/4/2012

You should have used a word that was in the Thersaus, but the topic was good to know more about.

John Breidenbach on 1/4/2012

Need Full Text Specificiation Spec

Yuri on 1/4/2012

A bit confusing final aim

John O'Sullivan on 1/5/2012

an excellent tip