Good to hear

thanks for that!

What happens to indexes when a database is restored from an old machine into a new machine?  Do they transfer over or do I have re-do them?

Definitely not for the first one.  Bump that up to at least 40:

EXEC sys.sp_configure 'cost...

Do you know how to get execution plans? Do you know how to interpret them?

You can generate an execution plan in SSMS if you click the "Include Actual Execution...

In SSMS, you can right click on the server & select properties, then select Memory. You should set memory to something lower than total server memory so that sufficient...

Statistics are what the query optimizer uses to choose an execution plan.They contain statistical information about the distribution of values. The Query Optimizer uses these statistics to estimate...

What edition of SQL Server? Hopefully not Express, as it can't take advantage of all that horsepower.

Compare actual execution plans.

You might try updating statistics on the new computer.

You have...

What edition of SQL Server? Hopefully not Express, as it can't take advantage of all that horsepower.

Compare actual execution plans.

You might try updating statistics on the new computer.

You have...

Yes

Both are running SS2019.  The version for SSMS is slighly different.

the values produced by both the queries look the same.

it is almost...

the old machine is running windows 10 pro and the new machine is running windows 11 pro

My guess - you got a bad download.  I would try re-downloading it and give it another shot.  Failing that, I would guess that something is blocking some downloads...

One thing I should mention...

I did a lot of development work on my old machine running Windows 10 Pro SS2019 and SSIS.  I am planning on moving that development to...

Thank you everyone who replied!

I know what the problem is.  I looked at the old Power Query script that worked before and in that I was replacing empty cells with...

I think the following error line from those that you provided is the key hint as to what is wrong...

Error 0xc02020c5: Data Flow Task 1: Data conversion failed while...

At first I thought the problem was with the PowerShell-produced file because I was importing that file.  Then it occurred to me to try the one from the government site. ...