Post reply

Compatibility level 90 vs 80 - is there a performance gain at level 90?

  • December 10, 2007 at 9:47 am

    #758646

    compatibility level does *NOT* introduces performance gain/losses basically compatibility "issues" or lack of them 😀


    * Noel

  • December 10, 2007 at 9:55 am

    #758653

    The compatibility level of 80, was from SQL 2000, 90 is 2005. Features introduced with SQL Server 2005 probably wont work, I assume this based on trying customised reports and trying to use pivot in a query, neither of these work unless the compatibility level is altered to 90. From this I expect none of the 2005 introduced features will work, but if the database doesn't need them you don't need to worry.

    I don't know of any performance gains I expect you'd have to test that.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply