I've reindexed the database and used the WITH (NOLOCK) command (forgot about that one).  Seems a little better now.

Thanks for the replies.