Depending on things like fragmentation and fill factor, having a clustered index doesn't use any more disk space than not having one.  This is because a clustered index is nothing...

Take a look at this article.  There are several reasons why your statistics may not have updated.  May be auto update stats isn't turned on.  Maybe your table...

If you aren't using the while loop any more, what method are you using to delete in batches?  Is the whole thing running in an explicit transaction, by any chance?

This is a SQL Server forum and you're asking for a Powershell solution; allow me to propose a SQL solution instead.  Why not import each CSV file (using bcp, BULK...

Use aliases to keep your code readable.  The ambiguous column may (also) have come in your SELECT list, so make sure you alias all the columns in there as well.

Mike

You may wish to consider enabling it - more here.

John

Mike

Does the database already exist on the target server?  Do you have Instant File Initialization enabled?  It sounds as if it's spending 50 minutes creating and zeroing the...

You need to join to KeywordsColour on CarColour = KeywordNo, and to all the other lookup tables in a similar way.  Have a look at this if you're new...

Traces are deprecated - use Extended Events (XE) instead.  Set aside an afternoon to read all about them, then try to create an XE session to capture job activity.  Post...

As I suggested before, I don't think CXPACKET is the root cause.  What other wait types do you get for the same process?  Please run this while you're waiting (fruitlessly)...

Are there any synonyms in the database?

SELECT name, base_object_name
FROM sys.synonyms

John

At a guess, I'd say the application is converting the password to upper case, which wouldn't have mattered on SQL Server 2000 (depending on the server collation) but definitely does...