Recently I had some problems with a query that took a very long time to execute, it took over 20 minutes to do 150 inserts, that's whopping 9-ish seconds per one insert. There was nothing I could see straight away that would shed any light to the problem. The code itself was very simple, just loop through a collection and do insert for each one.

After half a day of tearing my way through unknown land of wait stats, events and complex SQL I finally got my stats. Here is how. [More]

A short post showing a bit better way of displaying custom errors in MVC 3 when using unobtrusive AJAX and HandleError attribute. [More]