Hi Leo,
Thanks for your reply and pointers. I had found this earlier and got to know that the Dumps are related to SSIS package execution. I am not pretty...

Thank you Perry

Hi Jack,

Thanks for your reply. percent_complete in sys.dm_exec_requests does not show for CREATE INDEX. The job got completed.

I took a different approach to monitor. I checked sp_helpindex to...

Go it..

Thanks Gail for clearing my doubt.

Thanks n regards,

Dev

Hi Gail,

My confusion is:

If both update and select are part of the same transaction. and update is having a X lock on the data rows, IX lock on the...

Thanks for your reply Ken.

What you said is fair enough. But if you can please look into the second topic from MSDN which I have mentioned. Please check the underlined...

Thanks a lot... it worked fine.