SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

...should come before that SELECT statement that is getting blocked due to locking. (credit to Nathan Carroll)