Viewing 15 posts - 3,061 through 3,075 (of 5,678 total)
The Dixie Flatline (6/2/2011)
Msg 4104, Level 16, State 1, Line 10
The multi-part identifier "f.id" could...
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 2, 2011 at 3:44 pm
The main script and the event handlers can't share variables if you open them for read/write through the interface.
Look into LockForOneRead and LockForOneWrite. My guess is this is where...
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 2, 2011 at 3:37 pm
The Dixie Flatline (6/2/2011)
Yet again, I will attempt to explain....
ROFL...
... anyone here know how to Madison?
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 2, 2011 at 3:35 pm
The Dixie Flatline (6/2/2011)
Where is the join to F in either query? What are using to join to C...
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 2, 2011 at 3:30 pm
It's a syntactical way to represent subquerying.
The basic gist is do you inner join the entire left join first, thus restricting what gets left joined, or perform the left join...
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 2, 2011 at 3:24 pm
Or use multiple OLEDB sources to call each proc/database/whatnot, and then use the union operator (it doesn't stall the stream) to a single delivery point.
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 2, 2011 at 12:21 pm
Alan,
What you're describing is what I've always known as a data flow diagram. They are very powerful but you can't keep them up to date forever, the documentation on...
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 2, 2011 at 12:19 pm
jd_ajy (6/1/2011)
Please I need comments. Thank you.
I ... think I kind of understand what you're trying to do, but can't quite wrap my head around it.
As mentioned above,...
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 2, 2011 at 12:14 pm
It's simply not supported:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319138
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 1, 2011 at 5:27 pm
david.holley (6/1/2011)
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 1, 2011 at 5:25 pm
The Trigger would need to go through a linked server that way. Let the linked server impersonate a valid user on the foreign DB. That's the quick fix....
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 1, 2011 at 3:01 pm
WayneS (6/1/2011)
Lordy, I knew 2005 made it easier... forgot just how much easier! I'm having trouble even thinking along those lines anymore. 🙂
You'd laugh to know I built one of...
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 1, 2011 at 2:52 pm
jcrawf02 (6/1/2011)
The Dixie Flatline (6/1/2011)
SOM
Somebody remembered!
LASHIWAB!
:unsure: :alien:
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 1, 2011 at 2:46 pm
david.holley (6/1/2011)
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 1, 2011 at 2:45 pm
james.morrison 19355 (6/1/2011)
Craig Farrell (6/1/2011)
:rolleyes: Interesting choice of words. Master, or have enough to get by with?
If you are referring to the MCM in terms of "Master" then...
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 1, 2011 at 2:43 pm
Viewing 15 posts - 3,061 through 3,075 (of 5,678 total)