Viewing 15 posts - 1 through 15 (of 223 total)
use "distinct" at the bottom of your CTE, right after "select" on the line where you have the "windowing" (over.. partition..)
I am not 100% sure, but, give it a shot
June 24, 2019 at 12:12 am
How about having a shared location, sort of a DMZ, since the DEV cannot see the PROD by design.
A scheduled agent task / job at the destination can run an...
June 23, 2019 at 5:15 pm
The AD group should have "connect" privilege by modifying the properties of the database (for each DB). Then, you would need to create role(s) and assign read/write/view definition/etc. for the...
June 23, 2019 at 4:49 pm
If this column is not acting as a foreign key to another DB object(s) then perhaps my suggestion may raise eye-brows.
Add a new col, put the values that you wish...
June 23, 2019 at 12:55 am
I came too late into this conversation and I hope I make sense.
Option 2 is not bad. However, if I had to take that route then I would first create...
June 22, 2019 at 5:14 pm
Have you tried using client provider 10 to connect to your 2008 sql server?
That could be the problem.
June 22, 2019 at 5:01 pm
Agree with Thom about the "from" statement, and also the replace and LEN calculation may be costly.
Important factors are: size of the tables, appropriate indexes, take advantage of common table...
June 22, 2019 at 4:55 pm
Agree with Fredrico, please post and explain the plan.
June 22, 2019 at 4:38 pm
I have run your script and this is the result I got, so, not sure how you got that error.
June 22, 2019 at 4:32 pm
have you tried transparent gateway between oracle and sql server?
May 11, 2018 at 2:58 pm
The security is fine, as mentioned, it is a shared functional data-source. over 100s of reports are using that.
New Findings:about 20 minutes ago, created a linked...
May 11, 2018 at 1:59 pm
The only thing left for me to believe is the possibility of a bug(s) in the system.
It is not making sense why the history is written out when SSIS...
May 18, 2016 at 10:54 am
That's very good question and yes I have dropped and recreated the non-conforming job.
Also, yes, I have checked and made sure that no other process is deleting, 1 because...
May 17, 2016 at 12:33 pm
there are only 3 record and the table is no where near full
see previous snap-shots from history results.
see attached for more interesting info on the "agent" side.
May 17, 2016 at 12:04 pm
I thought this setting were universal / global for all jobs... as seen in previous message, 1 works and the other does not ..
May 17, 2016 at 11:52 am