I have a long running query that behaves differently between two different machines.
I have an 8 core machine running Microsoft SQL Server Developer Edition (64-bit) that does not use parallelism and a 4 core machine running Microsoft SQL Server Enterprise Edition (64-bit) that does. I need the former to run in parallelism. I've adjusted all the available settings in the advanced options with no luck.
The 8 core machine runs the query in 1 hour 21 minutes. The other machine runs it in 2 seconds. Please help!