Restore from your last good backup.

Then you're going to have to use dynamic SQL.

Why drop and create a table to change a column name? Why not use sp_rename?

Consolas 10pt usually. 18-28pt if I'm presenting, depending on where.

Write latency on the log drive.

When you have the inserts as separate transactions (no user-defined transaction), each one has to flush the log to disk before it's complete. When you...

To bulk-logged recovery for loads and index rebuilds sometimes. To from full to simple and back,...

Run a CheckDB please?

DBCC CheckDB (<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

sysobjects and syscomments are deprecated (have been for 8 years), should not be used any longer.

Use sys.objects and sys.sql_modules.

Nothing at all unusual about column stats (stats that aren't associated with indexes). The naming's a little odd though.

What do each of these return?

DROP STATISTICS ABCTable._dta_index_ABCTable_c_7_745806881__K2

DROP STATISTICS ABCTable._dta_stat_745806881_2_1

DROP INDEX _dta_index_ABCTable_c_7_745806881__K2...

Are they stats (show up in sys.stats) or are they indexes (show up in sys.indexes)? What's the exact statement you're running and the exact error you're getting?

btw, if you drop...

One TempDB, multiple data files. You do not have multiple TempDB databases. All databases on that instance use the one sole TempDB database.

Are you using the trace flag to enable large pages?

An instance can only have a single TempDB, so any database on that instance will use that single TempDB database.

The only place I've worked at that wanted to do a credit check was the bank, and they did have a good reason. New company did background and education checks...

The logical reads you posted in the OP look quite low.

What about this query made you look at it?