Forum Replies Created

Viewing 15 posts - 44,371 through 44,385 (of 59,097 total)

  • RE: Timed Triggers.. Possible ???

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

    April 4, 2009 at 9:25 am

    #972066

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

    Very good info on the Ansi-Padding and how CHAR columns respond, John...

    It's still not going to help for this problem, though, because empty strings (in T-SQL) are never empty in...

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

    #972064

  • RE: steve's dataphore

    steve dassin (4/1/2009)

    relationaland thinks sql is such a blivet why is it the backend for dataphor?

    It's the backend for a lot. Why isn't DataPhor the new backend? ;-)...

    --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 8:41 am

    #972058

  • RE: Performance of user defined functions

    Torres (4/3/2009)

    Thanks for the replies.

    The udf is a Table-valued Function, returning a dataset.

    I could add the RegionID as a parameter to the udf, but was wondering if that was necessary.

    Thanks.

    Torres

    I'd...

    --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 8:30 am

    #972057

  • RE: How to return a "start of group" column?

    Florian Reischl (4/4/2009)

    No, it's not a typo, it's just an example. I've just been to lazy for the "ALL" 😀 but I will try thinking on it in future.

    More coffee,...

    --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 8:27 am

    #972055

  • RE: The T-SQL Paradigm

    And, you're absolutely correct... some simple additions such as TRUNC(Date) would make life a bit easier. On the other hand, I hope to never see DECODE in T-SQL...

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

    #972052

  • RE: The T-SQL Paradigm

    Paul Hunter (4/3/2009)

    Hmmm... It seems the harder Jeff works the luckier he gets... could there be a connection?

    Heh.... You're not qualified to make such a statement because you don't...

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

    #972051

  • RE: T-Sql rant

    Thanks Steve... but you missed the other part... why does anyone think it matters so much? SQL is what it is... use it or not. You're trying 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)

    April 4, 2009 at 7:46 am

    #972050

  • RE: T-Sql rant

    steve dassin (4/3/2009)

    The sql community has ignored someone whose spent a lifetime trying to explain why there's nothing relational about sql.

    Heh... a lot of us got it the first time......

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

    #971951

  • RE: The T-SQL Paradigm

    dphillips (4/3/2009)

    First, you're just plain lucky.

    I think you'll find that there's just a little bit more to it than that. 😉

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

    #971924

  • RE: The T-SQL Paradigm

    dphillips (4/3/2009)

    I am a Legos guy. I know what each piece does. I know how to make and/or mod the parts if needed. But in the end, when it 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)

    April 3, 2009 at 5:18 pm

    #971921

  • RE: Are the posted questions getting worse?

    Greg Edwards (4/3/2009)

    Jeff -

    I'm going to start investing in pork futures.

    Friends in Iowa tell me the demand has seen a huge spike lately.

    This couple be like penny stocks - we...

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

    #971900

  • RE: Are the posted questions getting worse?

    GSquared (4/3/2009)

    Jeff, I have to admit, I have a terrible tendency to give up on something/someone, then have some thought I just can't hold back on the subject, and feel...

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

    #971896

  • RE: The T-SQL Paradigm

    David Walker (4/3/2009)

    Leaving out CLR functions, which are often not recommended for performance reasons:

    Must be the nuances of the language... I've been able to beat virtually every CLR with 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)

    April 3, 2009 at 2:07 pm

    #971844

  • RE: The T-SQL Paradigm

    BWAA-HAAA!!! I've heard about a bazillion C programmers ask why T-SQL can't be more like C. My question would be, why can't C be more like T-SQL? ...

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

    #971799

Viewing 15 posts - 44,371 through 44,385 (of 59,097 total)