Check machine's regional setting in control panel.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=132114#bm132239

sp_who2 active will tell you whether your dbcc indexdefrag is blocked when user access your database with ACCESS.

And sp_lock will give you which table is being locked and what type...

Can you run same sp from QA in the server machine instead from your workstation?

"Cumulative wait time on server replies 108062 36020.7"

Where is above information from?

"The TRUNCATE TABLE statement is a fast, nonlogged method of deleting all rows in a table. It is almost always faster than a DELETE statement with no conditions because DELETE...

Go more details by clicking "show step details".

If job is created by maintenance plan, trun on the reporting by check "write report to text file" in reporting tab.

How many records the query return? Turn on statistics IO and statistics time in QA and post back the execution result.

And try "set nocount on" before executingg the sp.

"suddenly its jumped from 30 second runtime to over 3 or 4 minutes. "

"Duration 2155 

CPU 2275 

Reads 3388 

Writes 33"

I am confused.

Define unique constraint at columns custno and date.

alter table DailyWork add constraint DailyWork_custno_date unique (custno, date)

What is the total duration time, cpu and read time for entire sp?

Since both instances run in same node and 1GB reserved for OS, The max memory can be used by both SQL Server instances is 2GB in your configuration.

Separating two...

Increasing locks will increase the amount of memory SQL Server uses. You can try that.

You may decrase file size little by little each time to see what is going to happen.

Who is the job owner?

You shouldn't downgrade MDAC to lower version since MDAC 2.8 is the component of Windows 2003 and widely used by system.

The basic algorithm for auto update statistics is:

• If the row for a table is less than six and the table...