Forum Replies Created

Viewing 15 posts - 43,756 through 43,770 (of 59,097 total)

  • RE: "tempdb" size -- 550GB!

    Heh... actually, now that I lookback at it, part of the problem was, indeed, an ORDER BY. It was actually a combination of both that killed our TempDB. ...

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

    May 16, 2009 at 5:18 pm

    #995918

  • RE: Eliminating Cursors

    Since the sproc that updates the sequence table is so very important to eliminating the cursors in other procs, the fact that it has to be super fast, and 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)

    May 15, 2009 at 9:41 pm

    #995807

  • RE: Eliminating Cursors

    Nah... "my mistrake"... it's ok.

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

    May 15, 2009 at 8:45 pm

    #995801

  • RE: Eliminating Cursors

    Jeff Moden (5/15/2009)

    Actually, I found a bug in spDBSys_GetTableRowKey_sproc... it will never produce an id of 000001...

    In fact, it never produces a new id of other than 000000 even though...

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

    May 15, 2009 at 7:54 pm

    #995795

  • RE: Eliminating Cursors

    Actually, I found a bug in spDBSys_GetTableRowKey_sproc... it will never produce an id of 000001...

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

    May 15, 2009 at 7:50 pm

    #995793

  • RE: Eliminating Cursors

    praveenvelumula (5/15/2009)

    Thanks for advice .. Jeff ,

    I will work on it .. I think i can do ....if not ...can i get back to you again ..........

    Praveen

    Absolutely....

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

    May 15, 2009 at 7:34 pm

    #995792

  • RE: Eliminating Cursors

    RBarryYoung (5/15/2009)

    Jeff Moden (5/15/2009)

    Praveen,

    What version of SQL Server are you using? 2k, 2k5, 2k8?

    Oops! I forgot to ask. Dang, I would have fallen hard on that one!

    Heh... "Must...

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

    May 15, 2009 at 7:22 pm

    #995789

  • RE: Eliminating Cursors

    praveenvelumula (5/15/2009)

    Hi Jeff Moden

    allowed to change spDBSys_GetTableRowKey_sproc ... not many dependencies ...

    Praveen

    Perfect. I didn't mean to post just a quote and we can't delete posts anymore. SO,...

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

    May 15, 2009 at 7:19 pm

    #995787

  • RE: Eliminating Cursors

    praveenvelumula (5/15/2009)

    I din't mean you to rewrite the store proceudre ... Just i need advice ..

    to replace the Cursor ...........which i need to implement for better performance

    i need...

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

    May 15, 2009 at 6:59 pm

    #995784

  • RE: Eliminating Cursors

    Sorry, Praveen... I have another question....

    Are you allowed to change spDBSys_GetTableRowKey_sproc so long as it doesn't break any 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)

    May 15, 2009 at 6:38 pm

    #995779

  • RE: Eliminating Cursors

    praveenvelumula (5/15/2009)

    Microsoft SQL Server 2000 - Enterprise Edition on Windows NT -Service Pack 1

    Thanks Praveen.

    The code has a sequence table in it instead of using identities... the way...

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

    May 15, 2009 at 6:25 pm

    #995777

  • RE: Eliminating Cursors

    Praveen,

    What version of SQL Server are you using? 2k, 2k5, 2k8?

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

    May 15, 2009 at 4:50 pm

    #995755

  • RE: "tempdb" size -- 550GB!

    Robert (5/15/2009)

    See if there is any kind of sort in execution plan. Cross join can produce a huge result, but not necessarily anything in tempdb.

    If you have an "order...

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

    May 15, 2009 at 8:17 am

    #995370

  • RE: "tempdb" size -- 550GB!

    Attila (5/15/2009)

    I'd recommend to run a trace, and look for autogrow events.

    Paralelly start a script which runs in every minutes, and writs out the inputbuffer of each spid>49, plus 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)

    May 15, 2009 at 8:14 am

    #995364

  • RE: Is a Temporary Table Really Necessary?

    alex (5/15/2009)

    > I am not fond of cursors and advocate doing anything possible to replace the cursor

    What do you gain by handling the looping yourself rather than just using 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)

    May 15, 2009 at 8:12 am

    #995362

Viewing 15 posts - 43,756 through 43,770 (of 59,097 total)