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 32 - Clean up phrases by removing noise words. 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	zhen luo	40156	0	362	0.7300	6	1	1	2	10
2	Stefan G	43688	0	405	0.7264	7	1	2	1	11
3	zhen luo	80235	0	761	1.1411	10	1	6	4	21
4	jimbob mcgee	122239	128	798	1.1467	13	6	7	5	31
5	kevin suchlicki	150406	146	761	1.1077	15	7	6	3	31
6	leigh waldie	180100	0	1038	1.1813	16	1	11	7	35
7	Muhammad AlPasha	24286	69	1376	1.8927	2	2	18	17	39
8	Muhammad AlPasha	23917	83	1341	1.8943	1	5	16	18	40
9	Muhammad AlPasha	32292	0	1422	1.9963	5	1	19	20	45
10	Mingjie Liu	89464	0	1347	1.7299	12	1	17	15	45
11	Michael Lewis	204890	288	801	1.1697	19	15	8	6	48
12	Mingjie Liu	88208	0	1494	1.9549	11	1	21	19	52
13	richard harper	183566	0	1563	1.7173	17	1	22	14	54
14	Vadim Berezniker	253572	281	942	1.4469	22	14	10	9	55
15	Geri Reshef	203245	191	1329	1.6937	18	10	15	13	56
16	Dalibor Margotic	28152	75	518	8.0591	4	3	3	46	56
17	richard harper	45821	0	536	6.7566	8	1	4	45	58
18	Dalibor Margotic	28146	81	574	8.3737	3	4	5	48	60
19	Vadim Berezniker	252888	281	1135	1.5723	21	14	14	12	61
20	leo ruzin	264677	304	1101	1.4791	23	17	12	10	62
21	Vadim Berezniker	267088	451	901	1.3099	24	22	9	8	63
22	kevan riley	280547	292	1110	1.5315	25	16	13	11	65
23	peter haines	347163	179	1428	1.8791	26	9	20	16	71
24	Kamen Angelov	523090	175	1762	2.2441	33	8	24	21	86
25	savosin sergey	204946	319	2277	2.6235	20	19	29	24	92
26	Alok Shahi	472375	256	2084	2.8524	30	11	25	27	93
27	Alok Shahi	472365	268	2099	2.7710	29	13	26	26	94
28	bret warnick	407124	432	1697	2.6328	27	21	23	25	96
29	Karin Nooteboom	130069	0	3422	3.8404	14	1	43	41	99
30	Karin Nooteboom	130069	0	3522	3.9690	14	1	44	42	101
31	shawn smith	480111	0	2980	3.0778	31	1	37	32	101
32	zhen luo	666375	268	2187	2.4651	41	13	27	22	103
33	zhen luo	666379	268	2268	2.5545	42	13	28	23	106
34	Pragnesh Patel	71089	0	7563	8.5047	9	1	48	49	107
35	erick bailey	577167	0	2932	3.1128	37	1	36	33	107
36	shawn smith	480176	0	3017	3.2814	32	1	39	35	107
37	Pulastya Mitra	426412	310	2330	2.9188	28	18	31	31	108
38	Pulastya Mitra	426412	310	2352	2.9156	28	18	32	30	108
39	erick bailey	577036	0	3329	3.5110	36	1	42	36	115
40	erick bailey	577869	0	3057	3.5736	38	1	40	38	117
41	zhen luo	722365	268	2617	2.8644	43	13	33	28	117
42	Michael Lewis	614010	876	2312	2.8696	40	27	30	29	126
43	karol kaim	597862	370	2683	3.2334	39	20	34	34	127
44	Karin Nooteboom	531745	754	2842	3.5490	35	25	35	37	132
45	Karin Nooteboom	531743	754	2992	3.5960	34	25	38	39	136
46	Serge Jacquemin	743985	258	3607	4.1346	44	12	45	43	144
47	mariano tribuj	841887	458	3207	3.6714	45	23	41	40	149
48	carlos benito	1047330	472	4361	5.0911	46	24	46	44	160
49	jenny ye	2092604	788	7132	8.1195	50	26	47	47	170
50	Akmal Hussain	1488231	1105	61854	63.3928	49	29	49	50	177
51	Akmal Hussain	1413097	994	80253	84.9213	47	28	51	52	178
52	Akmal Hussain	1488219	1117	62859	64.4115	48	30	50	51	179

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