Browse by Tags

• Snapshot isolation: A threat for integrity? (Part 4)

  In the previous parts of this series, I have shown how SQL Server prevents violations of foreign key constraints by silently disabling snapshot isolation . I have also demonstrated how you can use the same technique inside your trigger code , to keep Read More... Posted Friday, September 15, 2006 8:58 PM by Hugo Kornelis | 5 Comments Filed under: Isolation, SQL Server 2005

• Snapshot isolation: A threat for integrity? (Part 3)

  Last month, I showed how snapshot integrity can really mess up your triggers , promised you a workaround, and then went on holiday. Some events in my life kept me from posting the promised workaround for longer than intended, so I hope that you haven’t Read More... Posted Friday, August 25, 2006 6:17 PM by Hugo Kornelis | 6 Comments Filed under: Isolation, SQL Server 2005

• Snapshot isolation: A threat for integrity? (Part 2)

  In the first part of this series , I showed how SQL Server 2005 prevents violation of foreign key constraints when using snapshot isolation by automatically and silently using a less concurrent isolation level. In this part, I’ll show how snapshot isolation Read More... Posted Wednesday, July 26, 2006 6:12 PM by Hugo Kornelis | 4 Comments Filed under: Isolation, SQL Server 2005

• Snapshot isolation: A threat for integrity? (Part 1)

  One of the great new features of SQL Server 2005 is the snapshot isolation level. But exactly how safe is that feature? Can you still guarantee your data integrity if you use snapshot isolation level? With most forms of data integrity, this is not an Read More... Posted Friday, July 21, 2006 8:40 PM by Hugo Kornelis | 10 Comments Filed under: Isolation, SQL Server 2005