Full text and Semantic Search in SQL Server 2008 and 2012

Play Full text and Semantic Search in SQL Server 2008 and 2012
Sign in to queue

Description

This talk covers the architecture of SQL Server Full text search in SQL Server 2008 and some major improvements in SQL Server 2012. Though Full text search has been an optional component of SQL Server since SQL Server 7, it was re-architected in SQL Server 2008/2012 for best performance. It provides special components, indexes, and T-SQL functions that allow semantic queries and relevance ranking of unstructured data in addition to traditional T-SQL LIKE operations that implement string-based queries. SQL Server 2012 adds property-based searches and new word-proximity operators and also Semantic Search as an adjunct to FTS. Finally I’ll cover the new parsing and other DMVs that make FTS less of a “black-box” and assist troubleshooting in SQL Server 2008.

Tag:

Data

Day:

2

Level:

300

Code:

2297

Embed

Download

Right click to download this episode

The Discussion

Add Your 2 Cents