Performance concernce

Question

Post reply

Performance concernce

Eirikur Eiriksson

SSC Guru

Points: 182912

October 7, 2018 at 8:47 am

#377926

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%

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

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

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 1

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.

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)

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 2

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: 186127 More actions · Answer 3

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".

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

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

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 4

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" 😀
😎