Hai Friends can anybody tell me what is ment by incremental population and fetch.Please share your knowledge with me. Thanks and Regards Charlie
Welcome to the forum! I believe that sounds like an interview question, have you referred through web in this regard? Incremental population varies in different sections of SQL Server, for instance within the fulltext indexing it only adjusts index entries for rows that have been added, deleted, or modified after the last population. Incremental population requests are implemented as full populations if any of the metadata for the table has changed since the last population. This includes altering any column, index, or full-text index definitions. Mostly I believe that will go with FULLTEXT Indexing.