Is Query Performance different for different versions of SQL Server?

Posted by Ronak Mathia on Programmers See other posts from Programmers or by Ronak Mathia
Published on 2014-06-09T07:21:21Z Indexed on 2014/06/09 9:41 UTC
Read the original article Hit count: 280

Filed under:
|

I have fired 3 update queries in my stored procedure for 3 different tables. Each table contains almost 2,00,000 records and all records have to be updated. I am using indexing to speed up the performance. It quite working well with SQL Server 2008. stored procedure takes only 12 to 15 minutes to execute. (updates almost 1000 rows in 1 second in all three tables)

But when I run same scenario with SQL Server 2008 R2 then stored procedure takes more time to complete execution. its about 55 to 60 minutes. (updates almost 100 rows in 1 second in all three tables). I couldn't find any reason or solution for that.

I have also tested same scenario with SQL Server 2012. but result is same as above.

Please give suggestions.

© Programmers or respective owner

Related posts about sql

Related posts about sql-server