Facebook Twitter Sign in | Join
Getting Started with ASP.NET MVC - Part 6: ASP.NET MVC and Entity Framework
First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

Here is the list of solutions that passed the Load Testing for TSQL Challenge 42 – Transform rows to columns with dynamic positioning. Here is the script used to generate the test data.

#AuthorReadsWritesCPUDuration (Sec)Read RankWrite RankCPU RankDuration RankCombined Rank
1mark cowne157306310.653921115
2mark cowne157306370.654321227
3Stefan G157306590.6756214310
4Pulastya Mitra157306530.6768213410
5Leszek Gniadkowski157306650.6820215513
6meierruth michael157308500.8697216615
7Lutz Mueller157308750.8807217717
8nimesh shah157309620.9822218819
9Ramesh Saive157109620.9955118919
10Scot Hauder1573010311.045921121025
11leigh waldie1577010241.061931101226
12leigh waldie1577010221.06373191326
13leigh waldie1577010251.055731111126
14Marcos Kirchner1573010311.067621121530
15dave repton1573010501.066221131430
16bert dehaes1577010621.093631141735
17dave repton1577010681.092231151635
18Joshua Duewer1577010931.118231161838
19Leszek Gniadkowski1573011401.172521171939
20leonid koyfman1573011531.178121182041
21Rahul Verma1573012241.241021212246
22Jim Lin1577012151.242031202347
23Dalibor Margotic1573012251.246321222449
24phil dutton1573012251.252321222550
25Siva Prasad Vundavalli3141011621.1848111192152
26Luke Marshall1573012811.308021232753
27Mike Scalise1573014711.485521252856
28leo ruzin1571017781.782211283161
29Otto Csatari1571018871.919311303365
30Szymon Wojcik1577018211.856231293265
31Carlos Klapp7829012931.3064141242665
32Anil Soman7829016691.7107141262970
33Carlos Klapp7829017181.7418141273072
34Guenter Tschech1577020062.043931343876
35Razvan Socol1571021342.177511354077
36Jason Covey3141019622.0076111313477
37Jason Covey3141019712.0178111323579
38Jason Covey3141020032.0244111333681
39Zbigniew Borowski7829020062.0312141343786
40Scott Sutch2802025562.651871384288
41Leszek Gniadkowski2610028062.908441404489
42Simon Wadsworth3135022032.2320101374189
43Dalibor Margotic2802026562.751071394390
44Laura Cassidy27753021432.1676151363991
45Dalibor Margotic2658029282.995761414593
46Benjamin Taylor2627040564.195151424694
47Benjamin Taylor2856042154.325281434799
48Benjamin Taylor3036043904.5787914448102
49pranay sane53849046404.65451614549111
50albert ulmer6269076977.73811314751112
51pranay sane53849046624.68361614650113
52Amartha Dutta626501733717.40211214852113
53Amartha Dutta626501739717.42991214953115

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

Test Machine Configuration
  • OS: Microsoft Windows Server 2003, Enterprise Edition
  • Processor: Intel(R) Xeon(R) CPU E3110 @3.00GHz
  • Memory: 4 GB
  • System Type: 32 Bit Operating System
  • SQL Server Version: SQL Server 2008 RTM
Not Happy with the configuration or Test Data?
  • Give us access to a SQL Server instance running on a server with a different configuration and we can run the tests there.
  • Suggest alternate load testing data and we will be happy to redo the testing with your data.
  • Contact us

Copyright © Beyondrelational.com