Customizing Stop Word and Stop Lists in Full Text Indexes

Full text search provides the ability to search documents and text within SQL Server. In any language there are noise words (a, the, and) that can have a negative impact on the search results returned from a full text search. This video shows you how to customize stop word and stop lists to prevent results being returned for matching noise words.

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

Richard Berndt on 12/30/2008

I think it it would be useful to identify videos that are specific to SQL2008 only.

B750460146 on 3/23/2009

Would have loved to hear a brief elaboration on : it will revert to "system stoplist" which is what ? Now I have to "RTFM" myself ;)

Catto on 7/28/2010

Good Video! Thx

Matt on 8/11/2011

I enjoyed the video. Would like to see more and would be nice to see more real world applications for fulltext.

R Michael Lacy on 8/11/2011

Please attach demo scripts for reference.

Manole Razvan on 8/11/2011

ok

Rhys Domingo on 8/11/2011

Great video. Quiz was wrong... Please answer! Which of the following will create a full text stop list? Alter Fulltext stoplist "listname" (Correct Answer) Answer Explanation: Alter fulltext stoplist "listname" will create a new stop list

Mark Clancy on 8/11/2011

x

Charlie Bruno on 8/12/2011

I think question number two is incorrect. It asks how to create a stop list. The correct answer was show to be "Alter". This conflicts with the video that said a stop list is created with the "Create" command.

Raymond on 8/14/2011

What a great video. Sometimes one comes across a great lesson. This is one of them. Thank you so much. Raymond

Kat on 8/20/2011

I think the answer to question 2 is wrong; the question states which command will create a stoplist - not add to a stoplist. To create a stoplist it is answer 1.

Maurice Ivory on 1/11/2012

Nice Video..