good, thorough documentation on full text issues?

I did something for searchsql.target.com on SQL FTS which IMHO is pretty
through. I am not sure if it has been posted yet
There is a problem with full-text indexed views which has surfaced recently
which does not offer the best performance. I would advise you to test.
I think we have the largest implementation of SQL FTS - we are indexing over
1.5 terrabytes.
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
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:%23RrzTovOHHA.4992@.TK2MSFTNGP04.phx.gbl...
> hi,
> out website is starting to get serious about switching from SQL 2000 to
> SQL 2005. in the process we hope to address a few weak points in our
> site's fulltext searching.
> i'd like to find the best possible documentation or courses to get up to
> speed on this. i have googled quite extensively and found some detailed
> information, e.g. at msdn, in newsgroups, and the two fulltext articles
> here:
> http://www.simple-talk.com/author/hilary-cotter/
> (which strike me as very good as far as they go.)
> my question is whether there are good books, articles, or courses that go
> deeper still. maybe someone has assembled a list that i haven't found yet?
> in particular i'm interested in the following issues:
> - i've read that SQL 2005 promises improvements in fulltext search, but i
> haven't seen anything dramatic in my reading and testing yet [*]; (one
> example: supposedly the german noise word list was improved, but my
> impression is it's the same as before; this is no big deal, we will
> replace it with something like the 100 most frequent German words when we
> switch to 2005 -- good breaking point)
> - i'd like to learn more about language-specific issues such as how words
> are parsed and stemming is done, in particular how can i tune and test
> these
> i'd be grateful for any pointers.
> cheers,
> Tim Hanson
> [*] one quote from one of the above-sited articles is intriguing:
> Similarly a table can be full-text indexed in a single
> catalog; or to put it another way - a table's full-text
> index cannot span catalogs. However, in SQL 2005 you
> can full-text index views which may reside in different
> catalogs than the underlying base tables. This provides
> performance benefits and allows partitioning of tables.
> however i'd need to learn much more to decide whether i can benefit from
> it.
>
"tbh" <femdev@.newsgroups.nospam> wrote in message
news:eGohcdwOHHA.4484@.TK2MSFTNGP02.phx.gbl...
> thanks.
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ut$dpGwOHHA.2312@.TK2MSFTNGP04.phx.gbl...
> hmmm. i don't find that URL. http://searchsql.target.com is there
> something missing?
Maybe he meant http://searchsqlserver.techtarget.com/? I don't think Target
Department stores has a public website for SQL Server articles... I could
be wrong though...