Compilation Time Issues in OLTP Applications When Upgrading to SQL 2005

I’ve helped a lot of people upgrade their SQL 2000 applications to SQL 2005.  While many of these upgrades go well, occasionally some applications have issues and the overall workload may perform more poorly after the upgrade.  One area where I’ve seen issues is with ad-hoc on-line transaction processing (OLTP) systems.  This class of application performs…

1