Monthly Archives: April 2011

T-SQL – Avoid deadlock and workaround in SQL Server

>Here are some tips on how to avoid deadlocking on your SQL Server: Ensure the database design is properly normalized. Have the application access server objects in the same order each time. During transactions, don’t allow any user input. Collect … Continue reading

Posted in database | Leave a comment