Sql-server – Can Oracle and SQL Server exist on the same server

Concurrency, locking and latches may play a part. I assume the production server is doing something other than wait for this particular query?

Is the memory policy set to auto? Perhaps the production server has allocated it's SGA pool differently.

It's also a question of what data is actually in in the shared pool and buffer cache. The test server may have more of the relevant data in the buffer, not being flushed out by other production queries.

Then there is hardware configuration. Something simple like write back cache could make a huge difference.

Fun as it is, lets not waste all our time on guesses. Trace the query with full timings and see what's really going on :)

In SQL Server Management Studio right-click your database and select Tasks / Generate Scripts. Follow the wizard and you'll get a script that recreates the data structure in the correct order according to foreign keys. On the wizard step titled "Set Scripting Options" choose "Advanced" and modify the "Types of data to script" option to "Schema and data"

TIP: In the final step select "Script to a New Query Window", it'll work much faster that way.