Full-Text Index Incremental Population in Sql Server
If you want to perform an incremental population of a full-text index in Sql Server, you must have a column with the data type of timestamp in each table that you want to index. If you do not have a column of type timestamp, the incremental population will turn into a full population, which is much more resource intensive.