Forum Replies Created

Viewing 15 posts - 38,356 through 38,370 (of 59,098 total)

  • RE: sql dba resume

    The two things that I've found work really well on a resume are...

    A properly written objective... leave out the gooey stuff about how well you play with others and how...

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

    May 17, 2010 at 12:23 pm

    #1168404

  • RE: Updating 20M rows takes 5 hours

    Every system has a "tipping point" and it's rather unpredictable. Try updating just a million rows... it'll probably take something much less than a minute. Then try two...

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

    May 17, 2010 at 12:14 pm

    #1168400

  • RE: How to obtain week by week plus YTD totals

    simflex-897410 (5/17/2010)

    I am still struggling with the dynamic date. I will continue to try to figure it out.

    It isn't making sense to me. I am more of .net programmer 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)

    May 17, 2010 at 12:03 pm

    #1168393

  • RE: Precious Ideas

    Steve Jones - Editor (5/17/2010)

    I have worked with encryption and the arguments you give just don't make sense.

    If the software is unencrypted, you can easily run a hash against 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)

    May 17, 2010 at 9:54 am

    #1168333

  • RE: More, More, More

    EdVassie (5/17/2010)

    The one thing I would really like to see on SqlServerCentral is some way to mark an answer as good quality.

    I've seen such a thing on many "forums"...

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

    May 17, 2010 at 7:51 am

    #1168264

  • RE: Precious Ideas

    Kristian Ask (5/17/2010)

    For some reason, when reading the previous two posts I come to think of KISS. Seems like there is a tendency to make things overly complicated....

    Heh... and what...

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

    May 17, 2010 at 7:38 am

    #1168258

  • RE: Code generation

    Gianluca Sartori (5/17/2010)

    No problem here, Jeff!

    Your miracle is in my "cool sql stuff" folder, it won't get wasted!

    Heh... thanks, Gianluca. :blush:

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

    May 17, 2010 at 7:24 am

    #1168252

  • RE: Reduce the time spent on cross process communication

    neelsmail (5/17/2010)

    > do the 10,000 calls occur sequentially by one user or will they occur in parallel by more than one user?

    It may or may not depending on how many...

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

    May 17, 2010 at 7:23 am

    #1168251

  • RE: How to Convert Rows into Columns?

    Sahasam (5/17/2010)

    I did this in some other way.

    I created 3 functions and used those 3 funcions in the procedure directly by passing a parameter.

    First Function Which represents first column, i...

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

    May 17, 2010 at 7:07 am

    #1168239

  • RE: Comparing two rows in one table for changes in column

    I almost forgot... I've not tested Magoo's code, but just eye-balling it tells me it's probably going to be faster than all the self-join stuff I did. Since his...

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

    May 16, 2010 at 10:29 pm

    #1168105

  • RE: Comparing two rows in one table for changes in column

    Dobermann (5/16/2010)

    Jeff, I think I have gremlins in my computer... today when I added all my other joins to your code, it worked perfectly right out the gate. 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)

    May 16, 2010 at 10:19 pm

    #1168102

  • RE: Precious Ideas

    Oh no... I understand what you're talking about and I wasn't talking about theft of "ideas"... I was talking about outright theft of code (just like plagarism) to actually start...

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

    May 16, 2010 at 7:34 pm

    #1168094

  • RE: Code generation

    Heh... typical... OP wants a "miracle" and gets it. OP is never heard from again especially if you ask a favor in return. Oh well... next problem,...

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

    May 16, 2010 at 6:57 pm

    #1168092

  • RE: Code generation

    Adam Gojdas (5/13/2010)

    Cool stuff! I definitely learn a lot from Jeff's code. So thanks Jeff!

    It might be nice to change this very slightly:

    ,

    cteCharacters AS

    ( --=== This 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)

    May 16, 2010 at 6:45 pm

    #1168089

  • RE: Code generation

    mister.magoo (5/13/2010)

    Brilliant answer Jeff!

    I like this a lot, but every time I see NEWID() used like this it just makes me yearn for a decent random number generator so 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)

    May 16, 2010 at 6:39 pm

    #1168088

Viewing 15 posts - 38,356 through 38,370 (of 59,098 total)