Viewing 15 posts - 3,046 through 3,060 (of 5,678 total)
Bill Tidwell (6/6/2011)
Thanks so much. I might be a couple of days before I can focus on this, since the week has reset back to Monday.
I scanned through it...
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 6, 2011 at 10:08 am
Alright, finally got a little time to go delving into this.
This end is end to end test code, and worked in 2k5 Express, so nothing funny's going on, though I...
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 5, 2011 at 9:44 pm
Lynn Pettis (6/4/2011)
I am going to be grandfather![/i]
Looks like I'll 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 5, 2011 at 8:04 pm
I've always thought of most certifications as the rest of the world thinks about college degrees. Just because you shoved knowledge into your head for a few years, doesn't...
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 5, 2011 at 1:22 pm
Ishrar, a few things.
1) Congratulations on your first post being both coherent and explanatory. My hat is off to you for remembering to bring your brain to the discussion....
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 5, 2011 at 2:32 am
If the spid isn't blocked, it's in the tempdb spooling. Look for contention on the raid for the tempdb.
I realize that's kind of a leap, but it's the only...
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 5, 2011 at 2:28 am
Jeff Moden (6/3/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 4, 2011 at 2:00 am
Vedran Kesegic (6/3/2011)
Backup software, like backup4all (google that, or use direct link: http://www.backup4all.com/en/help/backup_types.html), have really well...
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 3, 2011 at 5:05 pm
Thanks Bill, that helps tremendously.
Now, I'm going to need your help understanding the components of the stream.
First, I need to know where a record starts. Is it on 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 3, 2011 at 4:53 pm
I'd start with figuring out what in the proc(s) needed to be tuned. Tuned for speed, tuned for concurrency, or tuned for reducing I/O.
Usually, I tune for speed.
From there,...
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 3, 2011 at 4:38 pm
If you haven't already, double check that your connections in the SSIS package, and your configurations, are pointing where you think they are. May just be a typo.
Next step...
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 3, 2011 at 2:43 pm
This is a common problem when working with older mainframes. As OPC pointed out above, being able to consume the data easily in a test structure will assist us.
In...
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 3, 2011 at 12:01 pm
Can't, a group can't own a job or package. It's been driving me nuts for developers for years when I don't want to give them overkill rights.
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 3, 2011 at 11:53 am
mister.magoo (6/2/2011)
Does PI (3.14159 etc ) which never repeats = 3.141.......
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 6:25 pm
Obs (6/2/2011)
Ah, thanks guys. It makes sense, just never occurred to me to write it that way.Edit: Indeed, I did edit it. Meant to note it. My bad.
Glad...
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 6:21 pm
Viewing 15 posts - 3,046 through 3,060 (of 5,678 total)