use a cte to select from your temp table, but add ROW_NUMBER as new sort id
then select from the cte

I'd imagine it's to do with the length of your DT_STR conversion.
I believe the string format needs to match the data type you want to convert to?
10 characters gives...

what version of SSIS/SSDT would you be using?
The reason I ask is that at some point (I can't remember which version) MS added an Excel Data Source connector in...

I'm not entirely clear on what you are trying to do?
Is 1,766.39 a variable?

Assuming it is a variable being passed in, and you have access to the...

poor choice of words... what I perhaps should have said was sequential, although I realise strings are sequential in an index!
I was trying to illustrate that, as an int 2 will...

try filtering in a WHERE not in the join?
also, check for implicit conversion?

ChrisM@Work + 1 for SARGable!

Sometimes you need to draw a line in the sand and accept that it may be better to start again.
Ask yourself 2 things:
1) if you came back to...

Looking at tempdb usage is the right place to start.
3 tempdb files that size, I presume you have a lot of data? One thought, perhaps you have an index...

when you upgraded, did you update stats, refresh views etc.?
There is a handy post about what to do after an upgrade:
https://thomaslarock-com.cdn.ampproject.org/c/s/thomaslarock.com/2017/04/upgrading-sql-server-2016-post-upgrade-tasks/amp/

If you want to look...

do you have auto-growth enabled?
if so, have you checked the auto-growth values for the files?
100gb is an awfully round number, you could have something misconfigured here?
start simple...

there are plenty of scripts online that can help automate your restore process. e.g.:
https://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/

Also, as has already been said, if you can take a full backup each...

there's a question here in that is this causing a performance problem, or are you just worried about scans vs. seeks?

you look as though you may be missing...

I realise I am late to the game here, but one thing I tend to try to adhere to is not using the PRIMARY filegroup for user defined tables.
whilst...

scans aren't always a bad option. It's a myth that seeks are always better than scans.
also, I believe there is a "threshold" in terms of number of rows, below which...

the fill factor leans more towards internal fragmentation, or page fullness.
as already mentioned, it's the page splits you want to watch out for (external fragmentation), as this process is resource...