New York City – SQL Saturday #158

I am totally pumped up about having the opportunity to present at SQL Saturday #158 in New York City. It should be a good time to network with other professionals in the field and learn some new things about the product.

I will be posting an updated version of the presentation with TSQL code before the end of the week. I hope you have time to attend cool event on August 4th, 2012!


Full Text Indexing Basics


Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns?

Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan.

I will be introducing the brother’s grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index.

I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek.

Related posts

Leave a Comment