The FTS Catalog

Starting with Full Text Search

Meeting business needs with SQL Server full-text search

With the full-text search features in SQL Server, along with several hybrid search methods for comprehensive table scanning, companies can better meet specific business needs.

Using full-text search for symbols in SQL Server

Here's how to use full-text search in SQL Server when querying exact SQL expressions that include symbols. Use these steps to search symbols in SQL with these steps.

Share Database Knowledge with Office and SQL Server

Longtime SQL Server expert Bill Wunder has written a very interesting article on how to share knowledge among IT staff using the tools you already have in your organization.

Full Text Search Noise Words and Thesaurus Configurations

I have heard that Full Text Search uses a noise words to eliminate meaningless words in searches. I have also heard that a thesaurus is used, but I am not exactly sure how. Can you provide some details related to how both of these technologies are used in Full Text Search? I am interested in more of a background on these specific Full Text Search technologies as well as where the files are located and how I can update them.

setting full text search using script

This script will help you to understand how to set & use full text search.

Can a deterministic computed column be full-text indexed...

When creating a full-text index on a BLOB...

In SQL Server 2005 Full-Text Search, you set...