Viewing 15 posts - 1 through 15 (of 43 total)
I am currently at work to give you the exact style of DDL. I will come back on Monday if it is ok with you.
April 25, 2020 at 10:25 am
Hi, thanks, I will look into that.
Last question: is this really the idea how to solve such issues, i.e. use a metadata tool to duplicate objects otherwise to be to...
April 23, 2020 at 6:43 pm
Never heard of BIML before. I googled it just now. Can you recommend any free tool to generate the dtsx packages? command line would work, too.
April 23, 2020 at 4:48 pm
Side remark: I do not understand why Microsoft is not able to build source and target operators which are able to handle parallel threads. It is bad coding design to...
April 23, 2020 at 4:44 pm
Here is something I have in mind (just thinking)
I could extend the current hub structure
with a new purely technical column running only...
April 23, 2020 at 4:41 pm
Just to make it clear: staging brings only 50 million records, the lookup is done against 750+ million records. So partitioning the stage data only makes the 50 millions part...
April 23, 2020 at 4:31 pm
I have done it first in pure SQL using a left join with where is null condition to keep only the new ones. For some reason, the query estimator was...
April 23, 2020 at 4:28 pm
The MaxConcurrentExecutables setting is set to -1. I guess that the decision what to run is not done by SSIS but the SQL server engine.
I have to take a deeper...
April 23, 2020 at 3:24 pm
There is a top level task which drops all foreign key constraints. The tables are without any constraints (PK, Unique, FK, Check). Also, compression is disabled. Further, I use INSERT...
April 21, 2020 at 2:50 pm
Cost Threshold of parallelism is set to 5 (I think it's default since stone age) and MAXDOP is number of logical cores of the machine (e.g. 10 physical cores with...
March 6, 2020 at 8:46 am
thanks, that would be nice if you could come back to me with details. Links to literature is fine for me, I just need help to get the buzzwords that...
March 3, 2020 at 5:23 pm
sorry for keeping you waiting so long. I had to made several tests before. I have read your link about minimal logging on clustered indices.
I have a very simple...
February 28, 2020 at 12:35 pm
Oh, ok. I have to check that.
Is there any other option to avoid it? I have chosen to write all my staging data into an uncompressed heap due to minimal...
February 26, 2020 at 9:41 pm
Thanks for the quick reply.
So, you think that MAXDOP as option will get the number of cores up for writing the table? Or is the writing always a single core...
February 26, 2020 at 9:15 pm
Edit: I know of the following article:
But the machine is using all cores at the beginning. Does it switch the behaviour dynamically?
February 26, 2020 at 8:45 pm