Forum Replies Created

Viewing 15 posts - 42,076 through 42,090 (of 59,067 total)

  • RE: OPTION (Max Recursion)

    The problem with using recurrsion to solve hierarchies using the typical "Adjacency Model" of parent/child relationships is that you have to do it over and over and over 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 3, 2009 at 8:39 pm

    #1049195

  • RE: IF condition in CURSOR

    REVERSE? Nah... just wicked dyslexic this time of day. 😛

    --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 3, 2009 at 8:12 pm

    #1049189

  • RE: logsize

    luckysql.kinda (9/3/2009)

    This is quite impossible to assist w/o correct information. Members, please avoid this.

    -lk

    Heh... avoid what? He's already got his answer. 😉

    --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 3, 2009 at 7:45 pm

    #1049183

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (9/3/2009)

    hmmm - guess he didn't want to post his code

    does that mean he has learned how to research the issue and troubleshoot?

    He was probably using sp_Space used or some...

    --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 3, 2009 at 6:53 pm

    #1049171

  • RE: logsize

    charipg (9/3/2009)

    i got it...........

    i ran the dbcc updateusge...............then it resolved..........

    thanks................

    Cool. Thanks for the feedback. But, why did you erase your code? That was a part of 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)

    September 3, 2009 at 6:51 pm

    #1049170

  • RE: IF condition in CURSOR

    Bob Hovious (9/3/2009)

    Sudhanva,

    Please do not think for a moment that we are making fun of you personally. Obviously, those of us who volunteer to help others...

    --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 3, 2009 at 6:47 pm

    #1049169

  • RE: IF condition in CURSOR

    CirquedeSQLeil (9/3/2009)

    Paul White (9/3/2009)

    Just for completeness, this is also valid:

    -- Just to simulate some condition or other

    declare @v-2 int;

    set @v-2 = 2;

    -- Dear Lord, why am I using a cursor...

    --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 3, 2009 at 6:26 pm

    #1049165

  • RE: IF condition in CURSOR

    Grant Fritchey (9/3/2009)

    Bob Hovious (9/3/2009)

    I hope Jeff never sees this thread...

    You mean Cardinal Moden of the SQL Inquisition? :w00t::w00t::w00t:

    Torquemada wishes he had Jeff's skill with the pork chop.

    Heh......

    --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 3, 2009 at 6:21 pm

    #1049162

  • RE: IF condition in CURSOR

    Paul White (9/3/2009)

    Bob Hovious (9/3/2009)

    -- Dear Lord, why am I using a cursor here?

    Your penance is 10 Hail Mary's and 10 Our Father's.

    Go and sin...

    --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 3, 2009 at 6:13 pm

    #1049161

  • RE: If you weren't a DBA what would you be doing?

    Lynn Pettis (9/3/2009)

    Maybe be in IT Management.

    Odd that you should say that. I quit being the "Director of IT" for one company to become an "AppDev Manager" for another...

    --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 3, 2009 at 5:58 pm

    #1049156

  • RE: temp db size

    Ugh! Sorry George... I'm not so hot at finding the cause of a memory leak. If you monitor the memory in the Windows side of the server, you...

    --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 3, 2009 at 5:49 pm

    #1049154

  • RE: Putting all your data in one column of one table

    What was the failed project supposed to accomplish?

    --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 3, 2009 at 5:39 pm

    #1049151

  • RE: Remove leading zeros and add spaces at the end

    chris.fauvel (9/3/2009)

    if your skus are like

    00supra12-23

    0012-34

    00001234

    then casting to int will not work since 'supra' and '-' are not numeric.

    I precisely need to do the same thing , remove the leading...

    --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 3, 2009 at 5:32 pm

    #1049149

  • RE: Remove leading zeros and add spaces at the end

    Garadin (9/3/2009)

    Jeff anticipated this question 18 months ahead of time and it STILL didn't stop it :-D.

    BWAA-HAAA!!!! Ironically, the same thing happens at work!

    Man, thanks for both...

    --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 3, 2009 at 5:29 pm

    #1049148

  • RE: Putting all your data in one column of one table

    michael.welcome (9/3/2009)

    Update:

    The project was a huge failure as I expected.

    Heh... "So say we all." Thanks for the feedback. Most don't remember.

    Now that the patient has died, my question...

    --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 3, 2009 at 5:07 pm

    #1049139

Viewing 15 posts - 42,076 through 42,090 (of 59,067 total)