Viewing 15 posts - 1,471 through 1,485 (of 5,678 total)
GilaMonster (6/13/2012)
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 13, 2012 at 1:00 pm
I'm not personally feeling all that able to help you on this one, but I've nudged a few of the other long time posters here and hopefully one of them...
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 13, 2012 at 12:46 pm
This person has an urgent problem with a SQL 2k8R2 upgrade gone south on the master db. He's polite and feels it's very urgent, and is pretty thorough. ...
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 13, 2012 at 12:45 pm
Awesome news and thanks for posting back with your solution, hopefully it'll help someone else one day.
I've seen that before, but usually only when you've got a linebreak of some...
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 13, 2012 at 12:42 pm
That is... not how I learned the term Internal Fragmentation. My apologies for the confusion. Thank you for the clarifications.
The idea, however, that internal fragmentation on a page...
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 13, 2012 at 12:35 pm
SueTons (6/12/2012)
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 12, 2012 at 6:51 pm
opc.three (6/12/2012)
GilaMonster (6/12/2012)
3. Deletes don't cause fragmentation.I thought that deletes were a major cause of internal fragmentation, though not necessarily external fragmentation.
For the direct mechanics of the delete internally, this...
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 12, 2012 at 6:46 pm
Search this site for an article by Jeff moden called 'Quirky Update'. Also other sources using "running totals" or "Cumulative Update" as your keywords. They'll help walk you...
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 12, 2012 at 6:38 pm
Jeff Moden (5/19/2012)
Evil Kraig F (5/18/2012)
BAH! Go back to Cobol you Luddites!
P.S. Heh... that's gotta be your 6 talking because your mouth knows better. How do you...
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 12, 2012 at 5:37 pm
Simply the first hit I found on my first google attempt:
http://blogs.msdn.com/b/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx
There's a ton out there. Just google 'ODBC SSIS driver'. Pick your concerned software if you have one...
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 12, 2012 at 4:48 pm
I'd say there's two sides to this particular coin. As an example, Indie Game Development can be a perfect place to admire the contrasts in the choices.
For example, there'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
June 12, 2012 at 4:44 pm
Sure. This is a bit of psuedocode using 3 columns but it'll give you the gist:
INSERT INTO NewTable
(ColA, ColB, ColC)
SELECT
ot.ColA,
'Static1',
'Static2'
FROM
OldTable AS ot
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 12, 2012 at 4:36 pm
Incorrect. If it's a functional Windows ODBC driver, it will function. Now, what you need to do to make it function will depend on the driver, it's personal...
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 12, 2012 at 4:35 pm
n.heyen (6/12/2012)
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 12, 2012 at 4:33 pm
You're doing it right. If you're not getting any data in the viewer during the test run, then the original query isn't returning data to the process. Check...
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 12, 2012 at 2:55 pm
Viewing 15 posts - 1,471 through 1,485 (of 5,678 total)