Are the posted questions getting worse?

  • Jeff Moden wrote:

    I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". πŸ˜€

    Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"

    😎

    Still think of deadlocks as an ailment, no healthy measures will ever apply.

  • Jeff Moden wrote:

    I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". πŸ˜€

    Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"

    😎

    Still think of deadlocks as an ailment, no healthy measures will ever apply.

  • Eirikur Eiriksson wrote:

    Jeff Moden wrote:

    I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". πŸ˜€

    Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"

    😎

    Still think of deadlocks as an ailment, no healthy measures will ever apply.

    Right there with you brother.

     

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Grant Fritchey wrote:

    Eirikur Eiriksson wrote:

    Jeff Moden wrote:

    I have a saying that I borrowed from the Submarine Service about things like that... "Don't worry about the fire... the flooding will put it out". πŸ˜€

    Same as the English saying "Take care of the pennies and the pounds will take care of themselves", "take care of the deadlocks and the transactions will take care of themselves"

    😎

    Still think of deadlocks as an ailment, no healthy measures will ever apply.

    Right there with you brother.

    The interesting thing is that in the current environment, we are facing millions of transactions per second, which makes one ponder on transactional latency!!

    😎

    Only a handful of years ago, I was very proud of 30-50K transactions per second on my systems.

    We are now not in the space of milliseconds, only takes a few micro seconds to clog the system.

  • I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them that was all we had, or as Scotty would say, She's giving you all she's got". Since we had about 10,000 people in the company and they were running dozens of queries to populate and update things on the home page, set to the default for everyone by group policy, wasn't much I could do.

    I was actually proud my database did so well.

  • Steve Jones - SSC Editor wrote:

    I had a SQL Server 2000 system that got to 25k transactions/sec when we turned on the intranet. The intranet was too slow that day, and I told them that was all we had, or as Scotty would say, She's giving you all she's got". Since we had about 10,000 people in the company and they were running dozens of queries to populate and update things on the home page, set to the default for everyone by group policy, wasn't much I could do.

    I was actually proud my database did so well.

    This brings back memories....

    😎

    Back in the days of SQL Server 7.0, I had a cluster (Wolfpack) as a back end for my web hosting service, every website launch made the cluster rattle. We had a request cache to reduce the load on the databases and often saw 15-20K t/s whilst the cache was initially populated. Ended up writing a pre-load service that scraped the websites for any links or possible users' interactions that would enter or alter the content of the cache. After enabling the pre-load service, we hardly saw any spikes on the databases.

  • Jeff Moden wrote:

    I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know the version you ran it on and post the results?Β  Thanks for the help, folks.

     SELECT  A = 2147483647/1000
    ,B = 2147483648/1000
    ;

    2022-09-08 15_52_41-SQLServer_Jeff_20220908.csv - Excel

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution πŸ˜€

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • This was removed by the editor as SPAM

  • Johan Bijnens wrote:

    Jeff Moden wrote:

    I'm having an issue on 2016 and 2017... If you have 2019 or any version prior to 2016, would you run the following code, please, and let me know the version you ran it on and post the results?Β  Thanks for the help, folks.

     SELECT  A = 2147483647/1000
    ,B = 2147483648/1000
    ;

    2022-09-08 15_52_41-SQLServer_Jeff_20220908.csv - Excel

    That pretty much cinches it.Β  Thanks, Johan.

    --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)
    Intro to Tally Tables and Functions

  • What’s happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.

    Is that site dead now or is Redgate phasing it out as I see it’s link here in the menu has also gone.

  • Ant-Green wrote:

    What’s happening with ASK SSC at the moment, I keep reporting a lot of spam topics but no one is removing them.

    Is that site dead now or is Redgate phasing it out as I see it’s link here in the menu has also gone.

    While the link in the menu might be gone, there's still a large "icon" in the lower right of the page if you scroll down to 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)
    Intro to Tally Tables and Functions

  • Removed what's probably an inappropriate rant based on extreme frustration.

    --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)
    Intro to Tally Tables and Functions

  • Dataminds Belgium 10/11 oktober was great

  • Jo Pattyn wrote:

    Dataminds Belgium 10/11 oktober was great

    100% agreement

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Sorry I missed it. I loved the event in 2021. Was in Boston last weekend and heading to NY today, so no time to come over and remain married.

Viewing 15 posts - 66,046 through 66,060 (of 66,076 total)

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