Ok, I've made some progress on this problem. Apparently SQL Server is ignoring noise words in my phrase match.

For example, I ran this query :

SELECT *

FROM Content_Items ci

INNER JOIN...

Thanks for the help - I plan on trying this today. One question - what will performance be like? Would a fulltext query against an indexed view be...

First thing is that you want to avoid using auto grow on your transaction  logs.  Set a hard limit and have SQL report when it is within 10-15% hitting that...

Thanks for the advice, John.  One last concern -

New rows added to the table will not show up in a search until the full text index is rebuilt, correct?  How resource...

Thank you, John.  I will definitely be checking out those links.  So, tell me - is FTS as fast or faster than T-SQL LIKE, or are there situations when LIKE...

Thanks for the help, Ray.

As far as text vs. varchar - most of these fields will be constrained to less than 8k.  In fact, most are less than 1k.  I...

Thanks, guys.  I think I'm gonna go ahead and set it up to run as a task over the weekend. 

I'm currently in a situation where I'm trying to shrink a DB and it's taking a real long time.  This is sort of an extreme example - the DB size...