If there are no log backups between the full and the time it crashed, then you, by definition, have all of them, since there are 0.
The full recovery requirement...

It'll make no difference whether you drop the indexes first then truncate the table or vis versa.

Depends. It's the same as for a DB without TDE.

The DB needs to have been in full recovery model, you must have all the log backups since the...

D:Logs is not a valid path. It should be D:\Logs. Check your setup and paths.

Your error message got mangled with a smilie. Can you either paste the whole thing again, or post a screenshot? Preferably both.

There's a difference between PAGEIOLATCH and PAGELATCH waits

The info you'd have seen about PFS page waits in tempDB are PAGELATCH waits, waits to access a page that's in...

Use a case statement to check whether bargain = 100 and only do the division if it's not.

I think you'll have to add a derived column to partition on, and, if you want performance improvements, your queries will have to filter on that derived column, not the...

The plan doesn't show anything useful.

How long does the update take?
Does it always take that long?

Is the query waiting for anything, and if so,...

No, that's not the issue.
Batch size is the number of rows that are loaded at a time. The problem that you have is that one or more of your...

Why are you partitioning the data?

Partitioning is mostly for data management, fast loading, fast deleting, index rebuilds at a partition level, compression at a partition level.
It does...