Forum Replies Created

Viewing 15 posts - 1,141 through 1,155 (of 5,678 total)

  • RE: Query result in SQL Server 2000 return correct and SQL Server 2008 R2 SP2 return wrong

    antonio.estima 4150 (9/25/2012)


    Now, the filter "where SUBSTRING (nomeint, 1,1) = 'P' ", which is in subquery is precisely to bring unit not equals "PA" and thus does not occur conversion...


    - 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: Alternative for checkpoint

    Sam.... (9/25/2012)


    hi,

    I have a requirement in which i have to restart the package where it fails. I initially thought to use check points but that is not possible because i...


    - 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 executes successfully in dev/test environment but fails in production

    Get your DBA to look at the filenames in the production pathing. Most likely one of them has an invalid naming convention that you're picking up and trying 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: Memory allocation for SSIS variable

    rburko (9/25/2012)


    Just for chuckles, I changed my initial selection criteria so that only 100 rows get selected, instead of 1,000 or so rows, ending up in the ADO recordset...


    - 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: Trigger for or after Update

    PiMané (9/25/2012)


    The webservice writes directly on the Users' table and the trigger on the SyncEntities' table, with a FOR UPDATE, INSERT.

    Is the FOR UPDATE, INSERT executed in the same transaction...


    - 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: One common Question regarding SSIS Interview

    Smash125 (9/21/2012)


    Its been while have not given any interview SSIS.Just preparing my future course of action

    One common questions that comes to my mind is

    Explain SSIS architecture? My answer may...


    - 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: Job on 2012 to run SSIS 2008

    When performing an upgrade, one of the general ideas that underlies doing so is that you'll have to upgrade all the internal components to the new design. Now, I...


    - 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: Table partition - Multiple filegroups vs Primary filegroup?

    George is pretty much dead on the money, but a comment about multiple partitions in the primary.

    The only time I would recommend using partitions without multiple file groups is for...


    - 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: excel help...in ssis...

    sathiyan00 (9/24/2012)


    Hi all,

    i have to move invalid records(data type mismatch) from excel into error log and have to process only valid records.

    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: Are the posted questions getting worse?

    capnhector (9/21/2012)


    bitbucket-25253 (9/21/2012)


    SQLRNNR

    Targeting Joe and baiting him really needs to stop. And the same can be said of anybody else that has been personally attacked or been the recipient 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: Three Rules for Database Development

    I may just be old school, but I can't STAND not having an integrated development environment amongst all the developers. I guess the idea is that your database needs...


    - 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: Help writing SQL Server development guide!

    PiMané (9/21/2012)


    Aren't FKs faster to check than the IF SELECT .. ? If we name our FKs we can catch the specific error on code and display a more user-friendly...


    - 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: Store Procedure inside the Package is running slow

    JanTimmermans (9/21/2012)


    But I'm still curious how you'd rewrite the procedure without using an cursor 🙂

    What we do:

    Select ID, Adress, Zipcode

    From aTable

    Open Cursor

    Fetch Next into variables

    Do while eof

    ...


    - 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: DBA Interview Questions needed - Serious only please.

    CptCrusty1 (9/21/2012)


    Please fee free to PM me on these ideas if you wish to keep them off public consumption.... I gotta use em for the interviews....

    Crusty, where 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: T-SQL Help Needed

    SomewhereSomehow (9/20/2012)


    Evil Kraig F (9/20/2012)


    We don't, not in this. You're about 10 years behind us

    You are to optimistic to evaluate. I think our country has left behind 50 years....


    - 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 - 1,141 through 1,155 (of 5,678 total)