1

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.

Community
  • 1
  • 1
Steve Wortham
  • 21,740
  • 5
  • 68
  • 90

2 Answers2

1

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

Aaron Alton
  • 22,728
  • 6
  • 34
  • 32
  • 1
    You can also take a look at it on Google Books: http://books.google.com/books?id=wGwVkAt79bEC&lpg=PA1&ots=fujGc5fs59&dq=%22sql%20server%202008%22%20%22full%20text%20search%22&pg=PR2#v=onepage&q=&f=false – LukeH Oct 13 '09 at 13:18
  • Hilary Cotter is da man when it comes to sql full text search! – crosenblum Aug 05 '10 at 21:32
1

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

LukeH
  • 263,068
  • 57
  • 365
  • 409