One of our developers wrote a query that seems to execute and never complete on one server. (Runs in about 20 minutes on another server). When run, I can not see any locking (sp_lock) or other issues under sp_who2. Profiler shows it starts but after a few hours has not ended. The Database tuning wizard indicates it could improve the query by only 3%.
Can you offer greater insight in what to look at next?
TIA,
barkingdog