Hi all,
We have a Full Text Search setup on one of the tables in the SQL Server 2005 database.
It works fine for most of the cases, returns results in a matter of a second. But every once in a while, it times out in our application when searching for certain words. Does anyone know why some words take longer to search for than others?
For instance, searching for a string "Mike" takes 4 times as long than searching for "Jack".
Any ideas?
Regards
Narine