Solved

"noise" words in fulltext

Posted on 2002-06-22
7
467 Views
Last Modified: 2008-03-17
The file "ftdata\noise.eng" contains all the words fulltext is ignoring like "all","after" and so on.
can i change this list to fit my needs?
0
Comment
Question by:pinkman
  • 4
7 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 100 total points
Comment Utility
Sure.  From MSDN:

<quote>
To prevent the full-text index from becoming bloated, noise-words (words that are too common to expedite the search, such as "a,"and,"the," and "therefore") are ignored. Noise-word lists for many languages are available in the directory \Mssql\Ftdata\Sqlserver\Config. And the set of supported languages is growing. The choice of a particular noise-word list is based on the language of the material that is file-format dependent during the filtering process. Some files set the language per section or paragraph; some specify it for the entire document. These noise-word lists should be sufficient for most operations, but they can be modified. Administrators can use a regular text editor to modify the contents of a list. For example, a computer company can add the word "computer" to its noise-word list.
</quote>

It does not explicitly say it, but I suspect you have to re-populate the full text search.

Anthony
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
I just confirmed it, you need to re-populate the full-text search catalogs, before any change to the noise-word file takes effect.

Anthony
0
 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
Also, when you get a chance, please maintain your open questions:
pictures and combo box within flexgrid Date: 02/11/2002 04:06AM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20265485
restore  on a different server from .bak and .trn files Date: 11/07/2001 06:59PM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20229226
error handling in functions Date: 02/19/2002 06:09AM PST  
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20268556
defragment disk and sql performance Date: 06/04/2002 04:53AM PST  
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20307611
close programs from command line Date: 05/29/2002 09:13AM PST
http://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20305862

Thanks,
Anthony
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 75

Expert Comment

by:Anthony Perkins
Comment Utility
Dan,

Could you take a second look.  Not to "blow my own trumpet", but I believe I gave the correct answer.

Anthony
0
 
LVL 49

Expert Comment

by:DanRollins
Comment Utility
Thanks for the feedback acperkins.  
I'll get this off the auto-delete list and recommend your comment as the answer.
-- Dan
0
 

Expert Comment

by:SpideyMod
Comment Utility
per recommendation.

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now