O'Reilly logo

Microsoft® SQL Server 2005 Unleashed by John Kane, Tudor Trufinescu, Alex T. Silverstein, Chris Gallelli, Paul Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 49. SQL Server Full-Text Search

IN THIS CHAPTER

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required