Tag Archives: full text search

Missing Full Text Extensions in Express

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

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)

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

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

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

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

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

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

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