To date, I'm the least impressed with BING AutoPilot and Claude 3.5 Sonnet.  I'm especially disappointed in Claude 3.5 Sonnet because it doesn't seem to provide references like the others...

Neither of those are an "Actual" execution plan.  They're both "Estimated".  While that's close, it misses certain nuances.  It does appear...

I know  you are after how to estimate X - that is not really a good way to go as there are way to many unknowns, and without looking...

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