I am doing a single pk index rebuild on a 100 gig table. After running sp_who2, I see that the rebuild in suspended state. Over a period of time, I have noticed that neither disk io nor cpu io is changing. Is there a way for me to
cancel it? Is it frozen forever?
Any help is appreciated
View Complete Post