Table Issue - simple queries will not run
Posted on 2006-05-19
Recently, delete and count queries against a table in my database will not finish.
Facts about the table:
1) There are only 57,000 records in it. (i ran sp_spaceused because i killed my SELECT COUNT(*) after it was running for 30 minutes)
2) There is an index on the RowID field
When I run either a count, select into, or delete against the table, it will run and run.. and not finish.
Upon advice, I ran an sp_who2 against my spid and under the blkby column is a -2
Any ideas would be greatly appreciated. I think this question is rather difficult! :)