Please post the Actual Execution plan for the DELETE of just ONE row.  Attach the ACTUAL execution plan so we can take a look at it.  A graphic of the...

Before you mess with those things...

... try setting the following...

1. Make sure Compressed backups are enabled (UNLESS your database is encrypted https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-compression-sql-server ).
2. Set the "buffercount" to 17 as a...

Also, put the variable name in a QUOTENAME() function... just to be safe two ways.

@JasonO

Lordy.  My apologies.  I just noticed that the table you posted has no Clustered Index.

I have to assume that you're not rebuilding the HEAP with Ola's Code, correct?

Also, you said...

Older but definitive article...

https://www.sommarskog.se/query-plan-mysteries.html

TBH, I'd call MS Support on this one.

Heh... it sure does. Here's page 44 from that presentation.

Every time I use the term, I try to...

Thank you kindly for the encouraging words but the...

Hi we run 2019 standard.  one of our mfg locations requires somewhat precise start and end param times along with the start and end dates controlling how an ssrs...

I did?  I don't remember... I've gotten old enough where I think my harddrive is full and, every time I learn something new, either something else in...

I'm a little late to the party due to the repost. But I look forward to reading more on this topic. We had a really terrible EAV implementation, so...

14 YEARS ago,  my god!  Always makes me feel warm inside when then notification of such a blast from the past lands in my inbox.

Maybe its time not just...

I did?  I don't remember... I've gotten old enough where I think...

Holy shades of Herman and Mr. Peabody!  I always forget about the "Wayback" machine. Thank you for posting that link.

I probably wouldn't compete.  I'd probably teach.