Thursday, October 13, 2011

Indexes causes deadlocks in SQL Server

Another common scenario for deadlock
If make a lot of indexes with same set of columns but sequence is different, can cause deadlocks between select/update query.
Carefully design indexes for a table, don’t let tuning advisor do it for you.


ASP.NET MVC - Html.Partial vs Html.RenderPartial

stream.js, a Javascript lib provides data structure for infinite number of elements