August 2004 - Posts

Whats he upto?

posted Monday, August 30, 2004 4:12 AM by sqldude

The wipro CEO Azim Premji wants the Techie taxed!!!
Read the whole story here .

with 6 Comments

SNAPSHOT Isolation

posted Tuesday, August 24, 2004 10:24 PM by sqldude
  Yukon introduces a new isolation level called SNAPSHOT which allows you to work in a mode where writers do not block readers, providing readers with a committed version of the data they request. SQL Server Yukon maintains a linked list in tempdb that tracks changes to rows and constructs an older, committed version of data for readers. This isolation is useful for optimistic locking, where UPDATE conflicts are not common. If Process 1 retrieves data and later attempts to modify it, and if Process 2 has modified the same data between the retrieval and modification, then SQL Server produces an error upon Process 1's modification attempt because of the conflict. Then, Process 1 can try to reissue the transaction. This mode can be efficient in situations where update conflicts are not common.
  In order to allow working in a SNAPSHOT isolation level, you must turn on the database option ALLOW_SNAPSHOT_ISOLATION.
with 6 Comments

YUKON

posted Tuesday, August 10, 2004 11:41 PM by sqldude

I have heard and read so much about Yukon now that I can't wait to get a peek of it...
so had a talk with the PM about using Yukon or having in touch with the latest softwares and stuff,
his reasoning though right, was using new softwares is a company decision blah blah blah...

So don't know when I'll be working on it,  but till that time comes I thought why not learn the new stuff and blog about it ;)

so watch this space.

 

with 3307 Comments