Following is my query, it takes some time around 1 minute and some times gives a result in a second, problem occurred specially i execute query after some time ago, or put some new keyword in query.
I\'m using the SQL Full-Text Search and have a stored proceedure that uses the FREETEXTTABLE function.
MS SQL Server 2005: table1 has a full text index.I want to run multiple freetexttable searches开发者_如何学Python against it in a single query, but the two attempts i have fail.any help would be appre
I tried two different variations on the same thing.The first version selects from freetexttable, the other insets into a temp table and selects from that.I\'ve tried numerous variations on the first v