Tag Archives: full text search

Missing Full Text Extensions in Express

Posted on February 23, 2015 by

I was tasked recently with removing the full text indexes in Adventureworks for a demo. The full text indexes were causing a few extra items to appear in a SQL Compare demo and weren’t needed. The individual that had set … Continue reading →

Posted in Blog | Tagged , ,

DevConnections Slides and Code

Posted on October 3, 2013 by

I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of other events, but a good time. I presented two sessions and both went well. I had some good questions from … Continue reading →

Posted in Blog | Tagged , , , ,

Encryption and Full Text Search at The Mandalay Bay (DevConnections)

Posted on September 23, 2013 by

It’s just a week until Dev Connections.  This is one of the great conferences for the hybrid technology person, with a variety of technologies being talked about, all for a single admission price. I’ll be speaking at SQL Server Connections, … Continue reading →

Posted in Blog | Tagged , , , , ,

Full-Text Search – Thesaurus

Posted on January 21, 2013 by

I would hope that most of us have used a thesaurus at some point in our careers. These allow us to substitute words for one another, providing for richer and more interesting communication. Full-text search in SQL Server includes a … Continue reading →

Posted in Blog | Tagged , ,

Full-Text Search – Word Breakers and Stemmers

Posted on January 14, 2013 by

There are numerous components to the Full-Text Search (FTS) subsystem in SQL Server that help provide efficient, relative answers to queries. Full-text Search is a little complex, and as I’ve been working with the system in an effort to learn … Continue reading →

Posted in Blog | Tagged , ,

Full-Text Search – Stoplists in SQL Server

Posted on December 31, 2012 by

Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text formats stored in SQL Server. This is a one of a series of posts that looks at different facets of … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

Building a Full Text Index

Posted on December 19, 2012 by

I hadn’t used full-text indexing in production throughout my career. We hadn’t had the need in the applications I worked on, all of them depending on LIKE searches in specific, normalized data. However I have always been interested in it … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Searching Binary Data in SQL Server

Posted on November 1, 2012 by

More and more data collected in organizations is in an encoded format, essentially a binary classification of data. These can be images, audio files, video, or even common formats like Word and Excel files. This data contains lots of important … Continue reading →

Posted in Presentations | Tagged , ,

Full Text Search – CONTAINS

Posted on September 27, 2012 by

I’ve been working on a new presentation for full text search and brushing up on some of my T-SQL operators. Part of my talk goes into the CONTAINS operator, which is one of the full text search keywords you need … Continue reading →

Posted in Blog | Tagged , , | 3 Comments