Re: Ignored words problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Nick Gilbert (news_at_nickgilbert.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 10:04:34 +0100

Thanks John and Hilary for your detailed replies!

How so I tell if I'm using noise.enu or noise.eng? Hopefully I'm using
noise.eng because I'm in the UK, but I didn't build the server...

Thanks,

Nick....

John Kane wrote:

> Nick,
> First of all, I agree that the "A clause of the query contained only ignored
> words" problem is frustrating error to get with fulltext searches... It's
> been a pain ever since SQL 7.0 Beta3 was shipped in 1998 and once SQL Server
> 2005 (Yukon) this error will be controllable from an sp_configure setting -
> sp_configure 'transform noise words' - so you can turn off this check in SQL
> Server 2005...
>
> However, i n SQL Server 2000, you cannot *prevent* this error, but you can
> avoid it either via removing noise words from the specific language specific
> noise.* file that you are using in your FT-enabled columns. If you are using
> a web-based client tool (IE, etc) you can use either of the attached files -
> SearchPage.htm or SearchPage.zip (a zipped version of SearchPage.htm) that
> demonstrates how to remove the noise words & single letters & single numbers
> prior to submitting the user's query input to SQL Server.
>
> Q. Is it safe to change my noise words file to be empty and force a repop?
> A. Yes. Not only safe, but recommended to remove specific noise words or
> single letters & single numbers vs. emptying the entire noise.enu
> (US_English) or noise.eng (UK_English) file and then run a Full Population
> on all of your FT Catalogs.
>
> Q. Why does the below query match the pleurals (or US spelling - plurals)
> when I'm not using FORMSOF(INFLECTIONAL,blah)?
> A. Because you're jsing FREETEXT vs. CONTAINS in your query. FREETEXT is
> more forgiving, i.e., fuzzy than CONTAINS as you would not get the same
> results CONTAINS. For example using the FT-enable table pub_info in the pubs
> database and searching on 'book' will not return rows that contain 'books':
>
> select pub_id, pr_info
> from pub_info
> where contains(*,'book')
> /* -- 'books' returns:
> pub_id pr_info
> ------ --------------------------------------------------
> 9952 This is sample text data for Scootney Books, publi
> 0736 This is sample text data for New Moon Books, publi
> (2 row(s) affected)
>
> -- 'book' returns:
> pub_id pr_info
> ------ --------------------------------------------------
> (0 row(s) affected)
> */
>
> Regards,
> John
>
>
>
> "Nick Gilbert" <news@nickgilbert.com> wrote in message
> news:OSzBuMmaEHA.2056@TK2MSFTNGP12.phx.gbl...
>> Why does the below query match the pleurals when I'm not using
>> FORMSOF(INFLECTIONAL,blah)?
>>
>> SELECT Category as CategoryName
>> FROM tblCategory
>> WHERE FREETEXT(tblCategory.*, 'studios')
>> AND FREETEXT(tblCategory.*, 'charts')
>>
>> Results:
>>
>> CategoryName
>> --------------------------------
>> Studio Chart
>> Studio Chart, Specialised Stages
>>
>>
>> I thought you had to use FORMSOF INFLECTIONAL to get it to match pleurals?
>>
>> Nick...
>
>
>
> *Search:*
>
>

Relevant Pages

  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Performance Benchmarks?
    ... Are attribute relationships defined properly on the dimensions? ... If you run Profiler against the server, how long is spent in "Query ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • High CPU in client (Excel, OWC, Proclarity, etc.) accessing Analysis Services
    ... the OWC10 with 3 dimensions on the row axis, ... The largest size of any of these 4 dimensions < 360 members. ... Performance Guide to optimize the query, the cube, the server, etc. ...
    (microsoft.public.sqlserver.olap)
  • Re: Performance Benchmarks?
    ... adding memory on the server can help you; more data can be cached on the ... Here is my test query. ... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design). ...
    (microsoft.public.sqlserver.olap)
  • Re: MailMerge hangs and crashes with Access on Server
    ... restructuring a complex query. ... discards 99% of them), or on the server side, incurring no network ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ...
    (microsoft.public.word.mailmerge.fields)