Hi,

i am using your code to search word in sql server table.

I have one table candidates , i have lakhs of records in a Table.

...

Hi Mathew,

Thanks for you reply,

But one thing i am not undestanding below query, can you explain why the result id different?

select * from candidates WHERE contains(c_resume_text,'C++') -It shwoing c++ and...

Hi mathew,

thanks for your reply,

There are no joins in query, just a select statement.

I used with PatIndex it's taking so much time to find out the results.

Thanks,

Hi Mathew,

If i use like condition , it will take so much time to serach.That's why i used the Contains condtion to search.it gives with in fraction of seconds result.

If...

Thanks for your reply.

But i want when the user updating any fileds in the table , only those fileds i need to insert into another table.

So i can know only...

We are not running any job at that time, no sql job running.

But problem is occurring at that time.

So i am restarting the server.

Without restarting the server, what should i...

I didn't understand what license and connection limit problem. Can you explain in detail.

Thanks for your reply,

Sql Server DataBase is Slow it's means, when user Searches or Insert or updates in my web application it's taking too much time to do...