Forum Replies Created

Viewing 15 posts - 25,126 through 25,140 (of 59,099 total)

  • RE: This is how to fail

    In my very humble opinion, Mr. Joel Gascoigne handled things absolutely perfectly. Even though I don't use Buffer, the man and the company he represents have earned an incredible...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 17, 2013 at 8:58 am

    #1674113

  • RE: SQL 2005 IndexDefrag solution

    henrik staun poulsen (7/8/2008)

    apart from the special scheduling (2:00 to 8:00) it looks as if it has more features than your procedure.

    Which is why some people are driven to write...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 17, 2013 at 8:40 am

    #1674105

  • RE: Removing the Linked Server 2 hop Limitation

    Between the content of this article and the addition recommendations from Mr. Kelly, this is a definite keeper. Thank you both for taking the time to help solve this...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 17, 2013 at 8:22 am

    #1674094

  • RE: Cursor or Temp Files?

    You're welcome. Thank you for the feedback.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 17, 2013 at 6:34 am

    #1674043

  • RE: Are the posted questions getting worse?

    WayneS (12/16/2013)

    Jack Corbett (12/16/2013)

    WayneS (12/13/2013)

    Greg Edwards-268690 (12/13/2013)

    jasona.work (12/13/2013)

    Ed Wagner (12/13/2013)

    jasona.work (12/13/2013)

    OK, where did the year go?

    I mean seriously, 12 days until X-Mas? It feels like it was...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 8:34 pm

    #1673939

  • RE: Cursor or Temp Files?

    Perfect. That also makes the next logical permutation of adding another status to the acceptable statuses super easy. For example, if someone later decides that the status of...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 8:29 pm

    #1673938

  • RE: Space did not gets released after removing data

    SQLAli (12/16/2013)

    Suneel,

    No i did not try to rebuild the indexes. As i explained before i just shrunk the .mdf and space gets released.

    You're pretty well screwed then because, except for...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 4:25 pm

    #1673904

  • RE: Cursor or Temp Files?

    Pending a reply, if the answer to my question is "Yes", then the code can be greatly simplified (change the * to the column names you desire and add any...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 4:13 pm

    #1673899

  • RE: Cursor or Temp Files?

    Gillian_Pappas2002 (12/16/2013)

    Hi There.

    Yes, there can be other statuses, but I am just looking for each customer order that may have 1 to n customer order lines, and that the line...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 3:38 pm

    #1673895

  • RE: Cursor or Temp Files?

    Status = 'O' means "Open"???

    Status = 'C' means "Closed"???

    Are there any other statuses than just 'O' or 'C'????

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 2:02 pm

    #1673867

  • RE: Online table partitioning

    nadersam (12/16/2013)

    Hi Jeff,

    Thanks for the detailed explanation , i will have to examine that thoroughly.

    But based on that solution, doing the partitioning online directly on original table will cause a...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 1:49 pm

    #1673864

  • RE: Table join / pivoting question

    N_Muller (12/16/2013)

    You are correct. The query won't work without an aggregate. However, going back to my original question on the usage of sub-queries. So far I have...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 1:44 pm

    #1673861

  • RE: Nested CASE WHEN in SELECT

    ChrisM@Work (12/16/2013)

    Jeff Moden (12/13/2013)

    Sean Lange (12/13/2013)

    ChrisM@Work (12/13/2013)

    Sean Lange (12/13/2013)

    ChrisM@Work (12/13/2013)

    Sean Lange (12/12/2013)

    Yes David is on the right path here. A case expression has not bearing on the number of rows...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 12:25 pm

    #1673843

  • RE: Fusion-IO or Nimble?

    @SQLFRNDZ (12/16/2013)

    ofcourse., there is no where near comparision between 2 fusioio is pure flshbased and nimble is hybrid solution where it use flash only for caching and rest on traditional...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 12:22 pm

    #1673840

  • RE: The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

    In rather stark contrast to what other folks have suggested about the use of XML to pass parameters, I usually wince at the thought. Because of "Tag Bloat", I...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    December 16, 2013 at 12:13 pm

    #1673837

Viewing 15 posts - 25,126 through 25,140 (of 59,099 total)