SQL - How to delete table content quickly

The deletion of table content may take significant amount of time when the number of rows is large. This is so because every singe row deletion is logged into the database transaction log.
In the cases that the deletion log is not important you can simply remove the data rows w/o logging any individual row deletion by truncating the table:



100% CPU usage by SQL Server - Look for Active (running) SQL queries

I found a very useful posts regarding analysis of currently running SQL queries and high SQL server load in Pinal Dave's blog.



Using these tricks the culprit of the high load can be easily indicated.

Until the problem resolution is implemented KILL [session_id] can stop the problematic query w/o server restart or long waiting.