﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / Administering / SQL Server 2005  / Full Text Index Population / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Tue, 18 Jun 2013 19:12:17 GMT</lastBuildDate><ttl>20</ttl><item><title>Full Text Index Population</title><link>http://www.sqlservercentral.com/Forums/Topic490136-146-1.aspx</link><description>when creating a full text index, how long should the initial population take?  I created one Wednesday about 3:00 PM and it is still running.  Now, stored procs that usually take about one second to run are taking a little over a minute.  The table has about 33 million rows, has an id column (int) as PK, non-clusterd index on that column, and the full text index is on a varchar(28) column.  1. Should I let this process continue until it ends, or, should I stop the process?2. Do I also need to add a timestamped column to the table for future populations?</description><pubDate>Thu, 24 Apr 2008 11:12:38 GMT</pubDate><dc:creator>MichaelC-698876</dc:creator></item></channel></rss>