SQL Server 2008 – iFTS New features
previous post I talked about Full Text in general. I will now talk about whats
new in SQL Server 2008.
categorise the new features into Performance, Manageability and Transparency. So
what’s new in SQL Server 2008, well we have,
Full Text Indexes are stored in the
Full Text Query engine is part of the
main SQL Server Query Engine
Words in a Full Text Index are visible.
Words in a document are
Noise words are no longer in a text file
but stored in the database and are called Stop Lists
Contents of a Stop List can be amended
on the fly (pre indexed content will not be amended) without restarting SQL
Thesaurus Files can be amended on the
fly without restarting SQL Server
Indexes are maintained in SQL Server
memory rather than the OS.
A new function exists to show how a
query gets translated by word breaking, stop lists and thesaurus’s
10. A new external process is used to index content. (This is for
security and stability reasons as iFilters can be written by anybody)
11. Support for filestream data, which means you don’t have to blobs in
your database and means managing file growth is easier.
If you are wondering iFTS means Integrated Full Text Search which is what it
The following are the other posts in the series
If you want to try iFTS you can download the SQL Server 2008 from here http://www.microsoft.com/sql/2008/prodinfo/download.mspx