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 5 years, 8 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 5 years, 8 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]...

You should cluster the table on:

( Material_Werksdaten_key, TimeDayId )

Your join is very confusing.  You need to specify the TimeDayId(s) directly, not use a function on it.

Is TimeDayId one value...

ah well. didn't notice SQL Saturday was this near me (I'm in Dublin) - would have gone there if nothing else to talk with some people from here.

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 100 active databases...

Based on what you said I would change the table itself and have 2 new columns made up of the year and and month part of TimeDayId so the index...

thats SSIS for you - happens a lot unfortunately and I never managed to find a solution.

try with the 2016 runtime and see if it improves. https://www.microsoft.com/en-us/download/details.aspx?id=50040

if it still fails...

time for you do do a bit of data analysis and decide what you want to do with it.

look at the values from the sql below - some of these...

other aspect - assuming that you did install the correct driver on your SQL Server and that your cms is using the defaults then the syntax should be

select *

from cmslinkedservername.cms.root.hagent...

does not matter what we think will work - you are trying to extract data from a third party database (avaya which is, as far as I know, an informix...

Frederico,

The issue is, it doesn't work.

I get this error:

Arithmetic overflow error converting float to data type numeric.

When I try this line below:

Case When [Vendor invoice] Like '%E+%' Then Cast(Convert(numeric(24,0),...

is your installed excel version a 64 bit?