What is "with (nolock)" in SQL Server? What is "with (nolock)" in SQL Server? sql-server sql-server