Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in


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 and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

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 and the PASS Summit, so I'm mildly biased.


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.