Home › SQL Server Challenges › TSQL Challenges › TSQL Challenge 18

TSQL Challenge 18 - Performance Testing Results


Here is the list of solutions that passed the Load Testing. Here is the script used to generate the test data.

Author Reads Writes CPU Duration (Sec) Read Rank Write Rank CPU Rank Duration Rank Combined Rank
Muhammad AlPasha 11 0 118 0.3525 1 1 2 2 6
sam camargo 11 0 237 0.4344 1 1 4 5 11
erik eckhardt 126 0 162 0.9790 4 1 3 7 15
paul chang 41 0 349 1.1847 2 1 6 8 17
Muhammad AlPasha 2572 0 118 0.3727 14 1 2 3 20
roby hoye 251 0 892 1.2457 6 1 10 9 26
Dalibor Margotic 2823 2 452 0.8453 15 3 7 6 31
Simon Mendoza 432 0 1085 1.5041 8 1 15 11 35
fabien contaminard 752 0 1113 1.6807 9 1 17 13 40
oleg zernov 234 0 898 2.1341 5 1 11 23 40
david todd 2841 0 699 1.8094 16 1 8 19 44
Joel Ewald 3012 0 817 1.8082 18 1 9 18 46
david betteridge 2530 0 1369 1.7503 13 1 22 15 51
Justin Blanding 76218 0 1023 1.3130 28 1 13 10 52
jeff moden 5375 1 988 1.7847 21 2 12 17 52
Jens Weiermann 3754 0 1126 1.7619 19 1 18 16 54
leonid koyfman 46457 1 1048 1.5141 26 2 14 12 54
russell sanders 71 0 1541 2.4832 3 1 25 25 54
Randy Derby 1312 0 1450 2.1158 10 1 23 22 56
ramesh saive 1371 0 1522 2.6375 11 1 24 26 62
Mike DeFehr 97071 0 1269 1.7488 29 1 20 14 64
Randy Derby 6857 9 1154 1.8181 22 6 19 20 67
erik eckhardt 13761 49 1101 2.0490 24 7 16 21 68
shankaranand saguturu 331 0 3431 3.8192 7 1 31 32 71
leigh waldie 7361 0 1903 2.4528 23 1 27 24 75
kevin suchlicki 2935 0 2227 2.9082 17 1 29 29 76
Aleksey Shtepa 71150 2 1847 2.7630 27 3 26 27 83
parth patel 107430 2 1338 2.9536 30 3 21 30 84
fabien contaminard 287963 2 2149 2.9053 33 3 28 28 92
Jose Cruz 33647 0 7794 8.3566 25 1 33 34 93
Pragnesh Patel 287924 6 2496 3.0620 32 5 30 31 98
Seth Phelabaum 125153 0 21122 21.7436 31 1 34 35 101
par eriksson 470383 0 24176 25.4675 34 1 35 36 106
James Pua 1119879 905 7359 7.9287 37 10 32 33 112
Divya Agrawal 1077605 315 28772 29.6022 36 9 36 37 118
michael newell 1268263 226 182196 184.3781 38 8 37 38 121

Note that the challenges are 'always ON', which means that you can submit a solution at any time. You can submit a new solution even after the results are published. If your solution is disqualified due to one of the reasons given above, you can re-submit a new version of the challenge at any time.

Never submitted a solution? Or got a new/different version? Submit it