plan doesn't attach on forums - you will need to use https://www.brentozar.com/pastetheplan/ and post link.

another question - is the output of that query being directly inserted into a table or...

`back to basics - what problem are you trying to solve?

is the query too slow? how long does it take and how often is it executed?

does it affect other queries...

and adding to this - parallelism waits are NOT bad per se - while it may be a pointer for you to look at the queries that go parallel, in...

thx frederico, not sure but i think our recovery simple choice addresses your point about logging mode.   and yes i've seen backups run in seconds on this 105 gig...

still possible to do...

...

i've concluded that the sales sub pkg runs only after its dimensions are done and that when a full load is requested all fact sales are explicitly deleted (one...

I would make it truly more generic (might as well).  Definitely avoid the use of INFORMATION_SCHEMA views, since they are not 100% reliable and often seem very slow.  I,...

try the latest code - and resolve was on your own original code and I kept it before. Gone on latest one.

it does work on my pc with both valid...

regarding adding the details to the same line I gave you the way to do it - using Expressions @{N='Name'; E=Expression} you can add anything you wish to the output.

another...

• This reply was modified 1 year, 6 months ago by frederico_fonseca.

code had a "," too many.

below works

$location = "C:\TEMP\FailedSQLLoginSearch_AllSvrs.csv"
$Names = Import-Csv -Path $location

foreach($n in $Names)
{
    try {
       ...

Sigh. I wish I could take comfort in "Your emergency is not my emergency." Sadly, my job makes other people's emergencies my emergency.

Any powershell gurus around? I'm still in...

try the following.

assuming that your csv file (you have it as xlsx which I believe may be a typo) contains 3 columns - SQLServerName, IPAddress and LoginName

foreach($n...

it could be other things and just seeming like that to your Oracle team. reason for me asking for the code you use was also to see if there had...

and how will that work within a Stored Proc?

could you supply the code that is doing that insert - including both the retrieval of data from SQL Server and the sending to Oracle.

And DDL for source columns being...

• This reply was modified 1 year, 7 months ago by frederico_fonseca.