Thanks for your reply. I used index tuning wizard, and when I selected the first trace workload file, it did not select the other rollover files automatically. So I had...

Hello,

You are deleting sleeping processes if the @loginame is in 'Active'. But what happens if I don't give any login name, which means @loginame would be null? Does the procedure...

Could you please elaborate more on how you spotted that fillfactors need to be changed and which portion of her code helped you to do it?

Thanks.

Thanks for your reply. So if a process is suspended, shouldn't there be something in blocked by column?