O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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 17. Full-Text Indexing

After completing this chapter, you will be able to

  • Create a full-text catalog

  • Create and populate a full-text index

  • Query full-text data

Database platforms are designed to store and provide rapid retrieval of very large amounts of data. Efficient storage and retrieval is accomplished due to the structure that is imposed on relational data. Unfortunately, not all data within an organization can be structured into the neat rows and columns of a table. In order to handle unstructured data stored in FILESTREAM, XML, and large character columns, SQL Server has an alternate indexing engine designed to provide flexible search capabilities. This chapter will explain how to build full-text catalogs and indexes, as well as how ...

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