FYI, I'm blogging most of my stuff over at More Wally now.
You might want to add my rss feed to your reader at:http://morewally.com/cs/blogs/wallym/rss.aspx
Full-Text Index Incremental Population in Sql Server - Wallace B. McClure

Wallace B. McClure

All About Wally McClure - The musings of Wallym on .NET, Sql, ASP.NET, and other crazy shenanigans

News

Personal Blog

Work Blog

.NET

Book Authors

Business

Family

Friends

Georgia Tech Bloggers

Personal

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.

Wally

Posted: Jan 11 2005, 01:29 PM by Wallym | with 1 comment(s)
Filed under: , ,

Comments

John Kane said:

This is also true in SQL Server 7.0 and SQL Server 2000, it just wasn't documented. Although, an Incremental Population is no more intensive as a Full Population and in 7.0 & 2000 the latter can take as long to complete as the former, even with no change.

John
# January 11, 2005 8:54 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)