Home › SQL Server Challenges › TSQL Challenges › TSQL Challenge 19

TSQL Challenge 19 - Performance Testing Results

Sat, 05/08/2010 - 05:01 — jacob

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
Dave Ballantyne 44147 0 358 0.6736 2 1 2 3 8
Dave Ballantyne 45055 7 330 0.4930 3 7 1 1 12
Dave Ballantyne 45874 7 377 0.5678 4 7 3 2 16
Gyan Koju 34693 0 1322 1.4937 1 1 8 8 18
Muhammad AlPasha 73432 0 730 0.9651 10 1 4 6 21
Muhammad AlPasha 73483 0 739 0.9191 11 1 6 4 22
Muhammad Pasha 73428 4 733 0.9259 9 5 5 5 24
Muhammad AlPasha 81484 1 911 1.0861 15 2 7 7 31
Jesse Roberge 61767 0 1719 1.9519 6 1 12 12 31
Jesse Roberge 61766 1 1772 2.0347 5 2 13 14 34
mark cowne 70330 14 1398 1.6167 8 10 9 9 36
eric nordlander 100289 5 1584 1.7895 20 6 10 11 47
parth patel 91029 2 1778 1.9581 18 3 14 13 48
Randy Derby 79949 0 2427 2.6231 14 1 17 17 49
Muhammad AlPasha 113680 14 1594 1.7755 21 10 11 10 52
Randy Derby 79946 3 2430 2.6454 13 4 18 18 53
morten nilsen 78275 16 2171 2.4431 12 11 16 16 55
bret warnick 63672 8 4003 4.2496 7 8 21 22 58
Jesse Roberge 85508 2 2443 2.6726 17 3 19 19 58
Mueller Lutz 85314 10 4464 4.7261 16 9 26 26 77
Jose Cruz 200232 60 3057 3.4700 22 15 20 20 77
fabien contaminard 1508597 4356 1866 2.0669 29 24 15 15 83
Seth Phelabaum 288994 152 4068 4.2352 24 20 22 21 87
Karin Nooteboom 355194 174 4181 4.3700 25 23 23 23 94
Leszek Gniadkowski 97864 46 25434 25.8201 19 14 31 31 95
Karin Nooteboom 355199 169 4193 4.3997 26 22 24 24 96
Ryan Randall 270031 14 26623 26.9009 23 10 32 32 97
Karin Nooteboom 371590 164 4374 4.6285 27 21 25 25 98
Michael Lewis 3180673 137 5846 6.1095 30 18 27 27 102
Pragnesh Patel 5809801 141 6342 6.5384 31 19 28 28 106
Mueller Lutz 21674192 118 21706 22.0089 33 17 29 29 108
tomas boixet 620342 25 53508 53.9495 28 12 34 34 108
regan wick 23269970 141 22277 22.6447 34 19 30 30 113
robert cavill 13899853 41 57480 58.0287 32 13 35 35 115
rob farley 34778984 115 29331 29.7283 35 16 33 33 117

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