@jeff,

Sorry for the late response. This table is partitioned by week and we are mostly just inserting into that specific weekly partition and aggregating the data which...

Jeff Moden (5/12/2014)

---

-A (5/7/2014)

---

Thanks for the replays.

--Here is the answers to the follow up questions:

1) I have to create this Index online since it is huge and I cannot afford...

hhh, sorry, I actually didn't see...

TheSQLGuru (5/7/2014)

---

3) I also wonder if it isn't the ONLINE part that is getting you, or at least having a play in the issue. Keeping track of stuff that...

TheSQLGuru (5/7/2014)

---

2) It could be that there are other massive tempdb consuming queries running at the same time. Were you monitoring tempdb usage during these 20 hours?? Big...

Thanks for the replays.

--Here is the answers to the follow up questions:

1) I have to create this Index online since it is huge and I cannot afford such a long...

Moved the question to SQL Server 2012 section:

http://www.sqlservercentral.com/Forums/Topic1568544-2799-1.aspx

<This thread can be deleted>

The lowest I have seen work would be dbcreator and securityadmin roles.

Good luck

-A

timothyawiseman>: no I am not passing it from a CSV. I am actually pulling it from my DB and when I run my SP it returns the data that...