Using the Semantic Search :: SQL Server 2012
You need to analyze some Microsoft Word documents to find the documents that are semantically
similar to a document that you get from your manager. You need to provide a quick
and simple solution for this problem.
- Would you create a Microsoft .NET application or use T-SQL queries for this problem?
- If you decide to use a T-SQL solution, which T-SQL function would you use?
Answers
- A T-SQL solution is simpler in this scenario because the SQL Server Full-Text Search and
Semantic Search features support the functionality you need out of the box.
- You should use the SEMANTICSIMILARITYTABLE function.