Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

how to find noise file and edit in MS SQL

Having a search issue from web to MS SQL.  Someone suggested that I check the  Free Text Search Noise Words file in SQL.    I don't know where to find this so that I can remove the word "under" which is what I want to be able to search for, however it doesn't come up?

I can search "underarmour", undera, underanything, etc.   Just not the word under.  How do I find and edit.  Thank you.
0
lin111106
Asked:
lin111106
  • 3
  • 3
  • 2
1 Solution
 
jose_juanCommented:
Hi,

search files like

 noise*.txt

on

\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\

you can remove all words of only to you need.

Good luck!
0
 
Mark WillsTopic AdvisorCommented:
Ummmm, which version are you on ?

SQL2008 : http://msdn.microsoft.com/en-us/library/ms142551.aspx
SQL2005 : (link on the above site)
SQL2000 : http://msdn.microsoft.com/en-us/library/aa172881(SQL.80).aspx     see : \Mssql\Ftdata\Sqlserver\Config then the file name accordingly.
0
 
Mark WillsTopic AdvisorCommented:
Oh, and by the way... SQL2000 and SQL2005 had Noise Words for its full text search, SQL2008 has moved to StopWords
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
lin111106Author Commented:
I have found the file for editing.  Sub question:  if I remove a word will it effect any programming or the program itself?  The word I want to remove is "under" so that our search will work.  I guess I don't understand what the noise file actually does, and the words in that file what is the purpose?
0
 
jose_juanCommented:
You must regenerate text catalog for apply effects.
0
 
lin111106Author Commented:
Ask again,  if I remove this word will it effect any programming in the database.  Stored procedures etc etc.  What exactly is this files purpose?
0
 
Mark WillsTopic AdvisorCommented:
Some of those links describe what you are asking, and to summarise, no it wont affect the syntax of the programming, but you may get different results / extracts. Noise words are designed to say "ignore me" so in full-text searching, only the more significant words will match. By reducing "noise words" it can mean that there is a greater opportunity to return matches that are based on "noise" - increasing rowset volumes, and search times. So, do not remove the file, but clean it up... And be careful.
0
 
jose_juanCommented:
The purpose of this files are exclude index generation for existing words (in files), is most cases, this words are very frequents.

If your databases text information not are very huge (>10 giga) you can remove all words and all words would be searched.

I made this, frequently.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now