being VMWare I would speak with the team that maintains it and check config of new vm vs old - as well as server specs itself.

things to look at

• Memory...

similar hardware does not mean similar performance - so I would check those.

you say they are VM - details? onprem, cloud, vendor (AWS, MS, VMWare) - VM type if cloud

Disks...

substring vs like is only "better" if the like contains a wildcard at the start of the string.. e.g. like '%abc%'

on the case above both substring and like will do...

Somewhere I found that substring is not necessary, when you compare 2 values from tables, and one of the values has just 10 symbols, and the other has more...

one other thing that can cause differences is the timezone of the server and the time /day the job runs on the server.

you need both Oracle client and Microsoft Connector - but Microsoft Connector requires Enterprise edition - so if you have Standard you can't use it and you need to use...

can you also get the explain plan using the CASE method from Jeff Moden article?

curious to compare.

regarding the process - as I don't know Databricks I can't say if this...

plan doesn't attach on forums - you will need to use https://www.brentozar.com/pastetheplan/ and post link.

another question - is the output of that query being directly inserted into a...

`back to basics - what problem are you trying to solve?

is the query too slow? how long does it take and how often is it executed?

does it affect other queries...

and adding to this - parallelism waits are NOT bad per se - while it may be a pointer for you to look at the queries that go parallel, in...

thx frederico, not sure but i think our recovery simple choice addresses your point about logging mode.   and yes i've seen backups run in seconds on this 105 gig...

still possible to do...

...

i've concluded that the sales sub pkg runs only after its dimensions are done and that when a full load is requested all fact sales are explicitly deleted (one...

I would make it truly more generic (might as well).  Definitely avoid the use of INFORMATION_SCHEMA views, since they are not 100% reliable and often seem very slow.  I,...

try the latest code - and resolve was on your own original code and I kept it before. Gone on latest one.

it does work on my pc with both valid...