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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!