Forum Replies Created

Viewing 15 posts - 25,696 through 25,710 (of 59,099 total)

  • RE: Beginner, Expert, or Both?

    Bhuvnesh (10/8/2013)

    Jeff Moden (10/8/2013)

    That's a HUGE problem with most employers and recruiters. They ask people to rate themselves. How can an honest person who rates themselves as 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)

    October 8, 2013 at 3:23 pm

    #1656928

  • RE: Filter Countries, States and Cities which in same row in one table.

    Bhuvnesh (10/8/2013)

    ChrisM@Work (10/8/2013)

    SELECT * FROM TABLE WHERE countryid = @country

    SELECT * FROM TABLE WHERE countryid = @country AND stateID = @stateid

    SELECT * FROM TABLE WHERE countryid = @country AND stateID...

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

    October 8, 2013 at 8:29 am

    #1656764

  • RE: Removing Duplicates

    Short, sweet, to the point with great examples and good simple explanations. Very nicely done, Mr. Krzywicki.

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

    October 8, 2013 at 8:23 am

    #1656761

  • RE: Beginner, Expert, or Both?

    chris_masiero (10/6/2013)

    I really don't know if being an expert is even required for 95% of jobs.

    Correct... but I'm thinking that they expect someone who's applying for a job that involves...

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

    October 8, 2013 at 7:55 am

    #1656743

  • RE: Beginner, Expert, or Both?

    Gary Varga (10/7/2013)

    simon.crick (10/7/2013)

    Cadavre (10/7/2013)

    simon.crick (10/7/2013)

    I will probably get shot down again for saying this, but I believe people should stick to core technology and basic tecnhiques unless there 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)

    October 8, 2013 at 7:43 am

    #1656736

  • RE: Beginner, Expert, or Both?

    Cadavre (10/7/2013)

    simon.crick (10/7/2013)

    I will probably get shot down again for saying this, but I believe people should stick to core technology and basic tecnhiques unless there is a very good...

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

    October 8, 2013 at 7:34 am

    #1656731

  • RE: Beginner, Expert, or Both?

    Gary Varga (10/7/2013)

    Of course, the editorial is spot on. So many people do not bother to find out the "why" either like SQL being set based, the ordering 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)

    October 8, 2013 at 7:02 am

    #1656712

  • RE: Beginner, Expert, or Both?

    Steve Jones - SSC Editor (10/7/2013)

    simon.crick (10/7/2013)

    Cadavre (10/7/2013)

    simon.crick (10/7/2013)

    I will probably get shot down again for saying this, but I believe people should stick to core technology and basic tecnhiques...

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

    October 8, 2013 at 6:50 am

    #1656709

  • RE: Qourum disk running low on disk space

    GilaMonster (10/8/2013)

    Jeff Moden (10/8/2013)

    Heh... that's likely why things have been such a problem in the past. Thanks, Gail. I wasn't going to get involved in the problem but...

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

    October 8, 2013 at 6:22 am

    #1656700

  • RE: single quotes

    Kurt W. Zimmerman (10/7/2013)

    I'm not a big fan of dynamic SQL but others before me were.

    I'm a big fan for a couple of reasons...

    1. A lot of front-end developers...

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

    October 8, 2013 at 6:13 am

    #1656695

  • RE: single quotes

    dwain.c (10/7/2013)

    Unfortunately, if it gets too long there are limitations on what can display in the Messages pane (4000 characters I think).

    So don't do that anymore. 😉 I got...

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

    October 8, 2013 at 5:40 am

    #1656682

  • RE: Generate and send report via email in PDF format which method better

    Thanks, Amit. Please let us know how it works out for you. As a bit of a sidebar, I'm sometimes a little amazed at how tightly some folks...

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

    October 8, 2013 at 4:38 am

    #1656670

  • RE: Qourum disk running low on disk space

    GilaMonster (10/7/2013)

    Jeff Moden (10/7/2013)

    our NetOps guys are apparently using the quorum drive to transfer data to our warm DR site.

    Oh my, that is horrid cluster design. Nothing but nothing should...

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

    October 8, 2013 at 4:32 am

    #1656668

  • RE: Qourum disk running low on disk space

    GilaMonster (10/7/2013)

    Jeff Moden (10/7/2013)

    GilaMonster (10/7/2013)

    Jeff Moden (10/5/2013)

    I have a similar problem that turns out to be some rather inefficient code that truncates several very large tables and reloads ALL of...

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

    October 7, 2013 at 4:31 pm

    #1656566

  • RE: Qourum disk running low on disk space

    GilaMonster (10/7/2013)

    Jeff Moden (10/5/2013)

    I have a similar problem that turns out to be some rather inefficient code that truncates several very large tables and reloads ALL of the data from...

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

    October 7, 2013 at 4:15 pm

    #1656561

Viewing 15 posts - 25,696 through 25,710 (of 59,099 total)