Forum Replies Created

Viewing 15 posts - 3,421 through 3,435 (of 5,678 total)

  • RE: Can I use Buffer in SSIS ?

    harun-974445 (4/12/2011)


    Hi,Thank you for your interest

    I want to optimize my performance using below actions on my SSIS package

    1.Reading same source once and transfer same Data several destinations using buffer or...


    - 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?

    Ah hah, found the problem. God bless IE9. *kabaam* I needed to click the 'compatability view' icon.


    - 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?

    LutzM (4/13/2011)


    Craig Farrell (4/13/2011)


    Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out of the rest of 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: convert CASE logic to IF

    Robson Brandão (4/13/2011)


    How Can I convert this code with IF structure ?

    DECLARE @Offset SMALLINT

    SELECT @Offset = CASE WHEN @Start_time = 'Daily' THEN null WHEN @Start_time =

    'Weekly' THEN...


    - 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?

    Is it just me or does the constant resizing of the new ad 'Click here to monitor SSC' annoy the hell out of the rest of you, too?


    - 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: Performance SSIS vs SP's

    timscronin (4/13/2011)


    has anyone seen any performance variation between running processes in sp's versus embedding that same sql logic inside of SSIS packages? Kind of like arguing religion

    I have, but...


    - 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: serious memory issue - i am totally lost - please help

    Hey Icon, recently rebooted? I'm going with Occam's Razor here.


    - 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?

    Gianluca Sartori (4/13/2011)


    ALZDBA (4/13/2011)


    I'm infected too 😀

    You were already, and you didn't know: How Is a Lizard Like a Motorcycle 😀

    Go Kermit Go!


    - 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: Who's afraid of Gila Monsters?

    Gila Monsters they makes me skeered. Theys youngers then me and more informed. I don'ts likes the Gila monsters. I feels inadequates!


    - 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: What are ther steps need to take when we need to tune the stored procedure

    Grant Fritchey (4/12/2011)


    Craig Farrell (4/12/2011)


    Grant Fritchey (4/12/2011)


    It really sounds like you've got a non-standard design, so I doubt any standard set of checklists on performance tuning is going to help....


    - 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?

    Chad Crawford (4/12/2011)


    Craig Farrell (4/12/2011)


    Personal side note: OMGWTFBBQ. Today is annoying. I've got a failure in QA I can't reproduce in Dev with the same load files....


    - 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?

    Personal side note: OMGWTFBBQ. Today is annoying. I've got a failure in QA I can't reproduce in Dev with the same load files. Now I need to...


    - 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?

    CirquedeSQLeil (4/12/2011)


    Craig Farrell (4/12/2011)


    WayneS (4/12/2011)


    Jack Corbett (4/12/2011)


    I'm sure y'all already know, but today is the last day of $299 price for SQLRally. Goes up to $349 tomorrow and then...


    - 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?

    WayneS (4/12/2011)


    Jack Corbett (4/12/2011)


    I'm sure y'all already know, but today is the last day of $299 price for SQLRally. Goes up to $349 tomorrow and then $399 May 1st....


    - 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: What are ther steps need to take when we need to tune the stored procedure

    Grant Fritchey (4/12/2011)


    It really sounds like you've got a non-standard design, so I doubt any standard set of checklists on performance tuning is going to help. All the stuff Wayne...


    - 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 - 3,421 through 3,435 (of 5,678 total)