Viewing 15 posts - 1 through 15 (of 46 total)
sorry, my remote access to the server doesn't work since half a day. I couldn't run the I/O tests.
But Brian pointed it out: MSSQL joins with the whole table what...
June 4, 2020 at 3:10 pm
your comment is exactly my issue I have.
To confirm your assumptions:
First, let us stick...
June 3, 2020 at 8:43 pm
Foreign keys do exist (see screenshot of ERD, I just removed them from the script).
As I am a novice to query plans: does the sqplan file help you to answer...
June 3, 2020 at 7:26 pm
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