Assuming you run your query in SSMS, go to the Query menu and activate "Include Actual Execution Plan" item. Then run your query. Upon completion you'll see a new tab...

Is there an index on Title column? If not, create one and see if it helps. You may want to add OrderDateUtc to index too.

There was similar question recently, take a look:

https://www.sqlservercentral.com/forums/topic/job-duration-much-longer-than-step-durations

What is PI()  ? I don't see it in the list of math functions. I'm on 2008 thou, maybe it was added in 2016.

I think it's creating internal database snapshot to run checks against.

Duplicate post. See replies here:

https://www.sqlservercentral.com/forums/topic/efficient-way-to-split-a-string-2

Perhaps Microsoft guy meant reverting source database to the state it was when snapshot was taken? That's possible.

--To Revert a Database to a Database Snapshot:
RESTORE DATABASE {...

Great points guys, Thank You!

Look into STRING_SPLIT() function:

https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-2017

I think OP wants to make sure there won't be any incompatible code when level is changed.

The date does change or am I missing something?

DECLARE @Date DATETIME = '2019-07-19 22:42:45.880'
SELECT DATEADD(hh, 2, @Date)

Result:

2019-07-20 00:42:45.880

Why not simply use NEWID() function? Or you want date and time to be a part of the generated random number? I guess sample of the desired output will be...

Did you try to run DBCC FREEPROCCACHE before shrinking?

Also, check this: https://sqlsunday.com/2013/08/11/shrinking-tempdb-without-restarting-sql-server/

Also, this post may be helpful:

https://www.sqlconsulting.com/archives/big-performance-problems-with-the-cardinality-estimator/

I'm preparing to do similar thing, so just curious, did you run Data Migration Assistant before you did migration? And if so, did it...

If you present your data in more easily consumable way, more people will be willing to help.

CREATE TABLE #UserA(
  [User_name] VARCHAR(20), 
  User_country CHAR(2), 
...