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.
Solution:
Carefully design indexes for a table, don’t let tuning advisor do it for you.

Reference:




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

http://info.titodotnet.com/2011/10/aspnet-mvc-htmlpartial-vs.html

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

http://streamjs.org/