Forum Replies Created

Viewing 15 posts - 48,361 through 48,375 (of 59,102 total)

  • 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

  • RE: Local Temporary Tables and Table Variables

    Ummm... high IO and CPU isn't necessarily caused by either Table Variables or Temp Tables. It's HOW they are used. I think what you're going to find is...

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

    #871432

  • RE: Patindex

    S'ok... just proves one thing... memory is one of the best things you can do to speed up a machine. Thanks for the feedback, Remi.

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

    #871431

  • RE: Patindex

    Ninja's_RGR'us (9/12/2008)

    Holly shit... is the only way to describe those results!!!

    Heh... your surprise, Remi, is that your particular computer sucks at handling strings... the results you provided are WAY out...

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

    #871427

  • RE: I AM HAVING THIS UNIQUE AND STUPID SITUATION IN SSIS FROM MAINFRAME

    gyanendra.khadka (9/12/2008)

    Lynn, FInally Got IT. But for one FTP process I don't thing they would like to do it. ALso, on my side I only have one ssis packages 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)

    September 13, 2008 at 8:21 am

    #871425

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Thanks for the great feedback, Carla. If you want a bit more on splitting things, take a peek at the followup article below...

    http://www.sqlservercentral.com/articles/T-SQL/63003/

    --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 12, 2008 at 7:33 pm

    #871400

  • RE: Patindex

    By the way... if you actually take the time to run the code above, I think you'll be very surprised as some of the outcome.

    --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 12, 2008 at 7:26 pm

    #871399

  • RE: Patindex

    "LIKE" has gotten a pretty bad reputation just by word of mouth. Might be left overs from the early days of SQL. Glad to see some folks testing...

    --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 12, 2008 at 7:21 pm

    #871398

  • RE: killing old spids

    Fraggle (9/12/2008)

    Sorry to scare you there Jeff. 😀

    Dang... as luck would have it, I found a reason to actually nuke old spids... connection leaks. I recently started 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 12, 2008 at 5:01 pm

    #871390

Viewing 15 posts - 48,361 through 48,375 (of 59,102 total)