Viewing 15 posts - 1,426 through 1,440 (of 2,701 total)
if you going for an article on this I suggest you highlight the differences between the Powershell version that SQL Agent uses vs the "windows installed" version - also the...
August 25, 2020 at 4:23 pm
although you could do it through a PS script directly on the step I prefer, and advise, using a command prompt instead and start an instance of powershell - more...
August 24, 2020 at 7:28 pm
redgate sql compare would work fine for that.
August 24, 2020 at 7:30 am
limitations are on the documentation you read - should you post a link here maybe someone will look at it and if the link is the wrong one give you...
August 23, 2020 at 10:53 pm
it depends.
dtexec has a varied set of options.
August 18, 2020 at 5:30 pm
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
Viewing 15 posts - 1,426 through 1,440 (of 2,701 total)