SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


Posted by Steve Jones on 16 January 2009

I tech reviewed it and it was a great learning experience for me since I had to look most things up. iFTS changed substantially since we examined the late betas of 2005 as a possibility of implementing it on the site.

I think Michael has done a great job with this book.

Leave a Comment

Please register or log in to leave a comment.