Skip to main content
Ben Nadel at InVision In Real Life (IRL) 2019 (Phoenix, AZ) with: Wissam Abirached
Ben Nadel at InVision In Real Life (IRL) 2019 (Phoenix, AZ) with: Wissam Abirached ( @imwiss )

Jeremy Holovacs

Member since Oct 8, 2010

Recent Blog Comments By Jeremy Holovacs

  • SQL COALESCE() Very Cool, But Slower Than ISNULL()

    Posted on Oct 8, 2010 at 4:35 PM

    COALESCE has 2 major advantages: 1) it is part of the ANSI 2000 standard which can make your sql more portable. This, however, is pointless to most people, as they usually work in exactly one environment. 2) you are not limited to two values. ISNULL, logically speaking, should perform better in mo... read more »