Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly deletes). As you are aware the inserts operations will have to wait to update the table where the table is locked until the delete transaction is commited. Similarly you can run a TSQL to find out what kind of blocking and locking is occuring on the...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/07/2877.aspx