PE, PEO and SQL 2005 compatibility
One of the features of PEO 3.2.5+ and PE 3.240+ is the ability to run on SQL 2005 natively. If you are relatively new to PE/PEO and are creating a new database in SQL 2005, it will automatically be in 2005 mode (also called compatibility level 90). But if you have upgraded an existing SQL server instance to 2005 while already using PE or PEO, you should note that SQL Server will not automatically convert databases to 2005 mode.
To update the database, just follow these simple steps:
- Open SQL Management Studio and connect to your SQL Server instance
- Locate your PE or PEO database, right-click and select Properties
- On the Options tab, set the compatibility level to 90 and click OK
I’ve done a fair amount of research and it looks like 2005 has some speed increases over 2000 in certain situations; however it is disputed whether or not 2005 gives significantly better performance across the board. In any case it does allow you to take advantage of some of the new features of 2005, such as improved reporting services. Personally, I love being able to have Enterprise Manager, Query Analyzer and Profiler accessible all in the same application.
Is your organization updating from SQL 2000 to 2005 in the near future or have you done so recently? What is your advice to others who are thinking about investing in an upgrade? Leave a note in the comments.