Microsoft® SQL Server® 2012 SP1 Semantic Language Statistics

Select Language:
The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft® SQL Server® 2012 SP1 Semantic Language Statistics.
  • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.


    File Name:



    Date Published:


    File Size:

    177.4 MB

    177.2 MB

      The Semantic Language Statistics Database is a required component for the Statistical Semantic Search feature in Microsoft® SQL Server® 2012 SP1. You can download this database from this page, attach it to your Microsoft® SQL Server® 2012 SP1 instance, and register it to use the new Semantic Search features.

      Statistical Semantic Search provides deep insight into unstructured documents stored in SQL Server databases by extracting and indexing statistically relevant key phrases and similar documents based on this keyphrases. Semantic Search builds upon the existing Full-Text Search feature in SQL Server, and enables new scenarios that extend beyond keyword searches into the meaning of the document. Solutions that are now possible include automatic tag extraction, related content discovery, and hierarchical navigation across similar content. For example, users can query the index of key phrases to build the taxonomy for an organization, or for a corpus of technical documents. Or for example in an HR scenario, a recruiter can query the document similarity index to identify resumes that match a job description.

      Developers can easily enable Semantic Search using familiar Fulltext search syntax. They can then access Semantic Search results using the new Semantic Rowset functions (similar to CONTAINSTABLE and FREETEXTTABLE). Semantic Search follows all of the Fulltext index population models to work seamlessly in the existing Fulltext scenarios.
  • Supported Operating System

    Windows 7, Windows 8, Windows Server 2003 Service Pack 2, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Vista Service Pack 2

      1. The expanded database and log file require approximately 210 megabytes of disk space.
      2. The system should meet the requirements for SQL Server 2012.
    • 1. Install the semantic language statistics database.
      • Download the appropriate version of the Windows installer package named SemanticLanguageDatabase.msi from this page. This file contains a compressed database file and log file.
      • Run the SemanticLanguageDatabase.msi Windows installer package to extract the database and log file. You should change the default destination directory to a location where SQL Server has necessary file permissions for attaching a database (SQL Server data folder for example).
      • Optionally, you can move the extracted database file and log file to the preferred location in the file system.

      2. Attach the semantic language statistics database.
      • Attach the database to the instance of SQL Server by using Management Studio or by calling CREATE DATABASE with the FOR ATTACH syntax. For more information, see Detaching and Attaching Databases. By default, the name of the database is semanticsdb. You can optionally give the database a different name when you attach it. You have to provide this name when you register the database in the following step:

      • CREATE DATABASE semanticsdb
        ON (FILENAME = 'C:\Microsoft Semantic Language Database\semanticsdb.mdf')
        FOR ATTACH;


      When the semantic language statistics database is extracted, restricted permissions are assigned to the database file and log file in the file system. As a result, the user may not have permission to attach the database. If an error is raised when you try to attach the database, check and fix file system permissions as appropriate.

      3. Register the semantic language statistics database.
Site feedback

What category would you like to give web site feedback on?

Rate your level of satisfaction with this web page today: