• I know this is nitpicking, but "change the database compatibility level to 110" is not really a correct answer. The question mentions upgrading, and the uograde process will not change the compatibility level. So the technically correct answer would be "don't do anything, and especially don't increase the compatibility level".


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/