Forum Replies Created

Viewing 15 posts - 2,011 through 2,025 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/6/2012)


    Steve Jones - SSC Editor (1/6/2012)


    Top 10 from 2011

    User posts

    SQLRNNR ...


    - Craig Farrell

    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

  • RE: Drastic performance degradation in Data Flow from SQLS => DBF's -- IDEAS PLEASE

    Greg J (1/6/2012)


    Sincere thanks for your help Craig. I'll watch this thread for future posts.

    Sorry I can't be more help. I don't have anything Foxpro'ish locally to even...


    - Craig Farrell

    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

  • RE: SQL Agent Job succeeds even though step should fail

    Brandie Tarvin (1/6/2012)


    To be clear: I'm not concerned with fixing the timeout issue itself. I've got that covered. What I'm concerned with is how to force a SQL Agent job...


    - Craig Farrell

    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

  • RE: Today's Random Word!

    Brandie Tarvin (1/6/2012)


    I reject your reality and substitute my own.

    Dimensia.


    - Craig Farrell

    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

  • RE: SSIS package runs locally but fails when deployed in server ( Write data to EXCEL )

    Phil Parkin (1/6/2012)


    Evil Kraig F (1/6/2012)


    Your server needs the Office Suite installed, and possibly the exact driver you're looking for. You'll also most likely have to turn on the...


    - Craig Farrell

    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

  • RE: Drastic performance degradation in Data Flow from SQLS => DBF's -- IDEAS PLEASE

    I've never seen a DBF destination object, these are the standard ones:

    As to the properties, even with the OLEDB object they're not all visible in that properties window. You'll...


    - Craig Farrell

    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

  • RE: SSIS package runs locally but fails when deployed in server ( Write data to EXCEL )

    Your server needs the Office Suite installed, and possibly the exact driver you're looking for. You'll also most likely have to turn on the 'run in 32 bit mode'...


    - Craig Farrell

    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

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/6/2012)


    GilaMonster (1/6/2012)


    Grant Fritchey (1/6/2012)


    Brandie Tarvin (1/6/2012)


    Evil Kraig F (1/5/2012)


    One of the things we almost have to discuss is issues and problems. The trick is who are you...


    - Craig Farrell

    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

  • RE: How to diplomatically not answer recruter's question about salary ?

    shannonjk (1/5/2012)


    Makes me wonder how much money is in it.

    A lot, particularly in volume. Remember those recruiters are basically better educated telemarketers. The ones you need to know...


    - Craig Farrell

    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

  • RE: Hello friends !!!

    Two things.

    1) Please use the standard font unless there's a reason otherwise, it's annoying to read.

    2) Please see the first link in my signature below for how to present sample...


    - Craig Farrell

    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

  • RE: Drastic performance degradation in Data Flow from SQLS => DBF's -- IDEAS PLEASE

    Greg J (1/5/2012)


    All screenshots were taken from an RDC on the server.

    Then I'm not sure why that error is popping, that's annoying though.

    Machine is 64bit, and this package has "Run64BitRuntime"...


    - Craig Farrell

    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

  • RE: Drastic performance degradation in Data Flow from SQLS => DBF's -- IDEAS PLEASE

    I just thought of something. It's possible that your FoxPro driver is 32bit and is holding the transaction information, so it's choking, instead of anything that you can do...


    - Craig Farrell

    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

  • RE: Display Flashing Text in Reporting Services

    Martin Schoombee (1/5/2012)


    That would be better, yes. Flashing text seems a much better idea in theory than it actually works in practice. It usually turns out to be more of...


    - Craig Farrell

    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

  • RE: How to filter the output clause from Merge

    SQL Kiwi (1/3/2012)


    The MERGE statement can OUTPUT directly to an INSERT statement (this is sometimes referred to as 'composable DML'). You can add the required filtering to the INSERT...


    - Craig Farrell

    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

  • RE: Database Design Question/Help....

    On the subject of multiple databases vs. multiple schemas (or other in-database organization methods).

    Use different databases when you want to be able to do independent restores of data. If...


    - Craig Farrell

    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

Viewing 15 posts - 2,011 through 2,025 (of 5,678 total)