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  Transact-SQL (2005)  Search on long string fields

Author  Topic  fafche Starting Member 6 Posts Posted - 2009-12-14 : 09:31:33 Hello all , I would like to know how can i preform a search on a very big table (2 million records or more...) on a big nvarchar field in each record. I am using the full text search mchanism but my queries are still very slow. Help please :-)