Viewing 15 posts - 31 through 45 (of 5,678 total)
skroba (11/18/2014)
How to release orphaned Application, Exclusive, Session lock without dba interaction and without killing session itself? How release the lock...
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
November 18, 2014 at 11:46 am
Sickmyduck091 (11/18/2014)
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
November 18, 2014 at 11:42 am
I'd go as generic as possible:
"Revenue Generators"
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
November 18, 2014 at 11:36 am
Don,
What you're running into is a classic problem in Warehousing. I've heard it phrased as "Know the question before looking for the answer."
One of the reasons Kimball vs. Inman...
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
November 17, 2014 at 5:46 pm
Eirikur Eiriksson (11/17/2014)
The namespace is implicitly created when the variable is declared, no way of telling the difference between user::var and usre::var when you call var.
Okay, you have me confused....
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
November 17, 2014 at 4:07 pm
Usually you stick the system databases (besides tempDB, that has its own set of rules) onto their own spindle set in self defense. Master and MSDB are a royal...
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
November 17, 2014 at 3:30 pm
Yes, I did. Still have the old version. Nothing there, single declaration.
Ah, that. The chioces are User:: and System::. Why would I wan't to include that inside...
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
November 17, 2014 at 3:07 pm
When the package works, and the job fails in Agent, there's only one culprit to do all of your checking against: The user just changed.
When you run in BIDS/VS, 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
November 17, 2014 at 2:53 pm
Eirikur Eiriksson (11/17/2014)
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
November 17, 2014 at 2:51 pm
webrunner (11/17/2014)
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
November 17, 2014 at 2:46 pm
sweetumz (11/17/2014)
UPDATE [Inventory item.Personnel.Transit.Department]
SET [Inventory item.Personnel.Transit.Department.Department]=01
Can we see your full code and the actual error message, please? There's no WHERE clause on that UPDATe so unless you're overwriting 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
November 17, 2014 at 1:54 pm
Just as a point of clarification, we had a corrupted package, thus the nonconformity to expectations.
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
November 17, 2014 at 1:49 pm
webrunner (11/17/2014)
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
November 17, 2014 at 1:43 pm
FishD (11/12/2014)
Craig's idea to combine fields to make a key field is also going to work.
Errr, you don't have to 'combine' them. You just use a multicolumn key. ...
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
November 12, 2014 at 5:14 pm
There's not much, but is there any form of natural key on the incoming data? Not your identity, but maybe a 4 column combination showing a unique record or...
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
November 11, 2014 at 2:01 pm
Viewing 15 posts - 31 through 45 (of 5,678 total)