25.09.2008

SQL Server 2005 Stop Words

Today was started more than usual cause, a bug came from UAT that tells when i search the catalog with the phrase "aç gözlü at" it returns a result
when i search "gözlü at" it returns a result but if only with the phrase "at" there are not any result come from the search.
In turkey "at" means "horse".
Thinking in turkish, how it could happen takes some time to understand but thinking "at" in english is meaningful cause it's noisy word : )

This is how you can index the word "at" (or any noisy word) in SQL Server



select @@language to understand which language is set for sql server then
go to
%ProgramFiles%\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\
open your language.txt
delete which words you want to index.(Please take a backup i'm not responsible for what you are doing.)



ALTER FULLTEXT INDEX ON SET CHANGE_TRACKING OFF
ALTER FULLTEXT INDEX ON STOP POPULATION

Restart FullText index service and then run this statement

ALTER FULLTEXT INDEX ON ViewGameSearch SET CHANGE_TRACKING AUTO

or
you can

delete keyword (i told how you can do it)
drop the fulltext index
restart the fulltext index service
recreate the fulltext index.

This is the case of the day : )

Hiç yorum yok: