|
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...
|
|
|
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.
|
Video Information
|
Publish Date:
|
November 06, 2008
|
Length:
|
5:8
|
Skill Level:
|
100
|
Rating:
|
4.50 out of 5
|
|
|
|
|
After watching you should be able to answer these questions:
- If we add a word to the stop list and then run a query to search the full text index for it, which of the following will happen?
- Which of the following will create a full text stop list?
|
You must be logged in to view this video.
|
|
|
|
|
|
Comments:
|
Richard Berndt on 12/30/2008
I think it it would be useful to identify videos that are specific to SQL2008 only.
|
|
|
Would have loved to hear a brief elaboration on : it will revert to "system stoplist" which is what ? Now I have to "RTFM" myself ;)
|
|
|
|
|
|
|