Querying Full-Text Data in Microsoft SQL Server 2012

  • 12/15/2012

Suggested Practices

To help you successfully master the exam objectives presented in this chapter, complete the following tasks.

Check the FTS Dynamic Management Views and Backup and Restore of a Full-Text Catalog and Indexes

There is also some administrative work involved with full-text indexes. For a brief introduction to this administrative work, you should review the information provided by the dynamic management views that deal with full-text search and semantic search, and learn how to back up full-text catalogs and full-text indexes.

  • Practice 1 In order to understand full-text search thoroughly, check the information provided in the following dynamic management views:

    • sys.dm_fts_active_catalogs

    • sys.dm_fts_fdhosts

    • sys.dm_fts_index_keywords_by_document

    • sys.dm_fts_index_keywords_by_property

    • sys.dm_fts_index_keywords

    • sys.dm_fts_index_population

    • sys.dm_fts_memory_buffers

    • sys.dm_fts_memory_pools

    • sys.dm_fts_outstanding_batches

    • sys.dm_fts_parser

    • sys.dm_fts_population_ranges

    • sys.dm_fts_semantic_similarity_population

  • Practice 2 Backup and restore is a very typical DBA job. You should have basic knowledge of how to include full-text catalogs and indexes in a backup. See the Books Online for SQL Server 2012 article “Back Up and Restore Full-Text Catalogs and Indexes” at http://msdn.microsoft.com/en-us/library/ms142511.aspx to study how to perform the following tasks:

    • Finding the full-text indexes of a full-text catalog

    • Finding the file group or file that contains a full-text index

    • Backing up the file groups that contain full-text indexes