Performance concernce

  • Eirikur Eiriksson

    SSC Guru

    Points: 182343

    Just ran through a handful of test harnesses, not impressed, vNext is more like vLast
    😎

    Versions/difference 2017 2019 Difference
    Duplicate-records_TEST_HARNESS.sql 7851299 9171973 116.82%
    PreGroupingTestHarness.sql 3719983 4463291 119.98%
    Running-total-over-partition-order_Test_Harness.sql 27630524 32891528 119.04%
    Test_harness_eomonth_03.sql 45612996 45450928 99.64%
    Test_harness_datefromparts_SQLQuery24.sql 6069343 6676009 110.00%
    Return-last-amount-larger-than-0_test_harness_02.sql 2232925 2619093 117.29%
  • Jeff Moden

    SSC Guru

    Points: 993892

    Eirikur Eiriksson - Sunday, October 7, 2018 8:47 AM

    vNext is more like vLast
    😎

    Ok, Eirikur... you owe me a new monitor AND keyboard.  I blew a mouth full of coffee out of my nose on that one. πŸ˜€

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. πŸ˜‰

    Helpful Links:
    How to post code problems

  • Eirikur Eiriksson

    SSC Guru

    Points: 182343

    Jeff Moden - Sunday, October 7, 2018 10:27 AM

    Eirikur Eiriksson - Sunday, October 7, 2018 8:47 AM

    vNext is more like vLast
    😎

    Ok, Eirikur... you owe me a new monitor AND keyboard.  I blew a mouth full of coffee out of my nose on that one. πŸ˜€

    So that would be your normal 4 inch monitor and a three button child keyboard (yes,no don't know)?
     πŸ˜Ž

  • ChrisM@Work

    SSC Guru

    Points: 186040

    Eirikur Eiriksson - Sunday, October 7, 2018 8:47 AM

    Just ran through a handful of test harnesses, not impressed, vNext is more like vLast
    😎

    Versions/difference 2017 2019 Difference
    Duplicate-records_TEST_HARNESS.sql 7851299 9171973 116.82%
    PreGroupingTestHarness.sql 3719983 4463291 119.98%
    Running-total-over-partition-order_Test_Harness.sql 27630524 32891528 119.04%
    Test_harness_eomonth_03.sql 45612996 45450928 99.64%
    Test_harness_datefromparts_SQLQuery24.sql 6069343 6676009 110.00%
    Return-last-amount-larger-than-0_test_harness_02.sql 2232925 2619093 117.29%

    It's designed for the next gen of (128 bit) CPU's.
    For 64bit CPU's you have a server-wide setting - "Halfbit".

    [font="Arial"]β€œWrite the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw[/font]


    For fast, accurate and documented assistance in answering your questions, please read this article[/url].
    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]
    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
    [url

  • Eirikur Eiriksson

    SSC Guru

    Points: 182343

    ChrisM@Work - Monday, October 8, 2018 3:16 AM

    Eirikur Eiriksson - Sunday, October 7, 2018 8:47 AM

    Just ran through a handful of test harnesses, not impressed, vNext is more like vLast
    😎

    Versions/difference 2017 2019 Difference
    Duplicate-records_TEST_HARNESS.sql 7851299 9171973 116.82%
    PreGroupingTestHarness.sql 3719983 4463291 119.98%
    Running-total-over-partition-order_Test_Harness.sql 27630524 32891528 119.04%
    Test_harness_eomonth_03.sql 45612996 45450928 99.64%
    Test_harness_datefromparts_SQLQuery24.sql 6069343 6676009 110.00%
    Return-last-amount-larger-than-0_test_harness_02.sql 2232925 2619093 117.29%

    It's designed for the next gen of (128 bit) CPU's.
    For 64bit CPU's you have a server-wide setting - "Halfbit".

    I must be a "Halfwit", cannot find the "Halfbit" πŸ˜€
    😎

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

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