Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  SQL 2012

Author  Topic  eddiem Starting Member 1 Post Posted - 2012-04-17 : 10:06:45 When experimenting with SQL 2012, our application stopped working, due I'm told to SQL 2012 due SP being run asynchronously in multiple threads, this has the affect that the SP's can execute in a different order to the order in which they were submitted by the application. is this right? is there anyway we can use the additional performance from multithreading without having either re-write large amounts of our app, or turning asynchronous behaviour off It seems strange to me, because if the above is true, then won't migrating from SQL 2008 R2 to SQL 2012 break everyones app's by default?? I apologise if this is a dumb question, I don't know much about SQL server.