Microsoft® SQL Server 2005 Unleashed

Chapter 49. SQL Server Full-Text Search

IN THIS CHAPTER

• What’s New in SQL Server 2005 Full-Text Search

• How SQL Server FTS Works

• Setting Up a Full-Text Index

• Full-Text Searches

• Full-Text Search Maintenance

• Full-Text Search Performance

This chapter looks at how to use SQL Server 2005 Full-Text Search (FTS). SQL Server FTS allows you to do extremely fast searches of textual contents stored in columns of the char, nchar, varchar, nvarchar, varchar(max), nvarchar(max), and text data types and binary content stored in image and varbinary(max) data types (if you have an IFilter for the data stored in the image or varbinary(max) data types).

SQL Server FTS has considerable advantages over a search based on a LIKE clause because it is faster, can search binary ...