Skip to content
Aki Björklund

Aki Björklund

Posted on 2008-08-252009-01-10 by Aki Björklund

Controlling Transactions and Locks Part 5: SQL 2005 Snapshots

Olisinpa lukenut tämän kolme vuotta sitten, niin olisi jäänyt NOLOCKin kanssa kikkailu vähemmälle.

The new Read Committed and Snapshot Isolation levels give us greater control of SQL locking. This new control may lead to a performance increase for some read intensive databases.

www.databasejournal.com/… →

CategoriesPikaiset Tagshreflang:en, performance, scalability, SQL Server

Post navigation

Previous PostPrevious Coding Horror: Deadlocked!
Next PostNext Pitfalls to Avoid When Designing Forms

Follow @akibjorklund

© 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004 and 2003, Aki Björklund