Viewing 15 posts - 1,411 through 1,425 (of 5,678 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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 29, 2012 at 2:57 pm
Sorry, duplicate post.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 29, 2012 at 2:44 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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 29, 2012 at 2:43 pm
GilaMonster (6/29/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 29, 2012 at 1:39 pm
dwain.c (6/27/2012)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 27, 2012 at 5:11 pm
MrReddy (6/27/2012)
The Oracle data is updated at anytime , so I need...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
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...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 27, 2012 at 4:08 pm
Viewing 15 posts - 1,411 through 1,425 (of 5,678 total)