So, any results yet? 

It is a senior permanent position.

Adrian Porter

We ran into the same problem. We did two things. First, we created jobs that would reindex the individual tables on different days instead of the entire database....

We recently purchased two NetApp filers. A 940 with 4 TB and a R100 with 12 TB. We purchased the 940 to consolidate some of our SQL Servers...

We tried removing the custid reference which did not make much of a difference. I ended up putting it into a Stored Procedure and it dropped off the charts....

This is an extremely interesting thread! Hopefully it is still being monitored. I have two questions for the group.

1.)

Let's say I have two production servers (SQLA,...

Nope, IX_CUSTID is only on Custid. I'll have the programmers remove the custid reference and see if that will help anything. I'll post the results on Monday.

Adrian Porter

Antares and Andy,

Here's the Execution Plan:

|--Clustered Index Update(OBJECT:([800Contacts].[dbo].[RX].[PK__RX__63D8CE75]), SET:([RX].[expired]=[Expr1004], [RX].[LAST_VISIT]=[Expr1005]))

|--Top(1)

...

Wow, the site co-owner! Some great personal service here! To answer your questions: First, we perform DBCC DBREINDEX twice a month, it was done...

Excellent article. I really enjoyed the examples that we can use as a template to base our own scripts according to the needs of our organization.

On a side note,...

Thanks everyone for your ideas and assistance. I left it overnight and it still stated that it was 'Loading'. Perfmon wasn't showing any activity on the CPU or...

It is a 33 GB database that I am restoring onto a Developmental server that has nothing else running on it. It's been going for about 3 hours on...