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 sp_who2
). I didn't realise SELECT statements could cause blocking - is there anything I can do to mitigate this?