Viewing 15 posts - 1,381 through 1,395 (of 2,654 total)
what you are failing to understand is that your command line is executing the package ON THE SERVER and as such all resources required NEED to be on the server ...
August 18, 2020 at 4:50 pm
on your SERVER you need to install the Oracle client components and configure it as required (tnsnames, sqlnet.ora) - as your SQL server is 64 bit you should install the...
August 18, 2020 at 3:53 pm
on your pc you need both 32bit and 64bit of the oracle client as you were told before.
32bit install should be done first.
Did you do that?
August 14, 2020 at 10:33 am
parallel is not necessarily worst - in many cases is it a lot faster than serial but it all depends.
as we mentioned before we need full code including underlying views...
August 12, 2020 at 6:57 pm
if you have Enterprise Edition use the Attunity driver instead as it is faster - you still need oracle client.
if you have SQL 2019 then the newer driver will be...
August 10, 2020 at 11:12 pm
Could you post the plan here: https://www.brentozar.com/pastetheplan/
I've already uploaded it here as a zip file.
August 10, 2020 at 8:29 pm
having a sqlplan won't give you the sql query (the one that matters) on this case as a view is being used.
main query is a view - I would bet...
August 10, 2020 at 7:49 am
that is not an error but a info message - the last entry is an "error" but no description of what it is.
the other messages should be removed from the...
August 6, 2020 at 11:25 pm
look at the examples supplied here - some do have error handling which you should have cared to use.
August 6, 2020 at 7:19 pm
try adding firstrow option to start data at row 2 - row 1 is headers so it would blow the size of the columns you defined on that table.
August 5, 2020 at 11:32 pm
my take on this is " if you need to ask if NOLOCK should/can be used on a particular case then you do not know about it's issues and therefore...
August 4, 2020 at 8:18 pm
nolock should NOT be added anywhere.
you can read (from many others) this one https://www.sentryone.com/blog/aaronbertrand/bad-habits-nolock-everywhere
August 4, 2020 at 7:07 am
try it on your test environment and you will know if your assumptions are correct.
July 31, 2020 at 8:44 am
snip
OLD Server: 16 vCPU, 24 GB RAM
NEW Server: 4 vCPU, 8 GB RAM
Argh! That had not been my understanding. I'm guessing that this is what TL meant that he...
July 24, 2020 at 6:06 pm
the plan for a single part is most likely not going to be the same when executed for more parts (and more companies potentially).
just based on the plan supplied and...
July 23, 2020 at 6:02 pm
Viewing 15 posts - 1,381 through 1,395 (of 2,654 total)