We are trying to rebuild the table into a new blank table. It seems to have relieved the issue...

Ninja's_RGR'us (8/3/2011)

---

Before adding the index I'd like if you could run that script for that table and post the results back... I want to see if that script can...

I'm trying to run the script but it seems to take a long time (ran for 10 mins before i decided to...

Thanks...

tfifield (8/2/2011)

---

Chris,

I'm not sure if I have the sequence correct here, but it seems that in the test the data was loaded, then an index rebuild, then a drop and...

ChrisTaylor (8/2/2011)

---

this may sound a daft idea but have you tried reverting everything back to how it was? This way you can determine for sure whether it was actually your...

I don't think it is performing an ordered insert nor is there a clustered index performing a sort. The table is used a fact table in our data warehouse with...

Thanks for the suggestion Alex.

I've tried a few tests using the Disable/Rebuild method instead of Drop/Create and found some very different performances:

1st execution took 22 mins to rebuild a single...