I'm running some of our stored procedures, written on 2005, on a test 2008 server
One of the stored procedures runs much slower on 2008, the execution plan is considerably different as well.
I've tried changing the compatability level, to no effect.
I'm wondering f there are any general actions I can take to mitigate this issue, or whether I'm just going to have to deal with these problems on a one by one basis.
View Complete Post