Blog Post

Comments on Pro Full-Text Search in SQL 2008 by Michael Coles

,

Apress sent me a free review copy, so I took a quick look through it at lunch. I've used full text a few times and know the basics, but I'm far from being a power user. The first chapter seemed kind of dense, more about the internal process than I cared about, but the rest of the book looked good. From basic set up to administration to really good stuff like building a Google-ish interface to FTS, all looked good and reasonably easy to understand.

Learned a few things (and probably a lot more that I would learn if I gave it the time it deserved):

  • Polysemy - words and phrases that sound the same but mean different things depending on context/background. The example they gave was Tiny Tim.
  • Recommends that the unique index on your table be an integer, otherwise it has to create a mapping table internally. Strange, but good to know.

I think it's worth having if you're doing full text stuff.

Disclaimer: I know Michael from SQLServerCentral.com and the PASS Summit, so I'm mildly biased.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating