CODEWITHSUNDEEP
sqlsql-server-2008full-text-search
Steve Wortham
Steve Wortham

Reputation: 22220

The best online resources for full-text searching in Microsoft SQL?

So I've learned the difference between FREETEXT, FREETEXTTABLE, CONTAINS, and CONTAINSTABLE. And I've created a pretty cool search engine that combines a full-text enabled search with a tagging system (with a little help from you guys).

But where have you gone to really learn about and master full-text searching and get the most out of it in real-world scenarios? I'm struggling now with things like database design with full-text indexing in mind, and writing efficient queries that reference multiple tables each with their own full-text-indexed columns.

Any good articles or tutorials you know of are welcome.

Upvotes: 1

Views: 237

Answers (2)

LukeH
LukeH

Reputation: 269368

You could start by going straight to the source (assuming that you haven't already).

Upvotes: 1

Aaron Alton
Aaron Alton

Reputation: 23226

Not an article or a tutorial, but if you're willing to spend a few bucks your single best source of information would be Pro Full-Text Search in SQL Server 2008 by Michael Coles and Hilary Cotter.

http://apress.com/book/view/9781430215943

Upvotes: 1

Related Questions