SQL Server 2005's Snapshot Isolation

Thursday Dec 23rd 2004 by DatabaseJournal.com Staff

SQL Server 2005 is just around the corner. Are you looking to justify the upgrade to your management? Here is a great feature to include: Snapshot Isolation. Read Ravindra Okade's discussion to see what Snapshot Isolation is all about and to learn how to implement it.

[From informit]

Now that SQL Server 2005 is almost here, it is time for you to read up on and apply some of its new features to your databases. Many of the new features are pretty straightforward (synonyms, for example), but some are less so.

In this article, I'll explain the new Snapshot Isolation feature. It may not have the most obvious payoff, but implementing Snapshot Isolation on a suitable database has the potential to eliminate data contention and reduce deadlocks, lock contentions, and session waits.

The article continues at http://www.informit.com/articles/article.asp?p=357098

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved