May 24, 2013 at 3:32 am
“Alter Table XXXX Drop Constraint XXXX_PK With (Move To Part_Schm_Month_Wise(Date_Of_Entry)) “
The above query is taking over 24hr to execute. The table has about 65 million rows. Any Suggestion, how can I speed-up the process.
May 24, 2013 at 7:45 am
First of all, check if the statement is not spending most of it's time waiting for a lock on the table to be freed.
If i's not the case then BCP out then BCP in would most likely be quicker, on any other bulk copy.
May 24, 2013 at 1:53 pm
I check it on activity monitor and there are no lock on the table, but
task state is "suspended"
wait type: PAGEIOLATCH_SH
wait Resource: 6:1:5539691
Not sure keep it running for few more hours. suggest please
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply