Home › SQL Server Challenges › TSQL Challenges › TSQL Challenge 21

TSQL Challenge 21 - 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 43064 183 658 1.2269 4 2 1 1 8
Michael Lewis 30276 0 2302 2.5291 2 1 4 4 11
leonid koyfman 74179 331 1669 2.0505 6 5 2 2 15
regan wick 74294 344 2520 2.9584 7 6 5 6 24
Mueller Lutz 106964 361 2932 3.1634 11 9 7 7 34
Mueller Lutz 106964 361 2935 3.2602 11 9 8 8 36
Muhammad AlPasha 147881 590 1834 2.3431 12 18 3 3 36
Arumugam Thiraviam 74296 347 3647 4.0908 8 7 12 14 41
Pavel Krticka 855007 313 2992 3.6790 17 4 10 10 41
Philippe Pimenta 858019 513 2633 2.9190 19 15 6 5 45
Muhammad AlPasha 855570 351 3307 3.8554 18 8 11 11 48
Mueller Lutz 791202 391 3700 4.0152 15 10 13 12 50
Mueller Lutz 791197 398 3728 4.0306 14 11 14 13 52
meierruth michael 67084 400 5407 5.9261 5 12 19 19 55
leigh waldie 30282 0 9188 9.9854 3 1 27 27 58
Ruchay Sohawan 1141004 624 2948 3.3996 26 20 9 9 64
Pavel Krticka 858455 541 4187 4.7095 21 16 16 16 69
jose chama 1132987 508 4982 5.3383 24 14 17 17 72
Pragnesh Patel 1139878 590 3741 4.2996 25 18 15 15 73
Pavel Krticka 854793 299 10386 11.5159 16 3 29 29 77
leszek gniadkowski 1082968 492 6289 7.4106 23 13 22 23 81
Jason Whitney 1020438 608 6393 7.2716 22 19 23 22 86
andrey myasnikov 1139878 590 6439 7.0882 25 18 24 21 88
jeremy giaco 1269140 1054 5032 5.5937 28 27 18 18 91
eugene paradizov 1202960 631 6146 7.9681 27 21 21 24 93
Jesse Roberge 270 0 54697 58.3735 1 1 47 47 96
hakan stenstrom 2122087 1400 6074 7.0344 31 29 20 20 100
Pavel Krticka 858453 541 12274 13.0487 20 16 33 32 101
regan wick 90788 696 19634 20.6274 9 23 37 37 106
regan wick 90793 694 20901 21.7460 10 22 38 38 108
gustavo gonzalez 2837828 972 7709 9.3855 34 26 25 25 110
Jesse Roberge 350274 0 177622 189.5522 13 1 48 48 110
leszek gniadkowski 2164197 858 11247 12.9293 32 24 31 31 118
jagat patel 2527629 1421 9874 10.8450 33 30 28 28 119
erick bailey 3212137 1969 8658 9.6336 37 31 26 26 120
leszek gniadkowski 2164197 859 11513 13.0581 32 25 32 33 122
tomas boixet 1931969 2642 11116 11.7001 30 32 30 30 122
Anders Nielsen 3189303 696 18161 19.4181 36 23 36 36 131
regan wick 1368188 1317 23400 24.5486 29 28 39 39 135
paul chang 3106351 546 43178 45.8266 35 17 46 46 144
mutka michal 15007133 4388 16427 17.5176 43 37 34 34 148
michal mutka 15007143 4377 16479 17.6118 44 36 35 35 150
tomas boixet 4615336 5958 24292 26.3569 38 39 40 40 157
leszek gniadkowski 7694439 3360 28055 31.5520 40 34 42 42 158
leszek gniadkowski 7694439 3359 28073 32.3110 40 33 43 43 159
tomas boixet 4615374 5930 24354 26.6431 39 38 41 41 159
jeff schwartzmann 9795209 4169 34738 38.8198 42 35 45 45 167
Serge Jacquemin 9635332 22483 31481 33.9475 41 40 44 44 169

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