Forum Replies Created

Viewing 15 posts - 45,466 through 45,480 (of 59,101 total)

  • RE: What are the Party Plans?

    Heh... tell that to Rog Pike (aka Steve Dussin). 😛

    --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 28, 2009 at 12:24 pm

    #934083

  • RE: SQL or Oracle

    Well said. Thanks for taking the time.

    Yeah... I use that one, alot...

    "okay, how do I return a result set from a stored procedure?" I just love building...

    --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 28, 2009 at 12:23 pm

    #934082

  • RE: What are the Party Plans?

    Ok, Steve... to celebrate, you start loading us up with cookies? What's the deal with the ScreenCast.com session cookies that have suddenly started showing up?

    --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 28, 2009 at 12:11 pm

    #934078

  • RE: What are the Party Plans?

    John Dempsey (1/28/2009)

    ... first, I'd love a copy, so click on my name to the left and send me an email. I'll respond and then you can send me...

    --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 28, 2009 at 12:10 pm

    #934075

  • RE: Hidden RBAR: Triangular Joins

    David.Poole (1/28/2009)

    Why do the Britts always say 'Ten minutes Time'? Are there any other kind of Minutes?"

    A minute amount of time might be defined as ten minutes according 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 28, 2009 at 12:08 pm

    #934072

  • RE: Table Variables and performance

    Peso (1/28/2009)

    Jeff Moden (1/28/2009)

    Increase performance of queries that use deterministic computed columns.

    Persisted computed columns can also be indexed 🙂

    http://msdn.microsoft.com/en-us/library/ms189292(SQL.90).aspx

    Yep... found that out at the same time. That's because they're...

    --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 28, 2009 at 12:06 pm

    #934069

  • RE: Earning Credit

    Lynn Pettis (1/28/2009)

    And why do we have this problem, comes down to LEADERSHIP. Example, look at our politicians, and it doesn't matter if they are Federal, State, or Local...

    --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 28, 2009 at 12:04 pm

    #934068

  • RE: What are the Party Plans?

    John Dempsey (1/28/2009)

    ... first, I'd love a copy, so click on my name to the left and send me an email. I'll respond and then you can send me...

    --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 28, 2009 at 11:58 am

    #934063

  • RE: What are the Party Plans?

    Lynn Pettis (1/28/2009)

    Do you have a standard pork chop that can be used for the calculations? 😛

    Heh... I dunno... ask Celko... he's got standards for everything else. 😛

    --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 28, 2009 at 11:57 am

    #934060

  • RE: What are the Party Plans?

    Heh... yeah... I've been waiting for Steve to get "unbusy" so I can figure out a way to save all those PM's... I wanna keep 'em.

    --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 28, 2009 at 11:56 am

    #934057

  • RE: Training

    That's one of the best suggestions I've seen, so far... "make them script out everything". Can't tune the car if you never pop the hood. 😛

    --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 28, 2009 at 11:47 am

    #934053

  • RE: SQL or Oracle

    Steve Jones - Editor (1/28/2009)

    I guess we know why Jeff doesn't like Oracle.

    RBAR, RBAR, RBAR, RBAR, RBAR, lunch, RBAR, RBAR, RBAR, RBAR, ....

    You missed one on the right... gotta keep...

    --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 28, 2009 at 11:45 am

    #934051

  • RE: Update Performance

    I just inherited a couple of databases that use a huge amount of replication. Heh... try making a table change or copying a database to Dev sometime without disturbing...

    --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 28, 2009 at 11:41 am

    #934048

  • RE: Hierarchies in SQL

    Ah... so you're not a batch programmer. And that's the area of the code I was talking about. GUI programmers have all sorts of tools like Hibernate, etc,...

    --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 28, 2009 at 11:37 am

    #934044

  • RE: Earning Credit

    Heh... you want a real measure of how many people lie? Just conduct some interviews for "SQL Developer" and check the person's knowledge against what they claim on their...

    --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 28, 2009 at 11:31 am

    #934040

Viewing 15 posts - 45,466 through 45,480 (of 59,101 total)