Forum Replies Created

Viewing 15 posts - 526 through 540 (of 3,232 total)

  • RE: Today's Random Word!

    hypocrites

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: How to return file name in SSIS

    Yes, use the Foreach File Enumerator. Then, use the Expressions editor to set the FileSpec Expression to your expression from your first post. This will tell the enumerator...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: How to return file name in SSIS

    You can use the For Each loop container to loop through a group of files. Set the For Each loop up so that it only considers files that meet...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Today's Random Word!

    Bubba.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Today's Random Word!

    Kit G (4/14/2010)


    CirquedeSQLeil (4/14/2010)


    Steve Jones - Editor (4/14/2010)


    Flat tax, I like that one.

    So long as the upper 10% (income wise) do not get all of the same loopholes that continue...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Today's Random Word!

    Heh, I have to finish mine up tonight.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: How to edit SCD transformation in SSIS?

    Well, in that case, you may have to open up the .dtsx file in Wordpad and search for the SCD task name. The file is stored as XML so...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Today's Random Word!

    grace

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: How to edit SCD transformation in SSIS?

    Use the Wizard to walk through the setup. Just keep in mind that if you get to the end of the wizard and select finish, it will rebuild all...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: performance problem in production database

    Well, this is a loaded question. The subject of performane monitoring and tuning is vast and detailed. I can give you some guidence as to where to start,...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Dynamic Partitioning

    It is possible, but it could get ugly in this scenario. The way SQL Server partitioning works, you would have to create procedures that manage your partition function and...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Dynamic Partitioning

    This is a duplicate post. Let's continue here in this thread.

    For reference, the other thread is here.

    I'm in agreeance with Paul here, why do you think you need partitions?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Dynamic Partitioning

    Duplicate post, continue thread here.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Dynamic Partitioning

    Creating procedures to manage partitions dynamically is not an easy task (I've done it). Since you are a self-admited SQL Server newbie, I'll start by asking the question, why...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • RE: Update query - need suggestion

    As K Cline pointed out, put the update field comparison in the WHERE clause instead of the in a CASE statement in the UPDATE. This allows the optimizer to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 15 posts - 526 through 540 (of 3,232 total)