Blog - Title

February, 2009

  • Conor vs. SQL

    Conor vs. MERGE and PRIMARY KEY collisions

    • 1 Comments
    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...
  • Conor vs. SQL

    Conor vs. Indexed View Updates

    • 1 Comments
    (as ANSI NULLs is one of the requirements for indexed views, I thought I’d give you some perspective on why the questions I ask you are useful and interesting to better understand queries and various query operations)   As currently designed, indexed...
  • Conor vs. SQL

    Conor vs. Non-ANSI NULLs, part 1

    • 1 Comments
    I was thinking about indexed views. Well, more specifically, I was thinking about why indexed views are hard to use. One of the reasons that they are hard is that there are just so many restrictions. Anyways, one of the things I'd like to better understand...
Page 1 of 1 (3 items)