This is SQL 2014.
I have a table with 3,000,000 rows something. It has lots of columns and we're thinking about using this flat file as our search table.
Can I have Full Text Search applied to this table only and not affect the rest of the database? My manager says something about FTS is not portable and will be a hassle to port to production database.
We do wildcard search on 6 of the columns