Viewing 3 posts - 1 through 3 (of 3 total)
I'd make sure you're doing an apples-to-apples comparison. Ensure the VM for dev has the same number of vCPU's, memory, etc assigned. Then ensure that the SQL server-level settings are...
September 18, 2017 at 7:47 am
#1959783
Here's a similar article by Aaron Bertrand with some good performance analysis: http://sqlblog.com/blogs/aaron_bertrand/archive/2012/01/26/the-fallacy-that-a-while-loop-isn-t-a-cursor.aspx
June 1, 2015 at 9:28 am
#1802036
April 30, 2015 at 5:06 am
#1794610