We migrated our database from 2000 to 2005 not too long ago. The only problem now is converting it from Mode 80 to Mode 90. We have several hundred stored procedures that use *= joins (never should have been used, but its too late to complain now) and it would require a large amount of time to convert them all so that they can run in Mode 90.
I am investigating the merits of using Mode 90 over Mode 80, and need to determine if its even worth the time investment to do so.
So my question is, What differences in terms of performance and functionality are there between SQL Server 2005 Mode 80 and Mode 90?
Any links to articles or forums that discuss this topic would also be appreciated.
hmm, Were you able to use the Database Diagrams while in mode 80? I migrated several dbs from 2000 to 2005 and the only way I could get the diagrams to work was by changing the compatibility level to 90.
If anyone found a way around this, I would like to know how they did so...