Tag Archives: NOLOCK

A SQL Read with NOLOCK, Causes a ALTER Table DDL statement to be Blocked or to Fail

If you are using SQL table hint NOLOCK, you would expect that this hint would always be honoured. However when reading data from a table this will always cause a schema stability lock (Sch-s); even when the NOLOCK hint is … Continue reading

Posted in SQL 2008 R2, SQL 2016 | Tagged | Leave a comment