title: SQL Server SELECT statements causing blocking
body: <p>We're using a SQL Server 2005 database (no row versioning) with a huge select statement, and we're seeing it block other statements from running (seen using <code>sp_who2</code>).  I didn't realise SELECT statements could cause blocking - is there anything I can do to mitigate this?</p>