Re: Noise Words

Sorry - to clarify, it is SQL 2005. My understanding is that the
noise words should be removed automatically.

Anyone?

On Oct 2, 10:10 pm, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
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 FTShttp://www.indexserverfaq.com<toddwpr...@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
    ... This can be resolved without making the UDF "infallible", ... Removing the noise words, as well as not passing empty or null strings ... SQL Full Text Search Blog ... if this query causes an ignored-word error ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Ignored words problem
    ... both freetext and freetexttable can also generate error "A ... clause of the query contained only ignored words". ... >> avoid it either via removing noise words from the specific language ... >> 9952 This is sample text data for Scootney Books, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Where can I find a list of word breakers?
    ... "transform noise words" or that SQL could do phrase searching. ... It is possible, though, that I'll be forced to deploy on SQL 2000, because ... Both the query and the database text ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Where can I find a list of word breakers?
    ... transform noisewords is a new feature in SQL 2005 but it only affects ... SQL 2000 supports phrase queries though and should work fine when one or ... A real phrase query is something like this: ... > "transform noise words" or that SQL could do phrase searching. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Ignored words problem
    ... I agree that the "A clause of the query contained only ignored ... been a pain ever since SQL 7.0 Beta3 was shipped in 1998 and once SQL Server ... sp_configure 'transform noise words' - so you can turn off this check in SQL ... database and searching on 'book' will not return rows that contain 'books': ...
    (microsoft.public.sqlserver.fulltext)
Loading