can you give us the actual explain plan with both the 3 conditions and just 1 condition - as well as the definition of the view.

likely this is joining multiple...

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

dup post

• This reply was modified 1 years, 4 months ago by frederico_fonseca.

replace your code with

if ([string]::IsNullOrEmpty($OrgID) -eq $true)
        {
          write-host "Null found"
...

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

you said

Schema.TableName is partitioned by date.  There are typically 30 million rows per date partition.

#WorkingTable contains 500k records. We receive a continual set of records throughout the day (60 million...

as I said above you don't necessarily need a tool to generate data - it all depends on what your production data is and what can be copied down without...

likely the standard method of inserting into a new table with the column being calculated at that stage, and then one of 2 options

1 - truncate source table (remove any...

did you try this?

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @tableName = QUOTENAME(@tableName);
    -- SET @paramDefinition = N'@tblName NVARCHAR(255)'; -- not needed for...

• This reply was modified 1 years, 4 months ago by frederico_fonseca.

as that table is partitioned, and depending on the volume you are deleting, it may be faster to switch out the partition of that date to a staging table, and...

Personally I approach these type of changes by first identifying which executions take the longest, then which queries within that take the longest looking through their ACTUAL explain plan and...

with a few exceptions Production data can easily be manipulated to remove/scramble any PII or similar data at which time none of it can be used if it is leaked...

Without a tool what are the options.

We have atleast 200+ instances and I would like a report which states whether the windows box is pingable, if the sqlinstance is...

do them on a per table basis if deemed needed -...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3