只要使用with (nolock)即可！

SELECT au_lname FROM authors WITH (NOLOCK)