MS SQL Server database transaction lock mechanism analysis