Posts Tagged with(nolock)

Using NOLOCK and READPAST table hints in SQL Server

Posted by Le Kevin in Database on June 12, 2008

I developed some complicated reports for my company lately, and the query can be slow up the 10 seconds. using with nolock or readpast really do the trick.

ex: reading only commited rows

select * from some table with(readpast)

src=http://articles.techrepublic.com.com/5100-10878_11-6185492.html

Share|

,

No Comments