All versions of SQL Server that have supported full-text search have included an option to ignore certain words that are considered unimportant for search purposes. In SQL Server 2005 and earlier, this option was known as the noise word list. Noise word lists were language-specific text files stored in the file system. In SQL Server 2008, noise word lists have been replaced by stoplists, which are likewise composed of words, known as stopwords, that are unimportant for search. Unlike noise word lists, stoplists are stored in the database rather than in the file system. SQL Server 2008 also provides T-SQL language improvements designed to make stoplists more flexible than noise word lists and to facilitate and ease their management.


File System Partial Result Specific Language Full Population Prior Version 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Coles and Hilary Cotter 2009

Personalised recommendations