SQL Server 2008 – iFTS New features

In the previous post I talked about Full Text in general. I will now talk about whats new in SQL Server 2008.

I would categorise the new features into Performance, Manageability and Transparency. So what’s new in SQL Server 2008, well we have,

1.       Full Text Indexes are stored in the database

2.       Full Text Query engine is part of the main SQL Server Query Engine

3.       Words in a Full Text Index are visible.

4.       Words in a document are

5.       Noise words are no longer in a text file but stored in the database and are called Stop Lists

6.       Contents of a Stop List can be amended on the fly (pre indexed content will not be amended) without restarting SQL Server

7.       Thesaurus Files can be amended on the fly without restarting SQL Server

8.       Indexes are maintained in SQL Server memory rather than the OS.

9.       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 is.

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


Published Wednesday, February 20, 2008 9:38 AM by simonsabin


Wednesday, February 20, 2008 3:09 PM by Jason Haley

# Interesting Finds: February 20, 2008

Thursday, March 6, 2008 10:56 PM by Prasanna

# re: SQL Server 2008 – iFTS New features

FYI - URL to "SQL Server 2008 – iFTS Introduction" (http://sqlblogcasts.com/blogs/simons/archive/2008/02/19/SQL-Server-2008---iFTS-Introdction.aspx) is not working.

Tuesday, October 7, 2008 8:50 AM by SQL Server, BizTalk Server, le 64 bits et au-delà !...

# SQL Server 2008 - Integrated Full Text Search (iFTS) ...

Voici une suite de 6 articles très intéressants sur les nouveautés de la recherche en

Sunday, January 18, 2009 4:42 PM by SQL 2008 Full text indexing | keyongtech

# SQL 2008 Full text indexing | keyongtech

Pingback from  SQL 2008 Full text indexing | keyongtech

Wednesday, February 10, 2010 8:58 AM by Simon Sabin UK SQL Consultant's Blog

# Microsoft ditches Unix in the search market

Wednesday, February 10, 2010 9:41 AM by SimonS Blog on SQL Server Stuff

# Microsoft ditches Unix in the search market

Search is one of my interests, where ever you go, whatever business you are in search is the like a holy