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 29 - Reorganize sales data by sales amount. 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	Dalibor Margotic	315	0	140	0.3548	3	1	1	5	10
2	Jesse Roberge	315	0	168	0.3256	3	1	5	1	10
3	Jesse Roberge	315	0	156	0.3508	3	1	2	4	10
4	mark cowne	315	0	165	0.3496	3	1	4	3	11
5	david betteridge	315	0	162	0.3704	3	1	3	6	13
6	kevin suchlicki	315	0	187	0.3494	3	1	9	2	15
7	Muhammad AlPasha	121	0	184	0.3882	1	1	8	9	19
8	nimesh shah	315	0	168	0.4138	3	1	5	12	21
9	seamus brady	315	0	180	0.3996	3	1	7	10	21
10	Constantin makogon	315	0	190	0.3780	3	1	10	7	21
11	Leszek Gniadkowski	315	0	180	0.4050	3	1	7	11	22
12	Muhammad AlPasha	315	0	199	0.3808	3	1	12	8	24
13	tomas boixet	315	0	174	0.4292	3	1	6	19	29
14	Leszek Gniadkowski	315	0	190	0.4286	3	1	10	18	32
15	peter frissen	315	0	218	0.4200	3	1	15	16	35
16	Gyan Koju	315	0	187	0.4572	3	1	9	22	35
17	Anders Nielsen	315	0	231	0.4196	3	1	18	15	37
18	Ryan Randall	315	0	184	0.4892	3	1	8	26	38
19	Akmal Hussain	315	0	249	0.4262	3	1	22	17	43
20	jagat patel	305	0	237	0.4520	2	1	19	21	43
21	leonid koyfman	121	0	256	0.4430	1	1	24	20	46
22	tapan bhatt	473	0	212	0.4884	10	1	14	25	50
23	christoph domnanovits	423	0	227	0.4976	8	1	17	29	55
24	mark cowne	423	0	221	0.5120	8	1	16	32	57
25	Michael Lewis	422	0	196	0.5780	7	1	11	39	58
26	mark cowne	423	0	227	0.5120	8	1	17	33	59
27	mark cowne	422	0	205	0.5758	7	1	13	38	59
28	meierruth michael	21102	91	252	0.4150	20	4	23	14	61
29	Leszek Gniadkowski	399	0	237	0.5342	5	1	19	36	61
30	shubin nikolay	21115	90	249	0.4142	23	3	22	13	61
31	bret warnick	333	0	336	0.5070	4	1	30	30	65
32	mike olund	471	0	258	0.5088	9	1	25	31	66
33	Mario Puskaric	21100	92	240	0.4608	19	5	20	23	67
34	seamus brady	411	0	277	0.5694	6	1	27	37	71
35	Pragnesh Patel	423	0	284	0.5334	8	1	28	35	72
36	jagat patel	21096	91	271	0.4668	18	4	26	24	72
37	Soren Kongstad	21100	92	243	0.4896	19	5	21	27	72
38	Hans Stuer	21107	92	252	0.4900	22	5	23	28	78
39	shawn martin	909	0	305	0.5804	12	1	29	40	82
40	Fanor Ponce	993	0	355	0.7758	13	1	32	42	88
41	fery enne	1073	0	371	0.6300	14	1	33	41	89
42	andriy zabavskyy	21103	90	340	0.5286	21	3	31	34	89
43	Leszek Gniadkowski	869	0	505	0.9693	11	1	34	44	90
44	Leszek Gniadkowski	1157	0	580	1.0415	16	1	37	45	99
45	mike olund	1109	0	539	1.1597	15	1	36	47	99
46	mike olund	1181	0	524	1.0471	17	1	35	46	99
47	Karin Nooteboom	47231	0	617	0.8298	24	1	38	43	106
48	bret warnick	338244	1	780	1.2909	25	2	39	48	114

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