Archive for category Tips/Tricks

Detecting Long running/Blocking queries in SQL Server

There are times when SQL query blocks or delays operation in an environment and makes it very difficult to track them, there is a query mentioned on Brent’s Blog  that may help in Identifying long running blocking queries.

initially I mentioned query here along reference to Brent’s Blog, but on his suggestion I have modified the post.

, , ,

Leave a comment

IE7 First Time Run Tweak

open note pad copy the text below and paste it in notepad. then save the file as "RunOnce.reg" run it. your IE7 won’t go for runonce….. site instead it will stay at your homepage.
 
[HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main]
"RunOnceHasShown"=dword:00000001
"RunOnceComplete"=dword:00000001

Leave a comment