Solved

"noise" words in fulltext

Posted on 2002-06-22
7
473 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
ID: 7101052
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
ID: 7101055
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
ID: 7101058
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
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 8444696
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
ID: 8445771
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
ID: 8492628
per recommendation.

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MSSQL join different row from other table 14 65
SQL Select - identify record discrepancies 1 30
SQL Server Trigger 8 33
Related to SQL Query 5 17
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…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

685 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