Tag Archives: full text search

Full-Text Search – Stoplists in SQL Server

Posted on December 31, 2012 by way0utwest

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 way0utwest

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 way0utwest

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 , , | Comments Off on Searching Binary Data in SQL Server

Full Text Search – CONTAINS

Posted on September 27, 2012 by way0utwest

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