SQL Server 2005 Text Function

5 pts.
Tags:
SQL Server 2005
SQL Server performance
SQL Server Query
SQL Server Text Function
Hello I have used text-function of SQL server 2005. I have ran my codes on a table with 800,000 records to serach for some specific words ( a list of 3milion words) in that. it took about 4 hours to be executed. Now I have some part of that table ( 1/8 of that including 100,000 records). I am running the same queries on that but it is more than one day executing without any result!!!! It drived me confused for one week. I am wondering if you have some reason and suggustion? Thanks, Mona

Answer Wiki

Thanks. We'll let you know when a new response is added.

Which text function are you using to perform this lookup?

Some of them will not perform as you would expect. If you can post some sample code to the comments section below that would be very helpful.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following