bdloving 4446 (2/21/2013)
drop the indexestry a simple select top 10 * from table
rebuild the indexes
or
export, drop and rebuild the table
Don't do this! This is certainly not a first step, and probably not a last step.
Find out what the cause may be.
Can you add a WHERE clause, to filter a single row, and does it return then?
Do you have any open transactions that may be blocking?
Is there some sort of process running that you may not be aware of that can be causing deadlocks?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/