Recently, I restored a SQL 2008 DB as we are migrating to azure sql database.
Select top 50, column from Tablename with order by datefiled. If the table has total 48 rows then totally no problem for the same query.
But if i select top 100 then the query hangs for ever. But the same query works in the other server from where i backuped the db.It is also SQL 2008 version. Kindly help how do i solve the problem . I do not want to change the query.