<toddwprice@gmail.com> wrote in message
news:1191362145.406220.303090@19g2000hsx.googlegroups.com...
> 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?
>

<toddwprice@gmail.com> wrote in message
news:1191426949.399960.42400@y42g2000hsy.googlegroups.com...
> 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...@gmail.com> 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...@gmail.com> wrote in message
>>
>> news:1191362145.406220.303090@19g2000hsx.googlegroups.com...
>>
>> > 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?
>
>

On Oct 2, 10:10 pm, "Hilary Cotter" <hilary.cot...@gmail.com> 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...@gmail.com> wrote in message
>
> news:1191362145.406220.303090@19g2000hsx.googlegroups.com...
>
> > 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?