Can you show me how to kill whomever is hogging my SQL Server?

Yes. This script will find the process that is burning the most IO and CPU time. The first column will contain a KILL ??? command. If you copy that value and paste it into a new query window and run it, it will kill the command with the highest CPU and IO time. Carefully! This will kill the process so your database may not like this but at least you will regain control of your system.

To effectively run this against a system that is being hogged, open a connection from a different machine (ie, not on the machine itself).