Author:

Author Bio:

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...

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.

Video Information
Publish Date:	November 06, 2008
Length:	3:39
Skill Level:	100
Rating:	4.41 out of 5

Watch Video Now! Watch it later!

Rate This Video:	12345
	1=Poor, 3=Good, 5=Excellent

Comments:

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 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!!


Must Be Logged In

References