Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?
I'm having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...