Forum Replies Created

Viewing 15 posts - 6,016 through 6,030 (of 59,089 total)

  • Reply To: Get Particular Date from a Month

    Steve Collins wrote:

    Jeff Moden wrote:

    Steve, if you're going to use the fnTally function, you need to tell people where to get it.  Since I use it so often, I just put...

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

    November 30, 2020 at 4:30 pm

    #3815210

  • Reply To: Get Particular Date from a Month

    I had to take down the previous post because I found a bug in the formula.  Looking for how to fix it.

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

    November 30, 2020 at 3:58 pm

    #3815194

  • Reply To: Get Particular Date from a Month

    Rock wrote:

    fnTally function is not available. Can you help me? - I'm intended to get Thursday of a month which is followed with 2nd Tuesday

    See above.

    Steve, if you're going 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)

    November 30, 2020 at 3:43 pm

    #3815189

  • Reply To: Get Particular Date from a Month

    Sorry... had to take down this post because I found a bug in the formula.

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

    November 30, 2020 at 3:41 pm

    #3815188

  • Reply To: Bad career advice from a 14 year old

    Kathi Kellenberger wrote:

    I think he came up with this from watching movies and TV shows. "Office Space" is one example of employees doing bad things to get back at the company.

    Yowch......

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

    November 30, 2020 at 2:50 pm

    #3815165

  • Reply To: Bad career advice from a 14 year old

    Gordon Feeney wrote:

    25 years in IT. Laid off: 2. Brought back at 20 times the old salary: 0.

    20 Times the salary??? How much did that amount 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)

    November 30, 2020 at 2:49 pm

    #3815164

  • Reply To: Delivering Patches Quickly

    I'm thinking "Ok... Catch 22".  IMHO, the more quickly you move, the more likely you are to make a mistake and that's not limited to what most people consider 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)

    November 30, 2020 at 1:48 am

    #3814986

  • Reply To: The TUF File

    Great question, Steve.  I have to admit that I had to look this one up.  Now I know what my next task will be... determine the ramifications of that file. ...

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

    November 30, 2020 at 1:19 am

    #3814984

  • Reply To: Tempdb increasing crazily

    The things you mention don't typically cause the crazy increase you speak of.  And I just told you a "good way" to find it so someone can fix it. 😉 ...

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

    November 30, 2020 at 1:08 am

    #3814982

  • Reply To: Practice SQL querying with dates and aggregations

    ScottPletcher wrote:

    Frankly, you're still totally missing the point of q, thus your qs are misdirected.  Performance does not matter here, since the company you're interviewing for is a commercial business,...

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

    November 30, 2020 at 12:58 am

    #3814981

  • Reply To: Rebuild vs Reorganize

    SQLWinther wrote:

    I totally agree with you that a lot of half full pages is bad for disk storage, memory consumption and reading a lot of extra pages due to 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)

    November 29, 2020 at 10:39 pm

    #3814956

    • Viewing 15 posts - 6,016 through 6,030 (of 59,089 total)