SQL Server Full-Text Search - SQL Server 2000 F/T and WSS

Author

SQL Server 2000 F/T and WSS

e-Merging Solutions

2005-06-23, 9:23 am

Hello, I recently posted this question on the WSS group, and it was
recommended that we post the question here, since WSS uses the SQL Server
F/T engine.

We have WSS 2003 running on a SQL Server 2000. WSS. We tested F/T searches
and the documents that we expect should be coming at the top
of the list (the ones with more instances of the keyword being searched) are
not - ones with less instances come before.

Does anyone understand how the MS SQL Server F/T engine logic works (i.e.
how does it determine the relevancy of documents) when use in combination
with WSS.

Thanks.

John Kane

2005-06-23, 11:23 am

e-Merging Solutions,
Yes, I do as I just completed presented on these topics at DevTeach 2005.
However, I need some additional information from you, can you post the full
output of -- SELECT @@version -- as this will provide me with both the exact
version of SQL Server (plus SP level) as well as the OS Platform that you
are using.

Additionally, WSS 2003 (or Sharepoint 2003) by default uses FREETEXTTABLE
vs. CONTAINSTABLE that can provide a more precise results. You can use the
REPLACE function to replace CONTAINSTABLE for the FREETEXTTABLE if you want
to get more precise results, however, CONTAINS while more precise uses more
than just the number of keyword per row as a factor in determining the RANK
value for any row returned.

Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/

"e-Merging Solutions" <office@e-mergingsolutions.com> wrote in message
news:#etm#2$dFHA.220@TK2MSFTNGP12.phx.gbl...
> Hello, I recently posted this question on the WSS group, and it was
> recommended that we post the question here, since WSS uses the SQL Server
> F/T engine.
>
> We have WSS 2003 running on a SQL Server 2000. WSS. We tested F/T
searches
> and the documents that we expect should be coming at the top
> of the list (the ones with more instances of the keyword being searched)
are
> not - ones with less instances come before.
>
> Does anyone understand how the MS SQL Server F/T engine logic works (i.e.
> how does it determine the relevancy of documents) when use in combination
> with WSS.
>
> Thanks.
>
>
>
>

e-Merging Solutions

2005-06-23, 1:23 pm

John,

Here's the result of running --SELECT @@version--:

"Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: )"

Thanks

"John Kane" <jt-kane@comcast.net> wrote in message
news:OKyPAmAeFHA.892@tk2msftngp13.phx.gbl...
> e-Merging Solutions,
> Yes, I do as I just completed presented on these topics at DevTeach 2005.
> However, I need some additional information from you, can you post the
> full
> output of -- SELECT @@version -- as this will provide me with both the
> exact
> version of SQL Server (plus SP level) as well as the OS Platform that you
> are using.
>
> Additionally, WSS 2003 (or Sharepoint 2003) by default uses FREETEXTTABLE
> vs. CONTAINSTABLE that can provide a more precise results. You can use the
> REPLACE function to replace CONTAINSTABLE for the FREETEXTTABLE if you
> want
> to get more precise results, however, CONTAINS while more precise uses
> more
> than just the number of keyword per row as a factor in determining the
> RANK
> value for any row returned.
>
> Thanks,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
>
>
> "e-Merging Solutions" <office@e-mergingsolutions.com> wrote in message
> news:#etm#2$dFHA.220@TK2MSFTNGP12.phx.gbl...
> searches
> are
>
>

2005-07-18, 8:24 pm

I suspect the root of your dismay lies within the very default. FREETEXTTABLE
searches by meaning, while you were probably expecting it to find exact
matches to your expressions.

I'd expect better (or more appropriate results) with the CONTAINSTABLE
function.

ML

Hilary Cotter

2005-07-19, 1:23 pm

I'm going to quibble here. Freetext merely stems words according to its
declensions (i.e. plural, possessive) and conjugations (all verb forms). Its
not exactly meaning; BOL is not exactly clear here. For example it can't
distinguish between the meaning of the word bank in the phrases "I went to
the bank" or "I saw her on the left bank", or "The car banked to the right."

--
Hilary Cotter
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
"ML" <ML@discussions.microsoft.com> wrote in message
news:F183DA80-8E68-40D2-AC09- CEBAE9F73A16@microso
ft.com...
> I suspect the root of your dismay lies within the very default.
FREETEXTTABLE
> searches by meaning, while you were probably expecting it to find exact
> matches to your expressions.
>
> I'd expect better (or more appropriate results) with the CONTAINSTABLE
> function.
>
>
> ML

2005-07-19, 8:24 pm

I see. Thank you. I guess BOL really explains this a bit differently.

I thought this was just due to the fact that my native language (Slovenian)
is not natively supported by SQL. Since I have come across results that do
support your explanation.

ML

Sponsored Links