Browse by Tags

Tagged Content List
  • Blog Post: Conor vs. Isolation Level Upgrade on UPDATE/DELETE Cascading RI

    A customer recently asked our support organization about an unexplained series of range locks that they were seeing on a DELETE to a table with a foreign key. Here is the repro:   1: create table Foo (FooId int not null primary key ) 2: create table Bar (FooId int not null , BarId int not null...
  • Blog Post: Conor vs. MERGE and PRIMARY KEY collisions

    MERGE is a new operation added in SQL Server 2008. It has all sorts of knobs, bells, and whistles. The primary value of this feature is to collapse multiple query statements into one query statement. Overall, this avoids the “overhead” necessary to run a query a few times and can be a big benefit, especially...
Page 1 of 1 (2 items)