if both use the same ERP system maybe the vendor has a tool that will "merge" both into a single instance - have you contacted them about it?

And not all...

what have you googled and what have you found out that you didn't understand?

plenty of info out there and we are not here to do the search for you.

and out of curiosity why are you still using something that requires you to connect to Integration Services? in 2016 you should be using SSIS Catalog which does not require...

https://www.ibm.com/support/pages/informix-client-software-development-kit-client-sdk-and-informix-connect-system-requirements?mhsrc=ibmsearch_a&mhq=informix%20client%20sdk

but I think you need a login - possibly under the contract your company has for Informix

or you may be able to use a third party driver - possibly https://www.progress.com/odbc/ibm-informix

you need to understand how filtering can be done - and the order it happens. and the difference between being a inner or a outer join

• Join - indicates how...

you don't have any filtering on #SOURCETABLE - you only filter on the join, so all records from #SOURCETABLE  will be selected.

and the only record you have on the sample...

according to documentation it would seem that it does not but worth confirming with someone that does work with PDW

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/database-mail-stored-procedures-transact-sql?view=sql-server-ver15

sysadmin is server (instance) level role as seen on

description of what each column for syslogins below

https://docs.microsoft.com/en-us/sql/relational-databases/system-compatibility-views/sys-syslogins-transact-sql?view=sql-server-ver15

and as you will need it for sure https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/server-and-database-roles-in-sql-server

Ideally you would load the events onto a sql server table and do the analysis and initial filtering there - easier with high volumes.

sample example that I use to do...

then don't commit the username/password - that could be on a "do not commit" file on your machine and get BIML to retrieve the username/password part from that file

in dev it should not matter - in all other environments all connections should be either done through the SSIS Catalog as sensitive or stored on a secure configuration database,...

duplicated post - reply in https://www.sqlservercentral.com/forums/topic/index-23

if you have a single filegroup with data files then you can't really tell it - some pages may be on one file, other pages on another file. So although...

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

what everyone else said - plus in some of the teams we have a database per change request being done.

one of our teams has almost always over...

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

Yes, there will be some limited page splits.  But the reads against the table will be vastly more efficient, even with the splits.

It's certainly possible that [TimeDayId] then [Material_Werksdaten_key]...