I have a database that was given to me by a coworker in the form of a .bak file. I restored it to a new db, and I have 1 table with about 63,000 rows. When I try a query like “SELECT TOP (1000) …” it spins forever – I let it go 5 minutes before I stopped it, and it had only returned a couple screenfuls of rows (less than 100).
What is wrong? I also tried UPDATE STATISTICS on the table, no change.
1