Showing posts with label offquot. Show all posts
Showing posts with label offquot. Show all posts

Wednesday, March 7, 2012

Noise words

Could someone tell me how I "turn off" the noise word filtering for SQL server?

My problem is that I use the neutral language (defaults to english) and it strips out some words I do not want stripped from my queries. So in this particular case, I would like to be able to turn off noise word filtering altogether.

Ideas?

Noise words are stored in a text file, by default, it is in

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\

Just edit the noiseNEU.txt for neutral language. Delete the word in the file. You may need to restart sql server and recrawl your index.

Noise words

Could someone tell me how I "turn off" the noise word filtering for SQL server?

My problem is that I use the neutral language (defaults to english) and it strips out some words I do not want stripped from my queries. So in this particular case, I would like to be able to turn off noise word filtering altogether.

Ideas?

Noise words are stored in a text file, by default, it is in

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\

Just edit the noiseNEU.txt for neutral language. Delete the word in the file. You may need to restart sql server and recrawl your index.