Re: Noise Words

Not in SQL 2000. It bombs on this message. You will have to trim this noise
word out from your query or remove it from your noise word list.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<toddwprice@xxxxxxxxx> wrote in message
news:1191362145.406220.303090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
This query returns several rows:

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?



.

Relevant Pages

  • 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: 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)
  • Noise Words
    ... This query returns several rows: ... noise words file. ... Shouldn't I get the exact same number of results for ...
    (microsoft.public.sqlserver.fulltext)
  • Any idea how to avoid "The query contained only ignored words" exception?
    ... The question is about how I can avoid the exception? ... Then I assume I have to scan the input query to filter the noise word. ...
    (microsoft.public.inetserver.indexserver)