Hello Mike C#, See my series here http://sqlblogcasts.com/blogs/simons/archive/2008/02/20/SQL-Server-2008---iFTS-New-features-.aspx Simon Sabin SQL Server MVP http://sqlblogcasts.com/blogs/simons > "Jean-Pierre Riehl" wrote in message > news:4DA0019C-01EF-4718-BC6D-1660EC4E8AD6@microsoft.com... > >> Hi, >> >> Yes, that is a major issue to integrate full-text engine into SQL >> Server. One of the side effects is performance improvement since >> full-text querying is included as operators in Query Execution Plan. >> >> Here are some improvements announced (i'm waiting for next CTP to >> test it) >> : >> -40 new languages >> -Noise words management with T-SQL (CREATE FULLTEXT STOPLITS >> -Thesaurus stored in system table and instance-scoped >> -indexed keywords querying >> -full-text parser querying > You can create fulltext stoplists in the current CTP. You can also > use new DMV functions to see how your full-text queries are parsed and > to view full-text index keyword entries in the current CTP. The > thesaurus is currently still stored in the file system on this CTP. >
"Simon Sabin" <SimonSabin@noemail.noemail> wrote in message news:7e76d285b9b358ca56d899ba7b29@msnews.microsoft.com... > Hello Mike C#, > > See my series here > http://sqlblogcasts.com/blogs/simons/archive/2008/02/20/SQL-Server-2008---iFTS-New-features-.aspx Hi Simon, nice blog, but shouldn't you be directing it to Jean-Pierre? :) Since you're here anyway, any plans to put Thesaurus in the database or will it remain in the file system in the near future?
