beyondrelational.com

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.

TSQL Challenges


Subscribe By Email

Contact US

Pushing database changes needn't be hard work with SQL Compare

Top Winners

	leszek_g	232
	Stefan_G	176
	dishdy	106
	malpashaa	101
	Mark	86
View all

Winning Solutions

Here is the list of solutions that passed the Load Testing for TSQL Challenge 36 - Create a graph/Chart with TSQL. 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
1	Michael Lewis	2942	0	2639	2.7782	1	1	10	9	21
2	Leszek Gniadkowski	4562	182	2605	2.7462	4	3	9	7	23
3	Pawel Potasinski	34678	549	2140	2.5033	8	12	2	4	26
4	oleg zernov	3158	0	2702	2.8302	2	1	12	11	26
5	Michael Lewis	4564	184	2664	2.8212	5	5	11	10	31
6	leo ruzin	3165	0	2886	3.0966	3	1	14	16	34
7	Ramesh Saive	4564	184	2814	2.9180	5	5	13	13	36
8	Otto Csatari	45712	706	2380	2.5109	9	15	7	5	36
9	Stefan G	73217	1118	2134	2.2805	13	22	1	1	37
10	Stefan G	73215	1118	2140	2.3693	12	22	2	2	38
11	Michael Lewis	3158	0	2964	3.2968	2	1	18	19	40
12	leonid koyfman	46944	751	2199	2.8986	10	16	3	12	41
13	Michael Lewis	3165	0	3054	3.1564	3	1	19	18	41
14	leigh waldie	77997	1052	2255	2.4875	18	20	4	3	45
15	leigh waldie	77995	1051	2271	2.7722	17	19	5	8	49
16	leigh waldie	78356	1053	2299	2.5347	19	21	6	6	52
17	Powichrowski Marek	75867	1048	2895	3.0516	15	18	15	14	62
18	Powichrowski Marek	75861	1051	2901	3.0796	14	19	16	15	64
19	bert dehaes	50337	702	3185	3.4444	11	14	20	20	65
20	Powichrowski Marek	75870	1053	2886	3.1202	16	21	14	17	68
21	jonathan roberts	1471822	183	3376	3.6996	24	4	22	21	71
22	jonathan roberts	1471823	183	3366	3.7776	25	4	21	22	72
23	jonathan roberts	1471822	183	3460	3.7996	24	4	23	23	74
24	jonathan roberts	1471823	183	3484	3.9044	25	4	24	24	77
25	jonathan roberts	1471822	183	3491	3.9616	24	4	25	25	78
26	edgar ramirez	10886	183	6517	8.7813	6	4	33	37	80
27	leigh waldie	77997	1051	2539	10.3404	18	19	8	38	83
28	Lutz Mueller	2753894	339	4190	4.3560	27	8	28	26	89
29	meierruth michael	16915	160	12380	12.9913	7	2	40	40	89
30	david betteridge	2756080	309	4140	4.7337	29	7	27	28	91
31	tomas boixet	1855091	770	3538	3.7776	26	17	26	22	91
32	richard harper	2754128	339	4315	4.5573	28	8	29	27	92
33	doove	982337	492	4517	5.0083	22	11	30	30	93
34	Chris Kulisz	1053785	429	4789	5.2811	23	9	32	31	95
35	Daniel M	274420	2204	2954	6.5436	21	26	17	32	96
36	Lutz Mueller	3848437	443	4676	4.8833	30	10	31	29	100
37	phil dutton	212479	214	10564	37.0849	20	6	38	42	106
38	richard harper	4628386	677	7444	7.6888	31	13	35	33	112
39	Muhammad AlPasha	9106995	1507	7426	7.9081	34	24	34	35	127
40	Muhammad AlPasha	9106777	1507	7478	7.8534	33	24	36	34	127
41	slawomir swietoniowski	6366282	1215	8240	8.5743	32	23	37	36	128
42	Leszek Gniadkowski	14736232	1809	11796	12.3487	35	25	39	39	138
43	Leszek Gniadkowski	24863923	2725	18043	18.6851	36	27	41	41	145

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 Vista Home Premium Edition, English
Processor: Intel Core 2 Duo T7250, 2.0GHz, 800Mhz, 2M L2 Cache
Memory: 2 GB
System Type: 32 Bit Operating System
SQL Server Version: SQL Server 2008 R2

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