Simple SQL queries not finishing
For me this problem was caused by a database connection left open by Visual Studio paused in debug mode.  Stopping the debug process allowed the query to complete immediately.