Forum Replies Created

Viewing 15 posts - 736 through 750 (of 3,232 total)

  • RE: How to switch data online

    Just for everyone's benfit, this question has been posted in 6 different threads. I think they've all been linked to this thread now, so we can all work within...

    John Rowan

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

    January 12, 2010 at 1:52 pm

    #1102735

  • RE: How to partition huge data to multiple machines?

    This same question has been asked 6 times in different forums. Please only create one thread per question as it causes confusion for those who frequently answer questions. ...

    John Rowan

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

    January 12, 2010 at 1:51 pm

    #1102734

  • RE: How to partition huge data to multiple machines?

    Triplicate post, please respond here.

    John Rowan

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

    January 12, 2010 at 1:44 pm

    #1102730

  • RE: How to switch data online

    Another duplicate post, please contiue this discussion here .

    John Rowan

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

    January 12, 2010 at 1:41 pm

    #1102724

  • RE: How to switch data online

    Another duplicate post, please contiue this discussion here .

    John Rowan

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

    January 12, 2010 at 1:40 pm

    #1102722

  • RE: Comparing and Deleting repeating values in semicolon delimited string

    No problem. I would not be suprised to find that you get some other solutions from some of the other regulars here on SSC. I cringe at the...

    John Rowan

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

    January 12, 2010 at 1:21 pm

    #1102715

  • RE: Comparing and Deleting repeating values in semicolon delimited string

    OK, that was quicker than I thought. I created a scalar function to be applied to your column. There may be a better way to do this performance...

    John Rowan

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

    January 12, 2010 at 1:14 pm

    #1102710

  • RE: Comparing and Deleting repeating values in semicolon delimited string

    By the way, this is the quick and dirty example. I realize that your data is in a column in a table, which makes my variable based exmaple not...

    John Rowan

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

    January 12, 2010 at 1:06 pm

    #1102701

  • RE: Comparing and Deleting repeating values in semicolon delimited string

    This is an easy task for a tally table with a split function. Do you by chance have a numbers table or split function already in your DB?

    If not,...

    John Rowan

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

    January 12, 2010 at 1:01 pm

    #1102697

  • RE: How to switch data online

    There are other alternatives as well. Can you give us some of the business reasons for wanting to do this? What are you trying to accoplish by switching...

    John Rowan

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

    January 12, 2010 at 12:47 pm

    #1102678

  • RE: Error renaming an index

    Yea, I figured it to be a 2008 thing, but it's odd that the new syntax still works on my 2005 instance.

    Thanks again.

    John Rowan

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

    January 12, 2010 at 11:19 am

    #1102621

  • RE: Error renaming an index

    GilaMonster (1/12/2010)

    John Rowan (1/11/2010)

    Yep, you have to do the same thing when using DROP INDEX too.

    However that is deprecated syntax. The newer syntax is

    DROP INDEX <index name> ON <Table Name>

    Thanks...

    John Rowan

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

    January 12, 2010 at 10:25 am

    #1102588

  • RE: Today's Random Word!

    Opportunity.

    John Rowan

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

    January 12, 2010 at 10:09 am

    #1102577

  • RE: Error renaming an index

    Yep, you have to do the same thing when using DROP INDEX too.

    John Rowan

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

    January 11, 2010 at 4:55 pm

    #1102111

  • RE: Error when trying to load multiple files in a Foreach Loop (SSIS)

    It looks like the connection manager properties are not being set correctly by the values returned from the for each loop container. Have you tried to toggle the debug...

    John Rowan

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

    January 11, 2010 at 4:52 pm

    #1102109

Viewing 15 posts - 736 through 750 (of 3,232 total)