I have nothing good to say about SQL Server 2022.  Any benefits have been outweighed by things like you describe and some seriously slow running code.  MS broke things starting...

This is the query with the plan (names have been changed):

DECLARE @DateColumn  DATE = '2024-07-01';

DELETE s 
FROM [Schema].TableName s 
INNER JOIN #WorkingTable q
ON q.Column1 =...

This won't tell you if a table is "empty" or not but it will tell you if it has been used by users since the last restart or not.  I...

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...