Probably not. The STRING_SPLIT function is relatively crippled for those...

those 2.5 mins are on your pc - how long does it take to run on the server?

and on top of what Jeffrey said - set the packet size to...

I do not understand why you having issues with the link you provided. It is quite clear.

SSIS Package (call it myfile.DTSX) - you create a connection manager to your database...

one possible way.

update a
    set rupdate = 1
output deleted.*
into table_b
from dbo.TABLe_A a
where convert(date,DTime) = CONVERT(date, getdate())
    and cast(DTime as time) >...

just wonder why people still insist in using cursors/while loops when a better solution was given.

for those seeing this thread and thinking its a good way to do- this approach...

using the ONLINE=ON is most likely what is killing the index creation.

but all other comments still valid.

from what I can see the output of that query will filter out the cases where either accountid or alternatecode is null - why are you stating it is not...

to load the full file without errors you basically define a table with a single column and you load the file onto it without specifying field delimiters - only record...

this may give you a hint https://www.mssqltips.com/sqlservertip/3456/getting-sql-server-metadata-with-python/

it would seem that one of your applications does like to get info about tables and its columns a lot - I've seen this...

this looks like code converted from Oracle - is your database/tables really setup to be case sensitive that you require to use UPPER for every single column?

there is a way...

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

although not a direct help on this you may wish to consider testing doing split file backups (not stripped) to see if performance improves.

sometimes it does sometimes it doesn't.

see https://www.sqlservercentral.com/forums/topic/creating-split-backups-question...

openquery uses a linkedserver name - that name DOES NOT need to be the physical server name although when you create it through the gui and you specify it as...

no one can really prepare for something like what we had this year - at least not without spending money that may not ever be needed just for a worst...

you need to shrink files, not database.

example - replace test with your database name on the use statement, and with the logical name of your datafile on the shrinkfile command.

the...

a simple outer apply would do.

single pass on the table and it is clearer than Pivot/unpivot (at least for me)

select CID
     , t.CustType
from...