This SQL is functionally equivalent and there is no UNION:

drop table if exists #t;

WITH cte_mas AS 
(
    SELECT *,
     ...

With a table of that size it might be better to look at partitioning the table.

I don't know the specific answer to your question but I have generally found it better to create a temp table or table variable (depending on size) and insert...

A half column; a column bisected longitudinally, or along its axis.

A low-relief, vertical pillar or pilaster in a wall, usually without a base or capital;...

I think you want IDENTITY not AUTO_INCREMENT

I would take all the queries out of the stored procedure and run them individually in SSMS with SET STATISTICS IO, TIME ON and also showing the execution plan. It should...

Whenever you do a left join a small table and a large table make sure that large table is defined first in the join query. In your case...

That's works only if the...

with cte as 
(
    SELECT CONVERT(bigint,  111100000001234566)  x
)
select x, convert(bigint,left(x,4) + right(x, 7))
  from cte

Does the DW process create temporary tables or is the tempdb usage just from sorts and joins?

How would the computer know that 'James' is the first name and 'Smith' is a last name?

You might be better just creating a script to delete the specific rows, then...

I don't think...

dtexec/ISServer "\SSISDB\Folder\Foldername\"Packagename" /Server "Servername" /ENVREFERENCE "Environmentname foldername"

Quotes look wrong, instead of \SSISDB\Folder\Foldername\"Packagename"

I think you'd want "\SSISDB\Folder\Foldername\Packagename"

Maybe you could create a calculated column and put the filter on that.

https://stackoverflow.com/questions/6733264/schema-binding-with-computed-column-function

• This reply was modified 4 years, 3 months ago by Jonathan AC Roberts.

.

• This reply was modified 4 years, 3 months ago by Jonathan AC Roberts.