SELECT *
FROM ContainsTable(Article, *, '"Working" AND "Women" AND "Healthy"')
But this one returns none:
SELECT *
FROM ContainsTable(Article, *, '"Working" AND "Women" AND "Healthy"
AND "Are"')
I get the informational 'The full-text search condition contained
noise word(s).' on the second query, so the word "Are" must be in the
noise words file.
My question is this: if "Are" is a noise word, why does it affect my
query results? Shouldn't I get the exact same number of results for
each query?
Re: noise words, @@ERROR, and stop and resume indexing ... > Noiseword varcharNot Null ... > the data from the noise file to the noise_words table. ... >> A clause of the query contained only ignored words. ... >> into query analyzer before starting the stored procedure.... (microsoft.public.sqlserver.fulltext)
Re: Noise Words ... You will have to trim this noise ... word out from your query or remove it from your noise word list.... Looking for a SQL Server replication book?... (microsoft.public.sqlserver.fulltext)
Re: Ignored Words Problem ... FT Catalog and improve FTS query performance.... > The noise word file/list is used while indexing and while querying. ... > On a side note the FreeText and FreeTextTable queries do not generate this ... > For instance Google runs a Contains type query. ... (microsoft.public.sqlserver.fulltext)
Re: Channel swap ... His reply did nothing to assist me in my query and he implied that I ... I re-read his reply and agree that it wasn't exactly relevant to your ... I'm not supporting anything that contributes to noise.... that you stop treating this group as your own personal domain.... (rec.audio.pro)
