I launched a million record bulk insert into an SQL Server database. This ran for 10-15 minutes before I killed it. The CPU is at 100% usage. Even after another 20 minutes, the CPU is still at 100% usage, and the system is unusable. I see two active jobs in the Enterprise Manager "Process Info" window, a "KILLED/ROLLBACK" job and a "CHECKPOINT" job.
I tried to stop the SQL Service and it won't stop.