When we talk about deadlock, most of time we thought it’s caused by incorrect resource accessing. That’s correct. Then you dive into your application code and hopefully find a root cause in T-SQL. In some situation, the dead lock happens in a random manner. The place even you think that it’s impossible to get a deadlock gets deadlock. In this case, you need to check whether you are using pooled connection properly.
New Home
I really missed updating my dormant blog, http://sqlx.blogspot.com for long time. I can’t leave without it. Finally, I managed to setup my home on my own server. I will be writing my blog here. All my blog posts in http://sqlx.blogspot.com will be gradually moved to here. I am excited. Here is the picture from the celebration of my blog