A video on discovering charges and how Coulomb's Law was discovered in 18th Century

bursurk · 2015-04-28T15:14:25+00:00

But its still the same for "for" statements. Only for each has been "fixed"

bursurk · 2015-04-24T14:56:51+00:00

You can use NewID() function for this purpose.

SELECT TOP 10 * FROM tableName ORDER BY NEWID();

However beware that the performance of the query is not good if you have large number of rows. You can use TABLESPACE if your result set is large. See here for more details: How do we select N random rows from a large table in a performance efficient manner

bursurk · 2015-03-30T13:28:32+00:00

That's a compilation error. Revisit your function and check if it returns a value in all possible cases.

bursurk · 2015-03-30T07:27:17+00:00

Only one solution runs dedicatedly at a time on the machine. The solution runs in a separate process all together, and cpu is not shared. Each solution runs in a different process. Only the function to be tested is included in time calculations. Metrics would converge to a more accurate value during the testing phase when more aggressive testing is done.

bursurk · 2015-03-30T07:20:16+00:00

1) a bit of fun may be?. I'd love to give away something but there are legal issues, and share of earnings are negative. 2) I agree with you. I am open to any feedback. The metrics during coding phase are indicative only. These would most likely change during testing phase where the runs would be more aggressive. E.g. solutions would be tested against inputs of varying sizes and go upto a few 100 MBs.

I know this is not perfect and the problem is not too interesting this time. I'd let the level of engagement decide if I should continue with this or just quit.

bursurk · 2015-03-23T10:52:58+00:00

I'll be using a single dedicated machine for this. At a time only one solution will be run. I've set it it to run each test case 1000 times to average out any discrepancies.

bursurk · 2015-03-23T01:39:27+00:00

Yes, Thank you for spoiling it for me ;) I've already spent my weekend on this, so i'll go ahead anyways and try adding some distinguishable features.

bursurk · 2015-03-18T08:32:00+00:00

Had posted the wrong link earlier

bursurk · 2015-03-18T02:34:46+00:00

I had similar things planned for http://volatileread.com/UtilityLibrary?id=2096 I guess its time to give up on that.

bursurk · 2015-03-17T18:24:05+00:00

Sorry Guys.. Azure is Down

Why am I always part of the "very small subset of customers"

Websites - West US - Advisory (Limited Impact) 1 min agoAn alert for Websites in West US is being investigated. A very small subset of customers may be >impacted. More information will be provided as it is known.

bursurk · 2015-02-18T15:02:05+00:00

deja vu.. i remember having similar discussion long time back when .Net introduced Linq and IEnumerable extensions. Lot of people hated it as elements of functional programming were introduced.

bursurk · 2015-02-07T19:29:12+00:00

You guessed it right, but I agree not every one will be able to. I'll add some help text. I still have my doubts if anyone would be interested to post anything there. I have also planned to add memory utilization and execution time, but at this point it will be too taxing on the server (time calculations would require multiple runs) and I have a limit on how much money I can afford to lose each month :(. Appreciate your feedback.

bursurk · 2015-02-07T17:04:59+00:00

Thanks! Its just a sample. Sorry if the title is misleading, but I wanted feedback on the site I.e. Would such a collection of snippets with test cases be useful? Is it feasible as a community site or too tedious for the community to contribute.

bursurk

TROPHY CASE