Forum Replies Created

Viewing 15 posts - 42,106 through 42,120 (of 59,102 total)

  • RE: Squeezing the DBA

    GSquared (9/3/2009)

    My ethics are more important to me than my paycheck.

    Ditto...

    I'll also add that my ethics and integrity are the reason why I have a paycheck.

    --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 10:05 pm

    #1049203

  • RE: Beginning T-SQL

    Sudeepta (9/3/2009)

    I have come with no programming background.

    Although that may make it a bit difficult for you, it may also provide an extreme advantage for you... you have no bad...

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

    #1049202

  • RE: Beginning T-SQL

    I'm probably going against the general grain here but I have a special name for "DBA's" who don't know T-SQL really, really well... "SysOp". My other name for them...

    --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 9:37 pm

    #1049201

  • RE: Converting from NVarchar to DateTime

    Heh... now I'm really going to tick you off... except when trying to convert from date formats that are in the basic form DD/MM/YYYY when the default date format 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 3, 2009 at 9:11 pm

    #1049198

  • RE: How to create this kind of Trigger?

    Damien (9/3/2009)

    Alright I will explain more of my issue on this task.

    First Im not allowed to modify the software that can do deletion of data in our SQL server. 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)

    September 3, 2009 at 8:47 pm

    #1049197

  • 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

Viewing 15 posts - 42,106 through 42,120 (of 59,102 total)