I run the following query on a SQL 2008 R2 Server 2012 box with 4 processors and 20GB of ram the script max's out CPU usage to 100% and takes 15 minutes to run.
running the same script against the same data on a Virtual box with 8GB ram 1 processor takes 20 seconds to run and CPU usage never goes above 50%. This box is running SQL 2014 Express on a windows 7 machine.
This wasn't always a problem on the 2012 box either. Seems to has just started happening an no one know what changed.
Any ideas on more trouble shooting steps or changes we could try?