Full text and Semantic Search in SQL Server 2008 and 2012
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.