• If you hit the issue again, I'd look for blocked processes. It's likely that you had one that was preventing your from completing what you were doing. You could have identified it pretty quickly. To look for those use sys.dm_exec_requests.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning