urgent - sql table does not work any more as i tshould
Hello,
I added a column to a table in sql 2014. After it I am only able to get limited number of rows when I select from it and it takes a long time.
Is there a way to fix the table. I appreciate your help - it is very urgent to fix this.
Greetings,
select top 1500 * from MyTable
If I search for 1540 top rows
select top 1540 * from MyTable it runs for 10 seconds before I stop it.
It returns 1500 rows right away but after that no more.
I have been using this table for a long time and never had a problem with it until now.