Access 2000, Access 2003, Access 2007 forms, Access 2007 functions, Access Database, Access Forms Database, Access Functions, Access reports, Binary data, CSV, Data structures, Database administration, Database Backup, Database connectivity, Database design, Database issues, Database management, Database migration, Database mirroring, Database servers, DB2 administration, DB2 Universal Database, DB2 Web Query, DBA, DELETE statement, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, Indexes, INSERT statement, IT careers, JDBC, JOIN statement, LOOP statement, Microsoft Access, Microsoft Access subforms, Microsoft Access tables, MySQL, MySQL Database, MySQL query, ODBC, QMF, Query optimization, SQL queries, Sybase, Timestamp, Triggers, UPDATE statement VIEW ALL TAGS
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...