Full Text and MS SQL 5.0

What new features does full text search support in MS SQL 5.0?
Bill,
There is no such product version that is referred to as "MS SQL 5.0".
However, I'm assuming (for now) that what you're really inquiring about is
SQL Server 2005 (codename, Yukon and internally known as SQL 9.0). Correct?
If so, below is a high-level list of improvements (Performance, Scalability
& Manageability) and new Full Text Search (FTS) features in SQL Server 2005:
* Performance & Scalability
Full-text index is more than an order of magnitude faster
30-50% speed-up on most Full-Text queries
Scalable to 2 billion rows per full-text catalog, time to index scales
linearly
* Manageability
Backup, Restore and Recovery of FT Catalogs with Database backups!
Support of database attach / detach process
* New Features
Thesaurus support via XML file and FREETEXT
Ignore noise words, truly ignored!
Specify language (LCID) at query time via CONTAINS & FREETEXT
Accent sensitivity & insensitivity control
Full-Text DDL, such as "CREATE FULLTEXT INDEX"
Enhanced language features (*better* wordbreakers and more languages
supported)
Support for the new SQL Server 2005 XML datatype
Enjoy!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Bill" <Bill541@.yahoo.com> wrote in message
news:OHEU0A$3FHA.400@.TK2MSFTNGP09.phx.gbl...
> What new features does full text search support in MS SQL 5.0?
>
>
|||"John Kane" <jt-kane@.comcast.net> wrote in message
news:e98la0B4FHA.3292@.tk2msftngp13.phx.gbl...
> Bill,
> There is no such product version that is referred to as "MS SQL 5.0".
> However, I'm assuming (for now) that what you're really inquiring about is
> SQL Server 2005 (codename, Yukon and internally known as SQL 9.0). Correct?
Sorry, me bad... Yes, I meant SQL Server 2005.
I'm hoping SQL Server 2005 supports full-text queries over multiple columns... it
doesn't appear to support this, does it?
|||No problem, Bill,
Yes, SQL Server 2005 Full-Text Search does support multiple columns in one
CONTAINS or FREETEXT statement, for example:
SELECT FTSPkey, FTSCol2, FTSCol3
FROM FTS_Table
WHERE CONTAINS(( FTSCol2, FTSCol3) , ' "john" AND "kane" ')
The above query is functionally equivalent to the following query:
SELECT FTSPkey, FTSCol2, FTSCol3
FROM FTS_Table
WHERE CONTAINS(FTSCol2, '"john" AND "kane"') OR
CONTAINS(FTSCol3, '"john" AND "kane"')
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Bill" <Bill541@.yahoo.com> wrote in message
news:O0E4HXm4FHA.3880@.TK2MSFTNGP12.phx.gbl...
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:e98la0B4FHA.3292@.tk2msftngp13.phx.gbl...
> Sorry, me bad... Yes, I meant SQL Server 2005.
> I'm hoping SQL Server 2005 supports full-text queries over multiple
> columns... it
> doesn't appear to support this, does it?
>
>