Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 59,067 total)

  • Reply To: To Proc or Not to Proc – Building SSRS Reports

    You know what I'm going to say, Phil.  SSRS is... an application.  You already know the rest.

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

    June 18, 2022 at 7:42 pm

    #4051530

  • Reply To: Datefirst format

    Thanks for the code modifications, Steve.  I'll take a deeper dive than just looking at it.  Nice to see someone actually test both out a bit.

    In the past, I've shyed...

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

    June 18, 2022 at 6:07 pm

    #4051510

  • Reply To: Datefirst format

    Steve Collins wrote:

    LearnSQL wrote:

    Any suggestions or thoughts.

    The function seems to generate the correct calendar.  Nicely done Jeff 🙂

    select * from dbo.CalendarByDateFirst('20211201', '20220131', 7);

    LearnSQL wrote:

    Thanks a lot Jeff for...

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

    June 17, 2022 at 7:55 pm

    #4051145

  • Reply To: Datefirst format

    As a bit of a sidebar, man!... The supposed SQL Format for the code windows is absolutely horrible! 🙁  I wish they'd do something about 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)

    June 17, 2022 at 7:49 pm

    #4051143

  • Reply To: Datefirst format

    Here's Rev 02 with a shedload more documentation in the flower box and 3 extra columns that seem useful to me.  I think I may turn this into an article...

    • This reply was modified 3 years, 12 months ago by Jeff Moden. Reason: Added warning to header

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

    June 17, 2022 at 7:46 pm

    #4051142

  • Reply To: Index FillFactor

    Bruin wrote:

    Thanks Jeff,,

    I have been using the formula:

    if ($Average_Fragmentation -gt 40.00) { Write-Host -ForegroundColor Red "$Index_Name is more than 40% fragmented and will be rebuilt."; $index.Rebuild(); Write-Host -ForegroundColor Green...

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

    June 17, 2022 at 1:53 am

    #4050706

    • Viewing 15 posts - 3,301 through 3,315 (of 59,067 total)