if you can risk gost data in your select statement then you could change the code to use NOLOCK
Select * from table WITH (NOLOCK)
there are certain risks involved (possible missing rows, or duplicate rows) but if you evaluate your environment and any actions you are going to drive from this data that you select, then you might consider it a worthwhile fix
evaluate and consider carefully before implementing this though.
MVDBA