I describe a few different causes for a symptom you might describe as a "runaway" query in SQL Server.