Solved

"noise" words in fulltext

Posted on 2002-06-22
7
476 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

 
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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

729 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