We narrowed it down to the IO characteristics of Managed Instances.

Seems for our load test file, we need to increase the log from 1GB to 576GB to reach the level...

Would also look at your IO patterns and see what you need, as putting everything on one VM, you're going to be limited A LOT by Azure's forced QoS policies...

Any CDC performance experts in the house, additional beneficial if you have tweaked it on a managed instance, seeing around a 30% performance decrease with CDC being enabled on the...

that meant for a different post Jo?

net start MSSQLSERVER /f /mSQLCMD


sqlcmd.exe -E -Q "CREATE LOGIN [DOMAIN\fped] FROM WINDOWS; ALTER SERVER ROLE sysadmin ADD MEMBER [DOMAIN\fped]; "

This should work for you.

Disable anything and everything,...

Exactly what Jasona mentioned.

It all depends how you have set the backup preferences, by default it should be Geo replicated to the associated region

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/automated-backups-overview?view=azuresql

However if someone has gone and changed...

Do all your interim tables have some sort of static prefix or suffix that differentiates them from a regular table?

If so you could write a script to pull out the...

Do all your interim tables have some sort of static prefix or suffix that differentiates them from a regular table?

If so you could write a script to pull out the...

Nice detailed article but for a wider topic and coming from CSS with customers complaining of issues.

Use merge with caution, there’s a number of bugs open with MSFT on merge...

https://www.reddit.com/r/SQLServer/comments/1kcd1wq/may_1st_issues/?rdt=38213

Yep looks like it was a defender thing, lots of people complaining of the same

https://github.com/drumsta/sql-generate-insert

This should help

When you alias a table in an update, you don't update the table you update the alias

You simply just needed to do

UPDATE T1

Instead of

UPDATE #TEMP1

DROP TABLE IF...

minutes, hours, days, weeks, depends how much data on the right of the file it has to move to the left and how fast your storage IO subsystem can move...

Well everything needs space, all the data you have been loading, deleting, changing, indexes added / deleted it will have all taken space.  When you drop that index which took...

What type of client is in use?  Is it some fat client or is it some sort of web based SaaS app you have.

Done something with SSRS in the past...