How to drop tables from Sql Server db?

You can try the approach (SQL script) at the end of this post: Poor performance on Job table (high cpu)