Updated statistics with FULLSCAN, but no improvement. My question is why the query taking more time while executing locally in SQL2K8 SSMS than executing remotely from SQL2K5 SSMS?