• Tom.Thomson (4/7/2010)


    Paul White NZ (3/31/2010)


    CirquedeSQLeil (3/31/2010)


    Adam Machanic summarizes his testing here.

    In the comments, Adam notes that there seems to be no difference in SQL Server 2008...

    I think that's him expressing himself badly - the figues he gives for SQLS 2008 indicate that coalesce is now measurably faster than isnull.

    Did it? My memory was of mixed results. Can't actually be bothered to check again though 😀