Use of NOLOCK in SQL Server Database - SQL Server 2005, 2008, 2012, 2014

Intro: In case of OLTP systems, where the person making the recommendation wants to ‘improve’ the performance of the data base by reducing and removing the locks (that are held for SELECT queries),...

Read more ...