We have a DB [MYDB] in SQL2K5 box, we are migrating the DB to SQL2K8 box, hence restored the backup from 2K5 box to 2K8.
I have a question with following query
set statistics time on
SELECT TOP 1000 * FROM [MYDB].[my].[MY_TABLE]
set statistics time off
In 2K5 SSMS it takes around 3000 ms and in 2K8 SSMS it is taking 9000 ms.
Now if I execute the query from 2K5 SSMS for both the DB then execution in 2K8 DB is less than 3000 ms
and if I execute the query from 2K8 SSMS for both the DB then execution in 2K5 DB is more than 9000 ms
What could be the reason? Is there any feature I need to disable in SSMS 2K8?