Forum Replies Created

Viewing 15 posts - 48,346 through 48,360 (of 59,095 total)

  • RE: A Lack of SQL

    Heh... time to pull all my NASDAQ stock... 😛

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

    September 13, 2008 at 3:21 pm

    #871458

  • RE: Developers' access to dev SQL Server

    It actually doesn't matter what privs you give Developers on the Dev box... if you allow Developers to design their own tables and you don't have any coding standards and...

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

    September 13, 2008 at 3:17 pm

    #871457

  • RE: "For each table in database......"

    True enough... my question is why you'd want to do anything to all tables from outside the database when the database does it so 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)

    September 13, 2008 at 2:35 pm

    #871453

  • RE: Splitting a String in SQL - Help Please!

    Funny you should bring that article up... 🙂

    http://www.sqlservercentral.com/articles/TSQL/62867/

    But the desired method to do the split depends on my question... Is this a single parameter being split or does a whole...

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

    September 13, 2008 at 2:32 pm

    #871451

  • RE: loading a table parallely

    Bulk Insert will load up to 5.1 million rows of 20 columns each in 60 seconds flat. How many rows are you trying to import?

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

    September 13, 2008 at 2:23 pm

    #871450

  • RE: functions

    To clarify what Sergiy just said... all those functions that do "lookups" are just an insideous way of doing correlated subqueries which are RBAR on sterioids. RBAR can appear...

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

    September 13, 2008 at 2:21 pm

    #871449

  • RE: Customer Ranking

    After looking at this, I think the folks that recommended "NTile" are probably producing the more accurate answer. Are you absolutely positive you want to do that running total...

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

    September 13, 2008 at 2:00 pm

    #871448

  • RE: Customer Ranking

    pps... I'm not sure that you need the likes of a running total on this... I'm still looking...

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

    September 13, 2008 at 1:41 pm

    #871446

  • RE: Customer Ranking

    Ps... I didn't change any of the smiley faces to ")"... you'll need to do that, I just copied your code.

    Also, if you don't mind... you said it took 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)

    September 13, 2008 at 1:32 pm

    #871445

  • RE: Customer Ranking

    upperbognor (9/12/2008)

    I'm wondering if there is a faster solution possibly....

    It's currently taking the longest calculating the running total due to the cross join.

    Yes, there is a much faster method and,...

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

    September 13, 2008 at 1:29 pm

    #871444

  • RE: "For each table in database......"

    Heh... ACK!... cursors... while loops... sp_MSForEachTable which contains one of the most ineffecient general purpose cursors there will ever be...

    Yeaup... they all work. But, in SQL Server 2005, there...

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

    September 13, 2008 at 12:14 pm

    #871442

  • RE: Adding +1 to MAX()

    rsheppick (9/12/2008)

    Well, I have to manipulate them somewhat.

    Not quite the business reason we were hoping for. 😉 There are several solutions depending on the requirements of a valid business...

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

    September 13, 2008 at 11:52 am

    #871441

  • RE: Splitting a String in SQL - Help Please!

    greig.burrows (9/12/2008)

    Hi there! I'm struggling to split a string.. hope somebody can help me. Here's a description of my problem:

    Ugh... UDF's... While Loops... all good ways to slow your code...

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

    September 13, 2008 at 11:26 am

    #871439

  • RE: Are there equivalents in Oracle Sql ?

    jmuldoon (9/10/2008)

    My experience seems to be the opposite of popular opinion out there. Things that seem to be simple and trivial in TSQL end up to be amazingly verbose and...

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

    September 13, 2008 at 11:14 am

    #871435

  • RE: Calculating Work Days

    dulanjan (9/12/2008)

    jeff...i came up with an interesting dilemma with your function.

    if the start date is a saturday and the end date is a sunday it returns a -1.

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

    September 13, 2008 at 10:34 am

    #871433

Viewing 15 posts - 48,346 through 48,360 (of 59,095 total)