@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 updates some...

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...