Forum Replies Created

Viewing 15 posts - 4,576 through 4,590 (of 59,069 total)

  • Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

    I agree that a "Best Practice" to prevent recompiles would be to move the creation of the temp tables to the very beginning but that's not likely to make 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)

    September 24, 2021 at 6:49 pm

    #3932856

  • Reply To: How show only first friday of every month

    p.s.  I hate the double spacing this forum does with code.  It makes even well formatted code look like junk.

     

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

    September 24, 2021 at 6:37 pm

    #3932853

  • Reply To: How show only first friday of every month

    Over the years, and especially this last 18 months, it seems like the problem of calculating the Nth Occurrence of some weekday has come up over and over.  It always...

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

    September 24, 2021 at 6:34 pm

    #3932852

  • Reply To: How show only first friday of every month

    I tested it with a couple of different DATEFIRST settings.  It appears to work correctly now.

     

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

    September 24, 2021 at 6:16 pm

    #3932847

  • Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

    VoldemarG wrote:

    Thank you very much for the valuable feedback. So does my suggestion to add more data files to TempDb sound reasonable then?

    To me... no.  Even if you do 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)

    September 24, 2021 at 2:34 pm

    #3932747

  • Reply To: Wait type LATCH_EX [NESTING_TRANSACTION_FULL] - and blocking.

    Ya know... the very least you could do is run that code through a decent formatter to get proper indentation the help with readability.

    While I'm sure it's not the whole...

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

    September 24, 2021 at 2:30 pm

    #3932543

  • Reply To: How show only first friday of every month

    Steve Collins wrote:

    Jonathan AC Roberts wrote:

    I've amended your code. I think this should be a few times faster as it removes the need for a tally of 7 week days and just calculates...

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

    September 24, 2021 at 12:57 pm

    #3932494

  • Reply To: How show only first friday of every month

    Heh... one good test result is worth a thousand expert opinions.  😀

     

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

    September 24, 2021 at 6:18 am

    #3932424

  • Reply To: Script to find session running SQL text and kill session

    Ok.  So what in the code uniquely identifies that code and ONLY that code?  Which DB_ID does it run against?  What is the USER_ID the code from the front...

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

    September 24, 2021 at 12:06 am

    #3932376

  • Reply To: How show only first friday of every month

    ScottPletcher wrote:

    Sure, it's above; I posted it years ago, when this q was first asked.

    Actually I should adjust it again, you only need to calc the very first Friday, 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)

    September 23, 2021 at 10:25 pm

    #3932356

  • Reply To: Script to find session running SQL text and kill session

    Is it a stored procedure or ad hoc code 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)

    September 23, 2021 at 8:35 pm

    #3932338

  • Reply To: need help on query

    Heh... keeping with the spirit of the question... 😉

    Results;

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

    September 23, 2021 at 6:38 pm

    #3932328

  • Reply To: needing help casting varchar to decimal

    ZZartin wrote:

    Welp then start adding columns one by one until it breaks 🙂

    Good lesson on basic troubleshooting.  Sorry I almost screwed that all up with my post about desk checking.

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

    September 23, 2021 at 5:32 pm

    #3932295

  • Reply To: needing help casting varchar to decimal

    DaveBriCam wrote:

    I'm needing to convert some varchar figures to decimal for sums, but can't quite find an example that works... the second block of code just returns the list 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)

    September 23, 2021 at 4:54 pm

    #3932287

    • Viewing 15 posts - 4,576 through 4,590 (of 59,069 total)