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 38 - Calculate SQL Stars awarded to the Winners of TSQL Challenges. 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	Stefan G	271861	1237	1242	1.3707	2	16	1	1	20
2	Stefan G	196756	1651	7316	7.4936	1	19	7	7	34
3	leonid koyfman	3891330	1387	4711	4.8295	16	17	2	2	37
4	plotczyk michal	4422183	996	5516	5.7053	20	11	3	3	37
5	yunus simjee	4347092	1007	5609	5.8089	19	12	4	4	39
6	bret warnick	4867026	1091	7285	7.4546	21	15	6	6	48
7	Muhammad AlPasha	3690795	18029	6387	6.5850	15	31	5	5	56
8	Powichrowski Marek	5702123	1938	7438	7.6746	23	20	8	8	59
9	plotczyk michal	6599190	1487	8034	8.3779	26	18	10	10	64
10	Sibu TP	5824879	2524	8027	8.2169	24	22	9	9	64
11	Muhammad AlPasha	2895818	94232	9528	9.8018	12	47	12	11	82
12	Mingjie Liu	3991830	680	13784	14.1434	18	5	29	30	82
13	tomas boixet	6928925	18701	9512	9.8504	27	35	11	12	85
14	Muhammad AlPasha	2665745	95383	9999	10.2774	11	48	15	14	88
15	pulastya mitra	7007702	18844	9750	10.0284	29	37	13	13	92
16	Biju Nair	336875	10	62531	63.2858	3	1	45	46	95
17	bret warnick	7260549	2146	10271	10.4536	35	21	20	20	96
18	Antony Clark	1846715	916	55327	56.1472	5	9	42	42	98
19	Powichrowski Marek	7222647	18694	10065	10.3652	32	33	17	16	98
20	Gopinath Srirangan	2003703	907	55270	56.4812	8	6	41	43	98
21	Powichrowski Marek	7222988	18696	9996	10.3932	33	34	14	17	98
22	albert ulmer	5084890	1029	20598	21.1322	22	14	31	32	99
23	Powichrowski Marek	7226014	18701	10049	10.3406	34	35	16	15	100
24	eric nordlander	7219915	18671	10071	10.4520	31	32	19	19	101
25	Muhammad AlPasha	3255593	105189	10495	10.8128	14	50	21	22	107
26	Guenter Tschech	7274885	18707	10068	10.4204	36	36	18	18	108
27	erick bailey	5865248	2598	20043	20.6158	25	24	30	31	110
28	Antony Clark	2083711	913	82652	83.9302	9	8	47	48	112
29	jonathan roberts	7136676	21473	10495	10.7926	30	41	21	21	113
30	Krzysztof Lukowski	3897791	7067	25434	25.8951	17	28	34	35	114
31	Debdutta Nath	8417634	2915	10901	11.2842	40	25	24	25	114
32	Muhammad AlPasha	3247571	107160	11222	11.5545	13	51	25	26	115
33	Mingjie Liu	8781991	14	32186	32.7131	41	2	36	37	116
34	phil dutton	2087768	922	83120	84.7112	10	10	48	49	117
35	vicky singh	1846703	910	111125	112.5456	4	7	53	54	118
36	Andrey Gurinov	1846719	910	109553	111.4166	6	7	52	53	118
37	piti champeethong	8966827	3371	11912	12.3287	43	26	26	27	122
38	Aash Ram	6955634	1015	44204	45.1614	28	13	40	41	122
39	dennis lahmer	7607251	19007	10539	10.9084	38	39	22	23	122
40	jonathan roberts	7298515	21457	10674	10.9864	37	40	23	24	124
41	slawomir swietoniowski	1895067	9912	57611	58.6914	7	29	44	45	125
42	buda renato	8400715	18963	12292	12.5431	39	38	27	28	132
43	Devlin Hostler	8954062	2565	28248	28.9477	42	23	35	36	136
44	meierruth michael	29940816	635	55870	56.7530	53	3	43	44	143
45	bret warnick	10164197	58188	13032	13.2944	44	45	28	29	146
46	ashish gilhotra	13032388	26654	21072	21.7090	46	43	32	33	154
47	ashish gilhotra	13670346	27116	22124	22.5539	47	44	33	34	158
48	Leszek Gniadkowski	29197600	673	107459	109.4929	52	4	51	52	159
49	kevan riley	32025365	10881	39777	40.7669	54	30	39	40	163
50	Leszek Gniadkowski	25926675	673	151530	154.4196	51	4	54	55	164
51	Kevin Wu	10746468	99334	33776	34.8118	45	49	37	38	169
52	ashish gilhotra	16245304	66113	36869	37.4309	48	46	38	39	171
53	carlos benito	47513551	6211	73616	74.8109	55	27	46	47	175
54	dave repton	25419466	22874	101952	103.6195	50	42	50	51	193
55	Brian Durkin	22658881	175707	85067	85.9201	49	52	49	50	200
56	Muhammad AlPasha	66296449	486620	175238	179.1742	56	53	55	56	220
57	Muhammad AlPasha	67629810	513173	175897	179.6201	57	54	56	57	224

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