July 2006 - Posts

• 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

• Relating unrelated rows

  A recurring question in the newsgroups is: “How do I output unrelated rows side by side?” I’ll use the AdventureWorks database as an example. Suppose that my manager wants a report listing, for each order, all products ordered and all reasons the customer Read More... Posted Friday, July 14, 2006 10:23 PM by Hugo Kornelis | 3 Comments Filed under: Performance, Tricks, T-SQL