Technology                  :  SQL Server Full Text Search

Product                         :  SQL Server 2008R2

Level                              :  200-300

Target Audience           :  SQL Developers, SQL DBA’s and SQL Architects

Pre-Requisites              :  Basic knowledge of T-SQL

Abstract                         :  SQL Server Full Text Search helps you rapidly search in your databases – be it customer data or binary documents, case histories in legal repositories or matching job

                                           descriptions with stored resumes with support for more than 50 diverse languages.

Agenda:

- Overview of Full Text Search [FTS] 

- Full-Text Search Architecture

- Full-Text Indexing Overview

- Configuring Full-Text Linguistic Components including best practices

- Sample Searches [Demo]

- False Positives and False Negatives.

- Precision vs. Recall Tradeoff