Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.

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 »