With a rectangle ? Show on page 8, add a page break

Have a look at the (actual) query plan after the execution of the stored procedure to show what SQL is executed.

Brent Ozar is currently presenting a tuning week online (til...

Where did you find the variable declaration stuff?

If you have a baseline of workload before, you could compare it to baseline after.

Otherwise: user response?

Holy smoke.

I don't know for our company. We've got internal generators to make sure labtests are completed. Internet dependency has increased lately

Thanks for your solution

Working from home is plenty distracting. Beautiful weather, beer in the fridge, free choice of radio

You can use XE to capture filegrowths

https://www.brentozar.com/archive/2015/12/tracking-tempdb-growth-using-extended-events/

developer edition? Ain't free for production

Haven't tried openquery yet regarding batchsizes and character limits.

Anyway, the switch to ado.net solved the slowness problems for now until the switch to sql 2019

On your UAT server, restore the databases with the same compability.

You could try out https://spaghettidba.com/tag/workloadtools/ for capturing / replay the SQL on the UAT.

Saw a demo at dataminds connect. You...

Thanks for mentioning that Powershell 7 is out

Thanks frederico_fonseca and Jeff Moden for the extensive feedback.

I'm transfering 160 million rows of oracle 11g number (19,0) not null to sql server numeric(19,0) not null

Using SQL 2017 Enterprise +...

Awaiting SQL 2019 backup support, trying with the ado.net driver. Doesn't seem to go slower after a while

You can trace filegrowth with extended events https://www.sqlservercentral.com/blogs/finding-file-growths-with-extended-events