Full Text Searching

Searching for data in a database is something we all do constantly, but few of us use the Full-Text Search features of SQL Server. Yousef Ekhtiari brings us a look at how you can get around some of the limitations of this feature and possibly use it in your application.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-07-24

6,014 reads

Discuss

Full Text Search Follies

by Robert Pearl

SQLServerCentral.com

Full Text Searching

Article

Are you considering upgrading from SQL Server 2000 to SQL Server 2005? Are you using Full-Text Search? One of the top SQL Server consultants in New York walks us through an interesting issue that you might want to consider before migrating your databases.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.59 (17)

You rated this post out of 5. Change rating

2008-01-18 (first published: 2007-03-08)

14,982 reads

Discuss

SQL Server Full Text Search Language Features, Part 2

by Additional Articles

Redgate

Full Text Searching

Article

This is the second of a two-part article that explores the language features of SQL Full-text Search (SQL FTS), an component of SQL Server 7 and above that allows fast and efficient querying of large amounts of unstructured textual data. Part I dealt with index time language options, covering how words or tokens are broken from the text stream emitted from the iFilters and stored in the index.

2006-07-14

2,945 reads

Discuss

"Almost" unique constraints

by Raymond-Kim

SQLServerCentral.com

Topic

Is there a way to allow only *one* multiple value in an otherwise-unique column? In other words, is there a provision to allow for "exceptions" to a unique constraint? For example, let's say I have a data column filled with the following rows: Table Chair Lamp I *do* want to allow multiple instances of "chair," […]