Viewing 15 posts - 2,401 through 2,415 (of 5,678 total)
Out of curiousity, OP... Usually the older systems were heavily tuned and something 'tipped', or something new exploded (which wouldn't be on 32bit, these days). Do you use a...
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 27, 2011 at 5:37 pm
There's a 'redirection' choice on OLEDB Target.
Open the target, on the left, go to Error Output. Chose 'Redirect Row'.
Send that row off to a simple flatfile or something, 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 27, 2011 at 5:27 pm
Elliott Whitlow (10/27/2011)
Evil Kraig F (10/27/2011)
Elliott Whitlow (10/27/2011)
You can install SSIS without installing the database engine.
True, just still need to have equivalent licensing as though you had installed the full...
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 27, 2011 at 2:57 pm
randy.worrell (10/27/2011)
My SQL experience has been from SQL Server version 6.5 forward, but never in a DBA sense.
That'll be problematic.
Why problematic?
DBAs are the first and last line of defense. ...
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 27, 2011 at 2:24 pm
Elliott Whitlow (10/27/2011)
You can install SSIS without installing the database engine.
True, just still need to have equivalent licensing as though you had installed the full engine... At which point, why...
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 27, 2011 at 2:19 pm
Hey Ki,
Well, with how convoluted this query is nothing's obvious yet. Some questions.
Considering the sample data, should I be expected a result set that looks like this?:
9662010-04-12 00:00:00672714756
11602010-03-08 00:00:00672714756
26882010-07-19...
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 27, 2011 at 2:15 pm
Tom Brown (10/27/2011)
Thanks for the comments Craig?? II's :unsure: Whats an II? (Some DBA shorthand for developers perhaps Ignorant Idiots?, Itinerant Interns? Infernal Irritants? )
LOL, no, not exactly... Out...
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 27, 2011 at 2:03 pm
venoym (10/26/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 27, 2011 at 1:54 pm
randy.worrell (10/27/2011)
But in an entry level situation, fresh out of college, would someone with an MBA degree with MIS have any advantage over someone with a Bachelors degree?
Only if they'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
October 27, 2011 at 1:45 pm
Regarding Peer reviews:
- Remember the audience. Their attitude will control your approach as much as anything else.
- If you see something that seems odd, particularly strangely optimized code, simply...
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 27, 2011 at 1:37 pm
Kiara (10/27/2011)
GSquared (10/27/2011)
Kiara (10/27/2011)
Sending you a PM, rather than clutter up the Thread...
The Thread lacks clutter???????????????????
Y'know, when I wrote that, I sort of shook my head at myself...
Today, on Hoarders!...
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 27, 2011 at 12:34 pm
bkmooney (10/26/2011)
I ended up having to create a new connection to the csv file, but then the if statement worked.Thanks!
My pleasure, happy to help. 🙂
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 27, 2011 at 12:14 pm
mail.lists (10/26/2011)
The first question I have is, how does one determine if it is necessary to separate them?
The same way you decide if any instance needs to be...
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 27, 2011 at 12:04 pm
Needs one additional answer: "It Depends"
Dynamic SQL in the middle of a proc will have little difference to the affect if intelligently parameterized for cache reusage.
Dynamic SQL from OUTSIDE...
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 27, 2011 at 12:00 pm
When a job fails and the BIDS works first culprit is almost always security. Check the login for the SQLAgent and confirm that login has the necessary rights, unless...
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 27, 2011 at 11:53 am
Viewing 15 posts - 2,401 through 2,415 (of 5,678 total)