please post actual explain plan of the problematic query as well as the full sql statement (and of any views/functions used by it)  so we can help.

use https://www.brentozar.com/pastetheplan/...

then you have a problem as this is never going to be a slow operation - a amount of downtime will always be required, how much is going to depend...

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

if the IP returned in both local PC and problem SSIS server are the same then the server is able to get the DNS entry for the target - on...

this likely a DNS issue - within the server where SSIS is running open a command line (RDP) or a xp_cmdshell, or even a custom SSIS package just for the...

all those are not available to use within functions of views - so only within batch SQL or within a SP - and with regards to 3 - yes the...

Attached is the SQL query plan.

There are two main queries.  The first uses a date parameter and the second doesn't.  The second query is much higher cost that the...

use PlanExplorer to scramble the names - https://www.solarwinds.com/free-tools/plan-explorer

that will replace any object name (db, table, column) with object1, object2 and so on - but it will leave intact...

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