Forum Replies Created

Viewing 15 posts - 46,126 through 46,140 (of 59,101 total)

  • RE: The Year in Review 2008

    Hadn't thought of it THAT way... heh... it sounds like a pretty good place to build a straw man doc, as well. 🙂

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

    January 5, 2009 at 8:02 pm

    #921544

  • RE: User Defined Function: order by won't work

    tfifield (1/4/2009)

    For what it's worth, the only way I've been able to get around the ORDER BY problem in derived tables and functions is to create an index and then...

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

    January 5, 2009 at 7:44 pm

    #921538

  • RE: Cursors Be Gone!

    Matt Whitfield (1/5/2009)

    not afaik but Jeff will correct me if there is a way to do it.

    You can create a unique constraint across multiple columns, but not a clustered index...

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

    January 5, 2009 at 7:32 pm

    #921537

  • RE: Cursors Be Gone!

    david.rowland (1/4/2009)

    I think they {cursors} still have their place

    Ok, I'm all for opposing opinions because that's what makes good discussions and I learn something from every single discussion.

    Now, for the...

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

    January 5, 2009 at 7:25 pm

    #921534

  • RE: Cursors Be Gone!

    TheSQLGuru (1/4/2009)

    Bottom line: DO NOT USE THIS UPDATE @var ... TRICK UNLESS YOU a) DON'T CARE ABOUT GETTING INCORRECT RESULTS OR b) YOU ARE VERY KNOWLEDGEABLE ABOUT YOUR SYSTEM,...

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

    January 5, 2009 at 7:18 pm

    #921532

  • RE: Cursors Be Gone!

    I've gotta agree with Kevin on the table variable thing. The only reason I'll ever use table variables is if I have to make a temporary storage area to...

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

    January 5, 2009 at 7:05 pm

    #921531

  • RE: Cursors Be Gone!

    TheSQLGuru (1/4/2009)

    Jeff Moden (1/3/2009)

    jacroberts (1/3/2009)

    This method sounds like a bit of a dark art.

    Oh, it absolutely is... one that is condemned by many "experts" who have yet to get it...

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

    January 5, 2009 at 6:47 pm

    #921528

  • RE: Help with SQl Statement ranking

    Michael Artz (1/4/2009)

    Forgive me...have to ask....

    I presume you concur it's a bad design idea to include the "percentile" information in the table?

    Heh... why? You planning on changing the results...

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

    January 4, 2009 at 9:17 am

    #920864

  • RE: Help with SQl Statement ranking

    What would you have for such a score? If there are 10 people in a race, isn't first through the 10th place sufficient? That "Partition By" part 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)

    January 3, 2009 at 10:18 pm

    #920823

  • RE: Source Control in SQL Server

    We use a ticketing system to both assign problems and track code. Ticket number in the file name or a folder name works wonders. Each object is stored...

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

    January 3, 2009 at 9:17 pm

    #920820

  • RE: Select statements included within a function cannot return data to a client

    And, seriously... if you want better answers faster and maybe even tested answers, post the data for future requests using the techniques found in the link in my signature below.

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

    January 3, 2009 at 9:02 pm

    #920817

  • RE: Search on a smalldatetime column

    Just to be absolutely correct... the DATEADD portion of the code should be the following...

    DATEADD(DD, 1, @specific_day)

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

    January 3, 2009 at 8:54 pm

    #920815

  • RE: like operator problem

    Now that you have several different methods for separating the data, my recommendation would be to normalize the table so you don't have to use any of those methods in...

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

    January 3, 2009 at 8:51 pm

    #920814

  • RE: Help with SQl Statement ranking

    With the information given, the short answer would be to take a look at ROW_NUMBER OVER (PARTITION BY... ORDER BY...) in Books Online. You could also do similar with...

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

    January 3, 2009 at 8:49 pm

    #920813

  • RE: Cursors Be Gone!

    hfxDBA (12/24/2008)

    I've always resisted responding to articles with obvious errors simply not wanting to get into arguments about which way to skin the cat. I hope people who read...

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

    January 3, 2009 at 8:22 pm

    #920810

Viewing 15 posts - 46,126 through 46,140 (of 59,101 total)