Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Full-text question

Author  Topic  botsko Starting Member 1 Post Posted - 2009-07-28 : 09:49:03 I have a small database 60-80 tables with Full text indexes enabled on almost all of them (1-3 columns indexed per table). Database is new and almost empty. Through SQL Enterprise management I inserted a row using a query like: insert into table (column1) values ('value1') Than I'm trying to find the record with query like: SELECT column1 FROM table WHERE Contains ([table].[column1], N'"value1 *"') I need to wait 1:15-1:20 mins until the inserted record shows as a result of the select clause. Any chance that I can optimize full-text service or storage to retrieve my data immediately?