Viewing 15 posts - 1,411 through 1,425 (of 5,685 total)
matthew.brown-746365 (6/29/2012)
Wow, I did everything I'm NOT supposed to do. I'm sorry Craig, thank you for your patience!
Not a problem. It's hard to know what to do when you're...
June 29, 2012 at 2:57 pm
rjbirkett (6/29/2012)
I don't know what to say. Brilliant explanation. If you could see my code you would know why I understand RBAR:-) There are really only two...
June 29, 2012 at 2:43 pm
GilaMonster (6/29/2012)
June 29, 2012 at 1:57 pm
At the 50,000 foot view without digging into a ton of details, they basically queue up behind each other, with the internals allowing for expected short shared locks (read) to...
June 29, 2012 at 1:44 pm
rjbirkett (6/29/2012)
Lynn,How am I going to process each record without looping through? For/Next? Next n? you have to iterate somehow, right?
Rob
In case Lynn's busy, the nature of the...
June 29, 2012 at 1:39 pm
dwain.c (6/27/2012)
June 28, 2012 at 1:05 pm
Yikes, alright, that's complex and I kinda understand the issue.
For starters, can you take a quick breeze-through on the first link in my signature? It'll walk you through what's...
June 27, 2012 at 5:16 pm
sqldba_newbie (6/27/2012)
Is there general guide line on how to reduce number of executions on a portion of query? I will try to post the actual query also.
I assume you're seeing...
June 27, 2012 at 5:11 pm
MrReddy (6/27/2012)
The Oracle data is updated at anytime , so I need...
June 27, 2012 at 4:39 pm
achen9291 (6/27/2012)
I would have to say the first option. Multiple datasets. I'm confused myself :/
Alright, it's not pretty but if you actually need multiple unique datasets returned what you want...
June 27, 2012 at 4:36 pm
amanmeet.mehta 46966 (6/26/2012)
Hey Craig,For doing audit trails asynchronousally we need to use service broker right?
regards,
aman
Usually, yes. There are alternatives but that's your best internal bet if you're trying...
June 27, 2012 at 4:17 pm
Are you trying to get it to return multiple datasets back to the calling component or are you trying to find a way to perform this loop so a single...
June 27, 2012 at 4:14 pm
Can you describe exactly how you have the transactions organized and in what kind of containers? Also, what are your settings for the different connections (in particular Keep same...
June 27, 2012 at 4:12 pm
MrReddy (6/27/2012)
Hello All,is there any way to run an SSIS package that is in production from other servers????
Thanks,
Can you, yes. Should you, no. It makes management a nightmare...
June 27, 2012 at 4:08 pm
Viewing 15 posts - 1,411 through 1,425 (of 5,685 total)