@TestContributions MONEY=NULL OUTPUT

you can find the value afterwards in @TestContributions

if you don't specify @TestContributions it will assume the default value NULL

Can you post the DDL of the tables so it...

No idea, have you tried auto adjust buffer size ? https://www.mssqltips.com/sqlservertip/4221/improving-data-flow-performance-with-ssis-autoadjustbuffersize-property/

I don't know of any official recommendation.

A practical reason could be that it is faster to relocate a 64 GB file than a 2TB one

There is an recommendation to have...

Apparently you are on service pack 2 https://sqlserverbuilds.blogspot.com/

Do you run it from commandline?

Alas, SQL Server's performance can suffer from encapsulating in UDF

https://www.brentozar.com/archive/2019/04/finding-froids-limits-testing-inlined-user-defined-functions/

https://www.mssqltips.com/sqlservertip/4689/understand-the-performance-behavior-of-sql-server-scalar-user-defined-functions/

Having a weird case today (still under investigation). Parallel clustered index scan slower dan serial index scan (forced by MAXDOP 1)

*edit* repartition streams spilled to tempdb 🙁 Repartition stream 1=0,2=5000000,3=0,4=5000000....

• This reply was modified 4 years, 6 months ago by Jo Pattyn.

It's really a talent. Some dumb questions are hidden gems. Why didn't we think of that before, does it still apply now ...

I haven't got problems when upgrading to 2019. It introduces adaptive joins which may be finicky in flip-flop scenarios (large & small dataset).

Thanks for the question. Learned about hash-indexes

Looks correct. Make sure you copy the permissions

Your query is too abstracted to give much information.

If it index seeks on object8 (alias) object name, there is an index on  Object 8 Column7, Column 8 (or the other...

There isn't really much that you can do.

Are you accessing the data with OPENQUERY ( you might pass some query hints) ?

Check the linked server provider options

Is it possible to...

some of your subqueries gives more than one results. This would break the one value per row

Check if

(SELECT RS.LIB_SERVICE FROM RESSOURCE_SERVICE RS WHERE RS.CLE_REF = RIS.CLE_REFAND RS.CODE_SERVICE...

In my environment the DBA's (small environment). Have sufficients rights and know more what the patches do. Networking team can focus on the other servers