Introduction to Full-Text Searching in SQL Server 2012. Adolfo J. Socorro, Ph.D. IT Impact, Inc. firstname.lastname@example.org. Outline. What can we do with FTS? How to install FTS FTS components Creating FTS indexes How to query with FTS FILESTREAM and FileTable. FTS Basics.
Adolfo J. Socorro, Ph.D.IT Impact, Inc.
FTS allows searching against character-based data
Available since at least SQL Server 2000
Very powerful if you log searches and learn what users are commonly searching for