just out of curiosity. is the log growing and stays 100% full? or does it grow and then space is released and it refills?

if it is the former then it...

I'm not kidding about the plan by the way - I picked the 2 main elements and set them to fit to screen

I haven't factored in the parallelism issue so far - but yes, a lot of the time "part" of the plan goes parallel, I was kinda thinking it might have ...

Jeffrey is correct in asking the largest table size

i'd also ask.. are you doing index rebuilds or index defrags... a rebuild will take the whole index and churn it up...

we didn't know that you didn't...

you will never find @p1 in your codebase.

easiest way to see it it to run a profiler trace from sal management studio and see the queries coming through - not...

that is what my IT director keeps telling me...

@p1 is generated by sql and your sql driver for prepared statements it's not in PHP

upgrade quickly, then you can use querystore and plan guides

I'm stretching here on this one (and i'll get shot down) - if it works on one server but not on another then it's either a database or server setting.

if...

I used to work for a cyber security and anti-virus company. a lot of the research team used to put black insulation tape on phone cameras (both sides) and laptop...

no...

is ti sql 2019? we've seen a few issues with functions not behaving as expected - not honouring order by... is it possible that this is another sql 2019 bug?

if...

Good DBA you should see the number of times an app on some estates breaks on the 13th of the month - usually not figured out until valentines day...

ALL nonclustered? so it's a heap? - I have no idea how SQL will handle 55 million rows with regard to page splits at that point

I'm afraid we have all...