Forum Replies Created

Viewing 15 posts - 44,356 through 44,370 (of 59,101 total)

  • RE: Timed Triggers.. Possible ???

    Jack Corbett (4/6/2009)

    Jeff Moden (4/4/2009)

    Heh... I agree... probably an inteview question.

    I believe the question actually asks "how would you write a trigger that executed another stored procedure but only at...

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

    April 6, 2009 at 8:22 am

    #972560

  • RE: The T-SQL Paradigm

    Aaron N. Cutshall (4/6/2009)

    Jeff Moden (4/6/2009) The first rule that many developers seem to omit is that the code actually has to work. 😉

    OK, you got me there!:-P However,...

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

    April 6, 2009 at 8:17 am

    #972555

  • RE: Duplicate Records using SQLCMD

    First, let me take nothing from the article. It's well written and clear. Well done.

    However, the following statement seems to destroy whatever utility was intended in the code...

    Note...

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

    April 6, 2009 at 8:01 am

    #972539

  • RE: Are the posted questions getting worse?

    GSquared (4/6/2009)

    I noticed that a lot of the pages here slowed down like crazy when the prettier code blocks were added in. There's a script that formats them, 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)

    April 6, 2009 at 7:36 am

    #972518

  • RE: Are the posted questions getting worse?

    Same here, Roy. Our thoughts are with 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)

    April 6, 2009 at 7:34 am

    #972516

  • RE: The T-SQL Paradigm

    Aaron N. Cutshall (4/6/2009)

    David Walker (4/3/2009)

    Although this is off the original topic, I still haven't seen a SQL statement that was easier to read with the aliases than without 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)

    April 6, 2009 at 7:11 am

    #972490

  • RE: The T-SQL Paradigm

    Manie Verster (4/6/2009)

    To get SQL to perform is what might make it look difficult. It's easy to write a query but to get the optimal performance out of that query...

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

    April 6, 2009 at 6:53 am

    #972478

  • RE: T-Sql rant

    steve dassin (4/6/2009)

    Sergiy (4/6/2009)

    steve dassin (4/5/2009)

    getting sql folks to get their head out of what is essentially a 'constant' (an sql table) and into something that is variable.

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

    April 6, 2009 at 6:48 am

    #972471

  • RE: T-Sql rant

    steve dassin (4/5/2009)

    I'm not trying to sell you anything. I'm trying to get you to go in for some trippy stuff 🙂

    Heh... it's some trippy stuff, alright. I've never...

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

    April 6, 2009 at 6:41 am

    #972467

  • RE: T-Sql rant

    Mike C (4/5/2009)

    Oracle is good about implementing new features and functionality really quickly... sometimes they even get their features out to market before the ISO standards updates are approved.

    That's...

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

    April 6, 2009 at 6:22 am

    #972451

  • RE: How to find the one_space string in a CHAR data type?

    Heh... ok... understood. And absolutely spot-on with the rest of what you said. Thanks, Paul. And good "meeting" 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)

    April 5, 2009 at 7:59 pm

    #972248

  • RE: How to find the one_space string in a CHAR data type?

    I stand corrected. Thanks for the code.

    I'd be curious to know why anyone would want to use the difference between an empty string and a sting of 1 or...

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

    April 5, 2009 at 11:12 am

    #972189

  • RE: T-Sql rant

    steve dassin (4/4/2009)

    Mike C (4/4/2009)

    Jeff Moden (4/4/2009)

    steve dassin (4/4/2009)

    C'mon do you really have something against parentheses?

    Actually, yeah. 😉

    Personally I hate those curly braces. Growl.

    C'mon you got something against the three...

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

    April 5, 2009 at 10:46 am

    #972179

  • RE: T-Sql rant

    steve dassin (4/4/2009)

    C'mon do you really have something against parentheses?

    Actually, yeah. 😉

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

    April 4, 2009 at 9:33 pm

    #972126

  • RE: How to find the one_space string in a CHAR data type?

    apat (4/4/2009)

    So, second row gives 1 as a result whereas there is actually no space between quotes. It should give 0....

    That's what I was saying... you cannot get what 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)

    April 4, 2009 at 9:18 pm

    #972125

Viewing 15 posts - 44,356 through 44,370 (of 59,101 total)