update will take longer but none are fast - see https://www.sqlservercentral.com/steps/stairway-to-columnstore-indexes-level-6-updating-and-deleting-data-in-a-columnstore-index

both will require index reorg to get ride of the "deleted rows" from the table.

for large etl like this one...

following up on Phil answer - go and read these 2 links.

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

https://www.sqlservercentral.com/articles/how-to-post-performance-problems-1

and as an IRL example of what Phil is asking for - you Can't build a car if the...

would be good if you could supply the full code of all required functions - as well as part of what the invocation of it is - even the invocation...

code above formatted in case anyone interested in seeing what it it

with failedjobs
as
(select serverproperty('Servername') as ServerName
      , sysjobhist.job_id
    ...

thanks for feedback.

as that does not seem to work I now ask if the calling of the main function

SELECT * FROM

dbo.fn_GetMatchingItemsForGlobalSearchSOC('111889,111891,111899','12181', 3)

can be change so that the...

insert into a temp table , then select from temp table and insert into final, and on this select you add your required date column

you are missing the definition of "fn_GetFullTextSearchConditionFromUserInput"

looks like this function is called upon input from user - not based on joins to other tables, but straight as you have on...

• This reply was modified 3 years, 2 months ago by frederico_fonseca.
• This reply was modified 3 years, 2 months ago by frederico_fonseca.

if you use SSIS Catalog then you can specify permission at a project level and at a folder level.

see https://learn.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog?view=sql-server-ver16#Permissions

other permissions can be set at ssisdb level but those would...

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

did you try and change it from TVF to ITVF? that can make a significant difference to most queries.

even if you don't wish to put the whole code it may...

you need to have the order by on the Dataflow Source sql - not where you insert into the table as per above.

when generating csv files in SSIS (which I avoid every time I can - powershell easier for it) I normally do the conversion/formatting on the extract sql so that for...

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

see if this link helps you https://stackoverflow.com/questions/57278013/using-javascriptserializer-to-deserialize-json-c-sharp-type-not-supported-for

what errors you getting? and did you try debugging the code in case the error you get does not reflect the true error?

answer in my opinion is incorrect (or question badly formed) - see https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2022?view=sql-server-ver16, Migrate to SQL Server 2022 (16.x).

one thing is the "from" the other is the "after"

just to be sure you are indeed producing a Valid CSV

when you define your output file do you have the "text qualifier" set to " (double quote)?

on example below it...