Holy cow! Where have I been living?
You can use NOLOCK with SELECT statements to tell SQL to not lock the row/table/page/database.
Content
.NOLOCK tells sql to return data regardless of the lock status on the table or row, in other words it will return data before the commit, and could potentially return invalid data.
Scott ElkinHence the “90%”. : )
ASP asus eee AT&T blackberry bug chicken cookies Cooking dsl ebay eee eee pc firefox flickr flip video Gaming google reader gPG green gPC guitar hero IIS internet isp Javascript mike goldberg MMA naked dsl OLPC paypal pregnancy Programming recession recipe save money shipping sprint strike TV twitter UFC ups wga writer's strike writers guild Xbox 360
2 Responses
+
#