Solved

"noise" words in fulltext

Posted on 2002-06-22
7
471 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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
SqlServer no dupes 25 34
Querying data from 3 SQL tables 2 31
Passing Parameter to Stored Procedure 4 24
VB.NET 2008 - SQL Timeout 9 24
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
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…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

770 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