Why is SQL Server 2008 blocking SELECT?

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 5045

If you have problem with your SQL Server, like it locks table, or your select statement takes too long, or executes never, tham try something like:

 

ALTER DATABASE MyTableName
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE MyTableName
SET READ_COMMITTED_SNAPSHOT ON

Solution I found here, also you can read this article from Microsoft.