The focus of the article is on comparing documents that can be stored on Windows File System in one respect and in the other respect their comparative analysis that can be performed with Semantic Search in SQL Server.

Additionally, the readers will learn how to store unstructured data by exploring File Table and creating MS Word documents on the fly (instantly) to be consumed by Semantic Search.

This part of the article is related to the use of Semantic Search on unstructured data for the extraction of basic level business-crucial information provided standard naming is in place.

Prerequisites

The readers need to go through **Learn to Store and Analyse Documents on Windows File System with SQL Server Semantic Search Part 1 **to proceed further with it.

This article assumes the readers are familiar with most (if not all) of the following:

• File Table Concepts
• Semantic Search Concepts
• How to use SQL Server Semantic Search
• Basics of Full-Text Search

This article also assumes that following steps have already been completed.

• FILESTREAM Enabled Database EmployeesFilestreamSample has been set up.
• File Table has been set up.
• MS Word document **Asif Permanent Employee **and **Peter Permanent Employee **has been stored in a windows folder managed through File Table.
• Querying the database File Table shows the information about the stored documents.

Please refer to the article Learn to Store and Analyse Documents on Windows File System with SQL Server Semantic Search Part 1 to complete any of the above missing steps, which are mandatory to cover the walkthrough completely.

Performing Name-Based Documents Comparative Analysis

As we are preparing to perform documents comparative analysis based on their standard naming, at this point it is worth doing a quick check by querying the FILESTREAM Enabled database we set up in the first part of the article.

Run the following script against EmployeesFilestreamSample database:

-- View stored documents managed by File Table to check
SELECT stream_id
      ,[name]
      ,file_type
      ,creation_time
FROM EmployeesFilestreamSample.dbo.EmployeesDocumentStore

#sql server #full-text search #semantic search #sql server #sql server 2016