>>OK, admittedly I don't do a lot with full text searches, though I don't recall seeing text indexes on a column so small (just 30 characters). So if anyone who has done this often wants to jump in....
>
>Without full text index on that one, as they want to find a string anywhere in the field, I would have to use %Honda% syntax and that would time out pretty much all the time. This is why full text is required on that one for as long as they want to search within.
I have tables with more than four million rows and have used that syntax and haven't run into timeouts. Admittedly, I have a few procedures where I'll split it up into multiple queries, to limit the # of rows where the LIKE '%Value%' is used - but regardless, haven't run into timeout problems.