Forum Replies Created

Viewing 15 posts - 45,481 through 45,495 (of 59,101 total)

  • RE: Trying to rewrite RBAR Function

    Ah... sorry about that... just add the lower case a-z back into the pattern in both spots.

    --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:29 am

    #934038

  • RE: What are the Party Plans?

    Michael Valentine Jones (1/28/2009)

    Matt Miller (1/28/2009)

    Michael Valentine Jones (1/27/2009)

    Going by 120 yards by 50 yards for an American football field (100 yards goal-to-goal plus 2x10 yard end zones by 50...

    --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:21 am

    #934032

  • RE: What are the Party Plans?

    John Dempsey (1/28/2009)

    Jeff Moden (1/21/2009)

    BWAA-HAA!!! I'll bring some eats... everyone like pork chops? 😛

    Steve Jones - Editor (1/22/2009)

    Lots of shirts likely to be leaving my basement soon!

    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)

    January 28, 2009 at 11:18 am

    #934030

  • RE: Trying to rewrite RBAR Function

    Lynn Pettis (1/28/2009)

    smunson (1/28/2009)

    Jeff,

    I have a relatively fresh installation of SQL 2005 Developer Edition, but your object in the following:

    .

    .

    .

    FROM Master.dbo.SysColumns t1 CROSS JOIN Master.dbo.SysColumns t2

    .

    .

    .

    doesn't exist on my server....

    --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:12 am

    #934026

  • RE: Earning Credit

    Steve Jones - Editor (1/28/2009)

    Jeff,

    Send it in. I'll at least give you an opinion, which is probably to stick it out there.

    Ummm... ok... I wouldn't be surprised if you said...

    --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:06 am

    #934018

  • RE: Earning Credit

    R L Reid (1/28/2009)

    When the folks doing the copying don't know the material well enough, the quality of what's copied can't be assured. Oddly this doesn't seem...

    --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 10:51 am

    #933998

  • RE: SMO vs SQL-DMO

    David McKinney (1/28/2009)

    Ninja's_RGR'us (1/28/2009)

    I was subscribed to this thread as well. And Jeff only replied to it because someone else posted another solution a couple minutes before him.

    When replying...

    --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 10:39 am

    #933988

  • RE: SMO vs SQL-DMO

    David McKinney (1/28/2009)

    He does say 'scripting operations' so I'm assuming he's talking about scripting objects etc..

    Is this what you're referring to, Jeff, when you talk about a T-SQL solution? ...

    --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 10:36 am

    #933986

  • RE: Table Variables and performance

    Michael Earl (10/8/2008)

    A table variable usually has to get pretty big before it spills over into TempDB.

    Just because the table name shows up in TempDB, doesn't mean that's where 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 28, 2009 at 10:28 am

    #933976

  • RE: Table Variables and performance

    Peso (10/13/2008)

    There you go! 🙂

    I learn something new every day...

    Heh... me too! That's why I hang around here so much. Today, I learned that there was such 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)

    January 28, 2009 at 10:23 am

    #933966

  • RE: What are the Party Plans?

    Steve Jones - Editor (1/28/2009)

    Yep, wasn't sure it would cross over night or today, and I still have images coming for the stuff, so announcement tomorrow.

    thanks everyone!!

    I think we're purchasing...

    --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 10:17 am

    #933963

  • RE: Hierarchies in SQL

    danielk1 (1/28/2009)

    I just feel, to tie myself to a DB structure type, like you mentioned using the hierarchcical ID, might limit my application's portability - say, if I want 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 10:10 am

    #933954

  • RE: Hierarchies in SQL

    ventsislav.mladenov (1/28/2009)

    Or you could use CLR store procedures which are very fast in execution and sometimes are faster than T-SQL.

    http://blog.vmladenov.com/?p=197

    Since you say "Now the fact is that the C# store...

    --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 10:02 am

    #933952

  • RE: Trying to rewrite RBAR Function

    Your last couple of sentences put that all together very nicely! I was aware of being able to put indexes on calculated columns, but didn't know you could make...

    --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 9:54 am

    #933946

  • RE: Trying to rewrite RBAR Function

    Ok... the reason why the Tally table looses is because of the extra calculation I had to put into the STUFF function to make the Tally table appear to count...

    --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 9:50 am

    #933943

Viewing 15 posts - 45,481 through 45,495 (of 59,101 total)