Viewing 15 posts - 2,491 through 2,505 (of 5,678 total)
john.clyma 97764 (10/5/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
October 5, 2011 at 7:41 pm
AJ,
What particular concepts are you feeling you're having difficulty with? An end to end discussion on warehousing, even particularly for healthcare, is incredibly broad. A few particular components...
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
October 5, 2011 at 7:37 pm
opc.three (10/5/2011)
In particular, if you're running SQL Express (thus no SQL Agent) and want to do a BCP/Bulk Insert and then archive the file you've done it from, you'd 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
October 5, 2011 at 4:55 pm
opc.three (10/5/2011)
Evil Kraig F (10/5/2011)
opc.three (10/5/2011)
PS I cannot wait to see the examples of when one would HAVE to use it.SQL Express with an on-demand file bulk load and archiving.
My...
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
October 5, 2011 at 4:24 pm
opc.three (10/5/2011)
PS I cannot wait to see the examples of when one would HAVE to use it.
SQL Express with an on-demand file bulk load and archiving.
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
October 5, 2011 at 4:01 pm
Why are you double scanning?
select Short_Name from t_One where short_name like 'val%'
union
select short_Name from t_One where short_name like '%val%'
Returns the equivalent of:
select short_Name from t_One where short_name like...
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
October 5, 2011 at 2:55 pm
Well, I certainly got it wrong, but that's because of simple unfamiliarity but I tried to turn it into my familiar world. I figured elementary key meant candidate 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
October 5, 2011 at 2:22 pm
SQL Kiwi (10/5/2011)
SQLRNNR (10/5/2011)
2 of 3 servers I get arithmetic overflow and the 3rd server differs by 35 seconds.
Yeah great, so do I come back for the second interview 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
October 5, 2011 at 11:39 am
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the MVP'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
October 5, 2011 at 10:36 am
Question Guy (10/4/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
October 5, 2011 at 10:26 am
It sounds like the login running the SQLAgent doesn't have the access levels you do to the other system. I'd start there.
Primarily because of this component in the error:
"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
October 5, 2011 at 10:14 am
GilaMonster (10/1/2011)
Lowell (9/30/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
October 1, 2011 at 5:39 am
Lynn Pettis (9/30/2011)
Need Software with following modules and features...
... an entire software suite from the land of the gods...
If you are...
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
October 1, 2011 at 5:33 am
Roughly:
DELETE a
OUTPUT tblc
FROM
tblA as a
JOIN
tblB as b
ON a.col1 = b.col1 AND a.col2 = b.col2 ....
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
September 30, 2011 at 4:25 pm
Hey guys, Jack's got me flabbergasted over here. Anyone else familiar with SSIS and connection failures want to take a swing?
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
September 30, 2011 at 2:23 pm
Viewing 15 posts - 2,491 through 2,505 (of 5,678 total)