Home Forums SQL Server 2008 SQL Server 2008 - General Performance of ISNULL or the AND/OR method in the WHERE clause RE: Performance of ISNULL or the AND/OR method in the WHERE clause

  • January 18, 2013 at 6:45 am

    #1578690

    1) Note this is an almost 2-year-old post.

    2) When you migrated to 2008, did you update ALL statistics with a FULL SCAN?? That is a MANDATORY step in the upgrade process that is often missed and leads to HORRIBLE performance!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service