Are there disadvantages to using Full-Text Search in SQL Server? Are there disadvantages to using Full-Text Search in SQL Server? Is there much of an increased CPU or memory load on the server?
Read this: SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned.