Install and Configure Semantic Search
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Describes the prerequisites for statistical semantic search and how to install or check them.
I want to …
Install Semantic Search
Install or Remove the Semantic Language Statistics Database
Install Optional Support for Newer Document Types
How To: Check Whether Semantic Search Is Installed
Query the IsFullTextInstalled property of the SERVERPROPERTY (Transact-SQL) metadata function.
A return value of 1 indicates that Full-Text Search and Semantic Search are installed; a return value of 0 indicates that they are not installed.
How To: Install Semantic Search
To install Semantic Search, select Full-Text and Semantic Extractions for Search on the Features to Install page during setup.
Statistical Semantic Search depends on Full-Text Search. These two optional features of SQL Server are installed together.
Semantic Search has an additional external dependency that is called the semantic language statistics database. This database contains the statistical language models required by semantic search. A single semantic language statistics database contains the language models for all the languages that are supported for semantic indexing.
How To: Check Whether the Semantic Language Statistics Database Is Installed
Query the catalog view sys.fulltext_semantic_language_statistics_database (Transact-SQL).
If the semantic language statistics database is installed and registered for the instance, then the query results contain a single row of information about the database.
How To: Install, Attach, and Register the Semantic Language Statistics Database
The semantic language statistics database is not installed by the SQL Server setup program. To set up the Semantic Language Statistics database as a prerequisite for semantic indexing, do the following tasks:
How To: Unregister, Detach, and Remove the Semantic Language Statistics Database
Requirements and Restrictions for Installing and Removing the Semantic Language Statistics Database
You can only attach and register one semantic language statistics database on an instance of SQL Server.
Each instance of SQL Server on a single computer requires a separate physical copy of the semantic language statistics database. Attach one copy to each instance.
You cannot detach a valid and registered semantic language statistics database and replace it with an arbitrary database that has the same name. Doing so will cause active or future index populations to fail.
The semantic language statistics database is read-only. You cannot customize this database. If you alter the content of the database in any way, the results for future semantic indexing are indeterministic. To restore the original state of this data, you can drop the altered database, and download and attach a new and unaltered copy of the database.
It is possible to detach or drop the semantic language statistics database. If there are any active indexing operations that have read locks on the database, then the detach or drop operation will fail or time out. This is consistent with existing behavior. After the database is removed, semantic indexing operations will fail.
How to: Install the Latest Filters for Microsoft Office and other Microsoft Document Types
This release of SQL Server installs the latest Microsoft word breakers and stemmers, but does not install the latest filters for Microsoft Office documents and other Microsoft document types. These filters are required for indexing documents created with recent versions of Microsoft Office and other Microsoft applications. To download the latest filters, see Microsoft Office 2010 Filter Packs.