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 3 years, 4 months ago by Jonathan AC Roberts.

.

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

I suspect that this reading was taken straight after you added more memory. You need to use the database to see if it will use all the memory. SQL Server...

I don't know, but I was thinking it could be...

An alternative way to do it:

REPLACE(TRANSLATE(email, '0123456789', REPLICATE(CHAR(1), 10)), CHAR(1), '')

Though you can disable the foreign keys, then truncate, then enable the...

Okay, this is VERY weird. My last post, when I hit submit, errored out with "Are you sure you want to do that?"

And when I hit submit again, it...