Changing Auto Shrink to False and Increasing the size worked for me to shrink files.

how to read the data from blocked process threhold report? I have enabled blocked process threshold in one of my server. Can someone tell me how to do it?

Even i get the result reflecting with new value before the commit tran is issued.

I had ran all the select & update with same SID.

Also, if th above...

The script is working fine. But the table is keep on updating without any new logon event occurs. Also, it is not working for add_role_member server event.

Any help in...

I just ran the sample script provided in the article. But i am not seeing the effect of row-versioning. I have enabled LLOW_SNAPSHOT_ISOLATION & READ_COMMITTED_SNAPSHOT also.

Do i need...

I just did the same way as roy suggested. I turned ON row-level versioning. But it was not working the way he said. Do i need to restart my instance...