Solved

how to find noise file and edit in MS SQL

Posted on 2008-10-02
8
330 Views
Last Modified: 2012-05-05
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
Comment
Question by:lin111106
[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
  • 3
  • 3
  • 2
8 Comments
 
LVL 5

Expert Comment

by:jose_juan
ID: 22623041
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
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22624399
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
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22624411
Oh, and by the way... SQL2000 and SQL2005 had Noise Words for its full text search, SQL2008 has moved to StopWords
0
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

Author Comment

by:lin111106
ID: 22624581
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
 
LVL 5

Expert Comment

by:jose_juan
ID: 22624770
You must regenerate text catalog for apply effects.
0
 

Author Comment

by:lin111106
ID: 22625137
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
 
LVL 51

Expert Comment

by:Mark Wills
ID: 22625254
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
 
LVL 5

Accepted Solution

by:
jose_juan earned 250 total points
ID: 22625263
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

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database-Scoped Permissions 2 42
How do I partition this table on date? 5 55
Search Text in Views 2 28
How to create and use encrypted columns in SQL 2005? 15 64
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

710 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