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