Hi there, we're executing the same stored procedure against identical databases on sql 2008r2 and 2012.
The sp contains a cursor and runs quickly (3 mins) on 2008r2, yet continues to run on 2012.
We've checked everything in terms of hardware, network, config and can't understand why.
We've looked at the execution plan and it it is different.
Is there any know issue with 2012 having issues with cursors?
Many thanks
P
- Moved by Tom PhillipsModerator 14 hours 33 minutes ago TSQL question