SQL Server Text Searching 7/8/14

Our next meeting of the vistual SQL Server Group will be on July 8 at 6:30 PM

Introduction to Full-Text Searching in SQL Server 2012

While most line-of-business applications store character-based data, many fail to take advantage of the powerful capabilities that SQL Server’s Full-Text Search (FTS) provides.  This technology allows for smart searching in text fields, including columns used to store documents, and is available in most editions of the product.  With FTS, you can leverage built-in prefix searching, inflectional searching (where “write” and “written”, for example, are considered the same), proximity searching (searching for words or phrases at a certain distance from each other), synonym replacement with a thesaurus, and result ranking with weighted terms.  Also, for files already stored in the file system, you may use FTS in combination with the FileTable feature to quickly index all of them without having to explicitly load them into the database.

In this introduction, we will provide examples of how to configure and use FTS so that you may begin to use this technology immediately in your SQL Server applications.



Adolfo J. Socorro is a Solutions Architect at IT Impact, Inc., and a seasoned software professional experienced in the design, development, and implementation of custom-software solutions for public and private organizations.  He has been a project leader for many successful and high-impact projects, which have included mobile and web technologies, database design, data analysis, business intelligence, data warehouses, reporting, and data integration.  Dr. Socorro holds a Ph.D. in Computer Science from the University of Oxford.

This is our regular monthly meeting link. Please discard any other links used in the past:

Join the meeting: https://join.me/accessusergroups

On a computer, use any browser with Flash. Nothing to download.
On a phone or tablet, launch the join.me app and enter meeting code: 842-599-774

Join the audio conference: 
Dial a phone number and enter access code, or connect via internet.

By phone: 
United States   +
Access Code   842-599-774#

Edit: The video for that meeting can be seen below.

Leave a Reply