Could be that your datasource requires some startup-time. SQL Database with auto close option?

Frederico,

Do you have a sample script with oracle bulkcopy that I can use in SSIS?

Have you defined some grouping? That could cause it

Is the detail of the tablix ungrouped?

What if you use it within a new tablix?

I'm not so good with abstract requirements.

Do you have some sample data? And the desired output

You didn't limit sales to the lookback period in CTE1, why is dat?

Is it about...

The solutions on the internet talk mostly about a reinstallation of the kingswaysoftware. Have you contacted the vendor yet?

And  encrypt sensitive information (like you did with user key). Try it...

I have no experience with speed differences because of blocksize.

pageiolatch: you are retrieving data from storage subsystem

cxpacket: your query went parallel ( do you need this ?)

https://www.sqlskills.com/help/waits/pageiolatch_sh/

https://www.sqlskills.com/help/waits/cxpacket/

Quite frequently. 19.x fixed a slow startup on 18.x

@skeleton56

you could try to clone the xp to a vhd-file that can be mounted by hyper-v https://learn.microsoft.com/en-us/sysinternals/downloads/disk2vhd

for win 8.1, probably has to do with SMB v1 being disabled for...

As far as I know you can't really throttle linked servers

Thanks for the update, but our biml tools BIML Express Varigence doesn't seem to work wit VS 2022. Is BIML still actively developed. Is there an alternative for BIML Express...

• This reply was modified 1 year, 7 months ago by Jo Pattyn. Reason: tool used

Looks that SOS_SCHEDULER_YIELD is a benign wait. The cpu was fully utilized

What is the parallelism setting for this query?

If maxdop= 1  results in 1 vcpu /32 vcpu = 3% of...

You could try a powershell script to delete items older than x days

https://stackoverflow.com/questions/17829785/delete-files-older-than-15-days-using-powershell

Happy Christmas and joyous end of the year.

Be safe, sound, happy in 2024

Thanks for the challenge

it's called parameter sniffing https://blog.sqlauthority.com/2019/12/19/sql-server-parameter-sniffing-simplest-example/