Post reply

Yearly Uptime of Four Nines

  • February 14, 2022 at 12:00 am

    #3969929

    Comments posted to this topic are about the item Yearly Uptime of Four Nines

  • February 14, 2022 at 3:19 pm

    #3983424

    When I first saw the question, I would have put good money on a selection of SQL-based solutions!

    I slapped this one together, but I'm sure there are better ways of doing it 🙂

    select MinutesOfDowntime = ((DATEDIFF(minute, GETUTCDATE(), DATEADD(year,1,GETUTCDATE()))) - ((DATEDIFF(minute, GETUTCDATE(), DATEADD(year,1,GETUTCDATE()))) * 0.9999))

  • February 14, 2022 at 5:50 pm

    #3983489

    Heh... plenty of time each week to do index maintenance, right?  😀 😀 😀

    After almost 25 years, I wish MS would finally study Peter Norton's works and write something much better than the God awful REORGANIZE, REBUILD, and SHRINK FILE "features".  They could all be rolled into one very effectively AND seriously reduce "segment fragmentation" to boot.

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

  • February 15, 2022 at 4:16 pm

    #3983949

    Failed to specific whether it's a leap year or not.

  • February 15, 2022 at 4:33 pm

    #3983973

    Could also be picky and say that 52.6 rounds to 53 minutes, not 52 minutes (and still not taking into account the variance for leap years; I think it is 52.7 minutes for a leap year, but open to better estimates....).

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply