What does WITH (NOLOCK) actually mean
Contrary to popular belief WITH (NOLOCK) isn’t actually the SQL Server “Turbo” button. While it may appear that way, there’s actually some stuff going on in the back that makes it look this way. Understanding what is happening is critical to using WITH (NOLOCK) correctly. When you use the NOLOCK query hint you are telling […]