April 21, 2009 at 8:00 am
Hi to all,
I have one problem, i dont know if anyone had this problem yet, but i need a little help...
When i run: (example)
select * from dbo.vw_GetCatalog WHERE CONTAINS(CatalogString,'Company AND XPTO')
returns:
Company XPTO
Company XPTO 1
Company XPTO Teste
And when i run:
select * from dbo.vw_GetCatalog WHERE CONTAINS(CatalogString,'Company AND XPTO AND 1')
Dont return me anything... could someone explain to me why ?
thanks a lot
April 21, 2009 at 8:11 am
Full text search uses a list of noise words. Noise words are words that most of the time we wouldn’t want them to be indexed because it will just bloat the full text index, but most chances are that it won’t add any meaning value to the search. An example for such words are – “a”, “an”, “are”, “is”, “but”, etc’. The digits 0-9 are also part of the noise words.
The noise words are stored in files which are located in located in the $SQL_Server_Install_Path\Microsoft SQL Server\MSSQL.1\MSSQL\FTDATA\ directory. There 20 files with name like noiseXXX.txt. XXX represents the language. You can modify those files and add or delete some of the words.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
April 21, 2009 at 8:25 am
Hi Adi, thanks for the quick reply
But even that '1' (in my example) is a noise word, the fts should return me all the "company xpto" ... am i right?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply