Querying Full-Text Data in Microsoft SQL Server 2012

Case Scenarios

In the following case scenarios, you apply what you’ve learned about querying full-text data and using a semantic search. You can find the answers to these questions in the Answers section at the end of this chapter.

Case Scenario 1: Enhancing the Searches

After you deploy a line-of-business (LOB) application to your customer, you realize it is not user friendly enough. End users have to perform many searches; however, they always have to know the exact phrase they are searching for.

1. How could you enhance the end users’ experience?

2. How should you change your queries to support the enhanced user interface?

Case Scenario 2: Using the Semantic Search

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.

1. Would you create a Microsoft .NET application or use T-SQL queries for this problem?

2. If you decide to use a T-SQL solution, which T-SQL function would you use?