they are different in that the order by is different - one gets the biggest tables (order by totalspacekb desc) the other the ones with most unused space (unusedspacekb desc)

there were 2 queries - this is the output of which one?
and do give the 50 rows of each please.

and are you on a Enterprise or Standard...

Depending on other factors and volume of data following may also be a option.

Mainly dependent on whether you can identify updates/deletes/inserts on the target tables easily.

Add...

you changed what you didn't have to change.

you stated that you had already picked " as the text delimiter - that needs to be set
once set and...

no. what I said, and gave the example, is that any double quote that is part of the source text needs to be escaped with another quote

December 8, 2018 at 4:19 am

#2015818

yes - but as your file format is incorrect it needs fixing.

if the quotes are escaped (with another quote) then the file will load correctly, and the final...

this has been discussed over and over again both in this forum and elsewhere

as that is not a valid CSV file SSIS will not process it correctly.
Ask...

what is the size in pages of the indexes where fragmentation doesn't change?

and taking in consideration that most of the injections is done using hex representations of the data it is quite easy to inject if not using parameters.
https://www.c-sharpcorner.com/article/sql-injection-with-hex-code-and-its-prevention-mechanism/

and...

as your file is tab delimited you need to add
-Delimiter "`t"
to the import-csv command.

also and if volumes are high you will wish to...

it depends.... what have you read so far on it? plenty of information on it on the net for you to get here and just ask a question asked and...

before running more test I would drop index [idx_BTI_include] which you created thinking it would help. even though it is being used, it is the one giving poor estimates on rows...

anything on E:\SSISPackages-Logs\Log-Cube\DimProject.txt?
and if not can you change the command line to be

dtexec /FILE E:\SSISPackages\Packages-Cube\DimProject.dtsx /reporting V >>E:\SSISPackages-Logs\Log-Cube\DimProject.txt

and execute it again - by default /reporting ew...