Hi DavidB,

I have been trying to be proactive since your last word of advice and i picked up 2 more procedures that were giving a problem. These i managed to...

I tried out the script when the server was busy and identified one culprit query. Since fixing it, we have not had a problem.

Thanks very much. I will use...

Thanks very much. i will try this out during the course of tomorrow to see whats going on. Will keep you updated.

Thanks for all the replies. They really help. Will monitor things before making the decision to partition, if need be.

Hi,

Sorry for the late response. Yes, i mean partitioning. Say you have a transaction table with 80 million rows and you want to partiotion it into 6 tables. How do...

It was installed and was running from that server. I run packages every month.

Hi,

I think i found what the problem is.There was a table with not all the necessary indexes on it. As a result, the execution plans of the procs that use...

I made the NOCOUNT change, restarted the server because machines were still slow. %disk time on the server was rocketing before the shutdown. Users went back on and they did...

Hi,

I have been using the code attached for 2 days now. It seemed like things were ok up until this afternoon. Users got the error message below:

The following error has...

Hi,

Please find the attached tables.

Thanks

Tendayi

Hi,

Users can enter a full accountid, idnumber, etc and retieve an account but they can also do partial searches where they put in a string say on the account number...

Hi,

Please find attached the modified code.

Thanks

Tendayi

Sorry, forgot to attach the file.

Hi,

I tested the modified procedure and it is better than the one i posted on the site. Thank you very much. I came across something this morning that i would...

Hi,

I ran the procedure which you sent. It showed me a number of queries that had been run, their start time but with no end time. I also picked up...