I have two tables that have millions of records.
I want to full text search a couple of columns on them (basically first and last names.) However, both of these tables essentially get wiped and replaced by a legacy DTS package over the weekend.
I had change tracking set to automatic and when said DTS ran, the table got locked up and all queries failed.
So, I would like to do this the right way. What settings or scheduling should I use for the FTS change tracking and population? Should I set change tracking to off, and then schedule a full population after the DTS imports run?
Also, what is the difference between "change tracking" and "population" and how are they related?
How can the index work if there is no change tracking?
Does full population add the indexes even if change tracking is off?