« first day (958 days earlier)      last day (3357 days later) » 

14:02
@Malachi That answer actually looks quite good, to me!
I didn't want to give it the first upvote because I think it was well written, I wanted to make sure that it had sound reasoning as well. thank you @Phrancis
@Phrancis urk... that guy...
Seems like the key here is to educate the diamond mods then :) But seriously, 12% of 60 = only 7.2 questions that caused trouble in 90 days. That is not much at all! It means Code review would get 0,08 problematic questions per day from SO, or if you will, one problematic question per 12.5 days. How is that even a problem? On the other hand, Code review got 90% of questions that weren't off topic. I would guess this is where most of the new Code review users are coming from too. — Lundin 5 mins ago
@Vogel612 Those numbers sound off a bit, how did they come up with that?
Oh, those are just migrations. That's why.
anyone play star wars commander on Android?
Zak
Zak
I think this sums it up pretty succinctly
Stack Overflow gets 200x as many questions per day as CR. If even 1% are inappropriately migrated, our site becomes 2/3 crap overnight. — Zak 20 secs ago
14:11
@Vogel612 I'm trying to think of a way to derive some of this "dark figure" from SEDE... Cross-posted and otherwise "manually migrated" posts seem like a moving target though, since those posts would almost certainly have a different OwnerUserId, and likely a different title, and may or may not be closed on SO and/or CR
yeap. additionally remember there's flags you can't even query for...
Might be possible to come up with something though by using DisplayName instead of UserId, and try to match tags and posts creation date within a certain range (say a few hours)...
in David's hat store, 1 min ago, by Caleb Kleveter
I've got an idea for a secret hat next year (even if SE doesn't do it, I thought it was funny). A hat called "Skeet Shooter", you get it for anything that would cause a SE notification on Jon Skeet's phone.
Zak
Zak
Maybe search for posts with the same title by the same user on SO and CR?
can you guys upvote this please?
8
Q: "Next tag badge" panel score and answers counter discrepancy

Martin PrikrylOn the "Next tag badge" panel of my Stack Overflow profile for C# tag I see: 92/100 score 88/20 answers But when I open the "Select your next badge" panel, there's: 97/100 score 90/20 answers I'm not sure which on is correct. But I believe the both displays should show the ...

14:13
@Phrancis there should be a query that checks cross site...
I am having this issue right now, and found this post.
@Vogel612 Yeah checking cross-site is not too hard, just different database catalogs on SEDE methinks
I would add a bounty but I don't have much to spare on that site...lol
@Zak The title though is often one of the first things that gets edited from SO -> CR though
Zak
Zak
@Phrancis I guess we could just check for people posting "any" question on CR within X hours of posting on SO.
14:15
Could you search both post and comments for mentions of stackoverflow?
Zak
Zak
We'll get some coincidences, but we'll also miss some late migrations, so it might balance out pretty close to the true number.
@Zak That was kind of my thought as well. I'll try to come up with something
Either within a URL or as a phrase "I posted this on Stack Overflow"
@SuperBiasedMan It would be really slow, but yes you could
I just went into our other office
We have two inflatable kiddie pools full of beer cans
5
14:21
Now 3 hours after asking codereview.stackexchange.com/questions/114364/… should be closed.
2 more votes needed
oh, wait
"While lurking around in our software source" maybe its owned code
Isn't it still too stubby because we have no idea of the conditions this is used in?
Not really, its clear what is expected to be returned. If the passed in object is null or not a decimal return 0 otherwise the decimal.
Oh, I thought they were also asking for recommendations about whether or not return 0 was a good idea.
This is peculiar... and annoying
-- Code Review DB:    [StackExchange.Codereview]
-- Stack Overflow DB: [StackOverflow]

select top 10 * from [StackExchange.Codereview].dbo.Users
union all
select top 10 * from [StackOverflow].dbo.Posts;
--ERROR: All queries combined using a UNION, INTERSECT or EXCEPT operator
--must have an equal number of expressions in their target lists.
Oh shit. Duh
Of course I can't union Users and Posts, duh
*golfclap*
14:30
^^ deserved
1
Q: Golang: Bruteforce MD5 Password cracker

Federico PonziI just started learning GO, and i wanted to created a project to learn more about concurrency in go. I heard about go's lightweight threads so i wanted to give them a try. This program uses backtracking to bruteforce a list of passwords loaded from a file. It tries from password of length 2 and ...

Zak
Zak
Question, Is the fact that a question has remained closed for a long time sufficient justification to VTD?
is it salvageable in any way?
They eventually get deleted by the roomba anyway, don't they?
Unless it's mistakenly (in your opinion) upvoted
Zak
Zak
@Mat'sMug Don't know, just doing my daily voting in and I noticed a couple "[Closed]" tags on questions over a year old.
14:42
@Mast That was a literary reference. The correct response is "Spill it's blood."
0
Q: Optimize query linq into one for creating table.....(Please free)

Markus Werneri have this 2 tables: Ok. I'll insert my code here of this function for build string to send to client: using (DatabaseDataContext contestoDB = new DatabaseDataContext()) { Funzioni f = new Funzioni(); contestoDB.ObjectTrackingEnabled = false; ...

@Donald.McLean Poor Piggy :(
@EthanBierlein Don't be hyping that stuff in my face. We learned that lesson when Episode I came out.
@Vogel612 @Zak just came up with something useful (for a start), look at this query: Primary CR users who also have SO rep, ordered by combined rep
@SuperBiasedMan Seriously.
Zak
Zak
14:45
@Phrancis Almost half have 101 rep on both (so no activity, just the +100 joining bonus). Maybe strip them out?
@Zak Well yeah, I'll get around to that. But it's handy that there is a global AccountId that can be used to join user accounts across sites
Didn't know about that before, should be far more useful (and lot faster) than trying to match by name
Huh, funny. I just got my first yearling badge, but just on metaSO
@Phrancis Serious zombie down there.
IKR
Q is 2.5 years old, has had +100 bounty (that went to waste) during this time last year, another +100 bounty this year, finally got an answer!
Zak
Zak
15:00
yay! I can finally make edits
3
Woohoo!
Merry Winterbash @Heslacher!
Cool thanks @RubberDuck. Just have seen +200 !
Feel free to place another bounty ;-)
man, Programmers.SE is a mystery. I went to their chat, got confirmation that asking what I wanted to ask was ok, posted my question, got a bunch of answers. Question went hot, sitting at +9/-2......... with 4 close votes.
2
15:09
I wonder do they get a lot of close/reopen wars.
0
Q: Go database helper code

Dan CantirToday I've implemented a database helper in Go. I'm new in Go world so I just wanted someone with more experience to take a look and tell me what is good and especially, what is bad (and why, if possible). The code is below: package clinic import ( "fmt" "github.com/astaxie/beego/orm" ...

that's it, we need a user by the name of Johnny that reviews the tag.
Or another unnecessary programming language
another language, another fizzbuzz
@Mat'sMug shhhhhhhhh!
15:15
totally
15:30
@Donald.McLean Now now, George Lucas isn't directing it this time. It's also been getting very good reviews, so I'm hopeful. The lowest review I've seen so far was an 8.8/10 from IGN, and I'd venture to say that they really aren't qualified to review film.
0
Q: Run Time Error ( balancing parantheses)

PradeepThis is my code for checking the balance of parantheses. It works fine on my computer,but the online judge says a run-time error. What could possibly be causing this run-time error? #include <iostream> #include <string> #include <stack> using namespace std; bool balanced(string exp) { stack<...

@CaptainObvious interesting
@EthanBierlein don't they usually review games? are they qualified to review games?
A lot of game sites nowadays are just geek sites really.
So they'll dip into some films and TV.
@Mat'sMug Yes. I'd also say that they aren't qualified to review games either. They tend to give bad triple-A titles great reviews, even if they're awful games. I'm thinking that IGN is just a fake company paid by companies to give good reviews for their products.
"Works on my machine" when the intent is to make it "work on the online judge" sounds very very much like "my code isn't working as intended"... — Mat's Mug ♦ 6 secs ago
@Mat'sMug Since it's not compilation error and not wrong answer I expect my answer to be correct.In fact tested it against 20 test cases and works correctly. — Pradeep 34 secs ago
...what do we do with that one?
it's not wrong answer because the online judge doesn't get to run it to completion.... right?
15:37
Hey @Mat'sMug help me with a quick sanity check? This query is meant to look for cross-posts from SO->CR, it's obviously not complete (and some false positives are present) I just want a 2nd set of eyes to make sure I don't have a big flaw I overlooked
I asked for clarification:
@Pradeep Does it compile and run correctly on your machine, and just not the online tester? — Ethan Bierlein 53 secs ago
@EthanBierlein Yes.It Does.That's what made me curious. — Pradeep 28 secs ago
Alright, the code works. Now we just have to clean up the question a little.
Morning!
I still need to factor in shared tags and some other things, but for now I want to make sure my join conditions and filters work as intended
@Mat'sMug, I updated my answer on your bountied question! Like.. If you wanna take a look. :p
@TopinFrassi Monking!
15:40
@Phrancis this looks like a useful column: [Same on CR?] = '============>'
0
Q: Lazy load class variables

DéboraFollowing my java class is required to be reviewed and couple of clarifications about class variable loading is required. Following is my class. import java.util.regex.Matcher; import java.util.regex.Pattern; public class ValidateUtil{ private static Pattern pattern; private sta...

Just a visual aid ;p
Probably will remove it once I'm confident about the results
looks pretty good to me
(just glanced at it though)
Good enough for now
Hm, the Tags join is going to be very complicated...
@EthanBierlein While that may be true, it is also true that NO film could possibly live up to the hype that Ep VII is getting.
15:51
@Donald.McLean That's true. It has the hype of the movie of the century
good thing the century is hardly 15% elapsed
huzzah!
!~--[value] ^ true I call code like this "job security" — TbWill4321 yesterday
@Donald.McLean That's true. They've been hyping this film for three years now, and there is no way they'll be able to fulfill the stratospheric hype they've created/
@EthanBierlein Unless they plug us on LSD when we seat ourselves in the cinema room
16:00
oh wow, anyone ever came across that one?
4662
A: What is the name of the "-->" operator?

Charles Salvia--> is not an operator. It is in fact two separate operators, -- and >. The conditional's code decrements x, while returning x's original (not decremented) value, and then compares the original value with 0 using the > operator. To better understand, the statement could be written as follows: ...

@TopinFrassi I've had better LSD
#Readability-FTW
while (x --> 0) // x goes to 0
I'm not really very worried about this new Star Wars movie. I'm more worried about this new Star Trek movie. It's being directed by the guy who did the Fast and Furious movies. *shivers*
@EthanBierlein expect 7 sequels
Yeah it's funny there's multiple ones like that on SO. People misuse (don't use) whitespace and suddenly someone needs to know what the -->=++ operator is.
6
16:04
1
Q: Showing next string with buttons when one is answered correctly

TravistyI am in the middle of creating a children's board game, that asks random maths questions and players move if they answer right. I have a main BoardGUI class that includes 2 panels. One for the board, and one for the questions. I'm having trouble with the Question panel. I'm reading in questions ...

@Mat'sMug except 2 more. They're doing this one, another one, and then another one.
I think they have this thing about doing the star wars reboots in sets of 3.
@TopinFrassi My dad used to make LSD in a lab in his basement.
@Donald.McLean For real?
woo-hoo! got "Do You Even Lift?" at last!!
@Donald.McLean I had neighbors when I was around 7 that made meth in their garage.
My family only found out when the police showed up to raid the place.
16:13
and 3 votes short of capping already... there's something about this VOTE CAP EVERYDAY FOR A WEEK hat that's just doing wonderful things :)
@Mat'sMug IKR! I got minimum +150 for the last 4 days. It's really fun
I found a 200 answer on Outdoors: outdoors.stackexchange.com/a/10352
@EthanBierlein My dad would not touch that crap. He tried PCP once by accident and decided that some people are just complete idiots.
Plus I have a great question coming this weekend. I can already see the HNQ
@Hosch250 200 appears everywhere, doesn't he/she/it?
7
16:19
@TheCoffeeCup It is said that there are 200 persons behind this account.
(or not)
@TopinFrassi I thought it was 200 rep/day.
@Hosch250 That's what I thought too.
(Two upvotes to my Python question in less than 5 minutes. Not bad.)
@Hosch250 Maybe that's it. I actually don't know. :p
Broken with two upvotes (now one, got my down):
1
Q: Showing next string with buttons when one is answered correctly

TravistyI am in the middle of creating a children's board game, that asks random maths questions and players move if they answer right. I have a main BoardGUI class that includes 2 panels. One for the board, and one for the questions. I'm having trouble with the Question panel. I'm reading in questions ...

3
Q: Telling fibonaccis to the user

TheCoffeeCupThough this program tells the truth (unless you change the source code), it does tell Fibonacci numbers, depending on the user's input. Keeping in mind of all (or most) of the feedback given from previous questions, I wrote this program to see how well I have progressed. def get_fibonacci_sequen...

16:26
Really Detailed review.Served both the purposes(error detection,code review).Thank you. — Pradeep just now
@TheCoffeeCup down
@Duga I love your hat :P
@TheCoffeeCup How'd you get Onion Knight?
@Hosch250 by following the Mother of Dragons
0
Q: Shared function between controllers in angularJS

tribetI have the same functionality in two controllers and I want to refactor to place it in a shared method that both controllers can access. I was thinking on creating a separate service called "Camera" and inject that service as a dependecy into both controllers as I'm currently doing with "Login". ...

16:34
@TheCoffeeCup I wrote a review, but you know that your get_nth_fibonacci function is quite inefficient, right?
A 200 comment on Lifehacks!
Also, err on the small side because it's easier to enlarge a ring slightly (but putting it on a mandrel and hammering it down), but harder to shrink it. — 200_success 21 hours ago
I've heard both ways, that it is easier to shrink and easier to enlarge.
I think our jewelers say it is easier to shrink.
0
Q: Angular controller without single responsability

tribetI'm new in cordova / angularJS and I wonder how much responsibility a controller can have. This particular one validates users entry data, display messaging, takes pictures calling the camera API, serialize them and finally calls a service to upload them to the cloud. I want to refactor functiona...

Man I can't get my query to run on SEDE without timing out now. The only way it will run is if I leave in duplicates (caused by multiple matching tags between SO<->CR) by doing a dumb join on the tag names. Anyone got ideas? data.stackexchange.com/codereview/query/411872/…
select distinct times out, as well as doing existence checks to try and optimize it...
@Hosch250 It depends what you're talking about. :p
Do a Group By on one of the titles?
16:51
No people were harmed in this clip ^^ youtube.com/watch?v=0JVxocVezPk&feature=youtu.be
@Hosch250 I'll try but I don't think that would work unless I grouped by all other columns
> Column 'StackExchange.Codereview.dbo.Users.AccountId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
That's what I thought
I might just have to shove all this stuff into a temp table and then do a select distinct on that
That worked
17:18
select distinct is a smell IMO
I'd say but I see your point
@Mat'sMug what do you think about this one? data.stackexchange.com/codereview/query/411872/…
Still a few false positives, I think I know a possible solution, but I think most of it makes sense
hey that looks great!
ready for CR it seems
You see what I tried to do with the exists checks? Unfortunately, SEDE still couldn't handle that
Seems like querying across databases like that is quite memory intense
Hm, something doesn't jive
There are only 60 posts now, there were way more than that before
17:25
Crap, I think I have figured out who my Secret Santa is.
That's way too early ^^
@Mast from the writing style alone?
@Mat'sMug Partly, and some of the latest information was partially identifying.
are we going to be disclosing who's who's Santa at the end?
Only if we can all agree on that.
lol, that'll be if we all get our shipment :)
17:29
@Mat'sMug Yea, really had a good laugh about it when I first noticed that one.
@Mat'sMug Yup. I have high hopes so far though.
me too
Hm, OK... for some reason the select distinct is what was crunching the result set from thousands of results to only 60 o.O
14 mins ago, by Mat's Mug
select distinct is a smell IMO
Note to self: avoid SELECT DISTINCT if any other option at all is available.
2
0
Q: Accessing information from a parent class

zadaneMy MainWindow popups a SettingsDialog. The setting dialog need to hide certain fields if the connected device is certain type. void MainWindow::on_actionSettings_triggered() { SettingsDialog * settings = new SettingsDialog(this); settings->exec(); } Now in SettingsDialog: SettingsDia...

17:48
> Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "SQL_Latin1_General_CP1_CS_AS" in the equal to operation.
@Mat'sMug ^^ HALP
I'm converting the values to the same type, but still getting the collation error...
You're doing it wrong.
use collate SQL_Latin1_General_CP1_CI_AS if you want case-insensitive
How do you declare the collation on a type though?
(or convert from one collation to another)
on foo = bar collate SQL_Latin1_General_CP1_CI_AS
Hm, does collate apply on the whole expression or only on the type of the value before it?
Whoops, totally wrong room.
@Phrancis I think it's only on the value before it... ...but how the F did you manage to run into collation issues on SEDE??
@Phrancis Did the group work?
I don't know any more than you do
@Hosch250 Negative
You will have to group it by the other columns.
OK.
17:53
@Mat'sMug Oh I think I do now... what's the standard collation in Excel text fields?
do I know that?
no clue..
I dunno, but I bet that's what the problem is
I pulled a list of language tags into Excel so I could put together an insert into statement, and I bet it used a normal collation vs. SEDE collation for tag names is probably case-insensitive
Do any of you guys know a nice smartphone that can last over a day on a full battery with moderate usage?
Deciding which one to buy is not easy
nice smartphone. > 1D battery. you need to chose man.
My iPhone 4 lasts > 1 day, for all it's worth. I wouldn't call it "nice" though
18:06
Over a day, or a day would do?
I don't know the stats on my 520, but it is out of print now anyway.
My One Plus One lasts a full day with some quite extensive use. I could last it 2, maybe 3 days without using the wifi too much
@TopinFrassi Preferably over a day, that gives some leverage to survive the day
Kinda tryign to choose between Samsung Galaxy S5, S5 Neo, Xperia Z3 Compact, Nexus 5X and some Huawei that looks like those
I seem to have some stalkers. I might as well make it easy then.
4
@200_success Nope, just reading the HNQ's.
18:13
Funny thing. That's where I go too.
Always nice when you find an acquaintance in an unexpected part of town.
@Hosch250 Depends what part of the town you're visiting ;-)
@skiwi Like PPCG? :P
3
Is Posts.DeletionDate purposefully left empty on SEDE?
Deleted stuff tends not to show up at all in Data Explorer.
I think that the intention is not to reveal anything that an unprivileged user would not normally see.
18:17
OK
Why the field is there at all, I don't know. Maybe the staff get to use it?
@Pratik Missing ToList() can be easily noticed during code review (together with many other bugs and code smells - it's really worth the time). EF code-first doesn't have many extra requirements on the classes it uses - usually you can use domain model as ORM model (not the other way around - domain goes first). Adding another layer of DTOs only complicates things. And even if you have a separate persistence model, you will just end up with 2 projections in queries. — Jakub Lortz 47 secs ago
@200_success Maybe just to signal to users that the field does exist... but you are probably right
Anyways, how does this one look? data.stackexchange.com/codereview/query/411872/…
(code is kind of ugly still, I mean the results)
Very interesting query.
I'd be curious what kind of aggregates others could come up with based on the #CrossPosts results. I suck at aggregates and things like that myself
18:26
Why are the user profile and SO question links not clickable?
I tried to make them link, but it's an SEDE limitation
You can only have 1 [User Link] and 1 [Post Link] per query, and furthermore, [User Link] can only apply to one site
You can still compose links the hard way.
Oh crap, didn't think about that! Any pointers, or just basically concatenate the values to form a URL like displayed on the sites?
See site://posts/' + CAST(Id AS nvarchar) + … on SEDE help.
I also suggest reordering the columns to put status and status together, and score and score together.
Good thinking
18:32
http://www.commitstrip.com/en/2015/12/18/star-wars-will-always-be-star-wars/
CommitStrip
Star Wars will always be Star Wars
CommitStrip
1450463401
4
@CommitStrip Imagine, we open the CommitStrip and it's filled with spoilers
"User had an account on SO prior to having one on CR" and "Q was posted on CR within a certain number of hours after being posted on SO" are not obviously part of the definition of "cross-post". You should note that in the query's description field. I was hoping for some kind of content similarity check, but I suppose that that would too slow.
Huh, I had two outlook apps on my phone, wanted to delete the oldest unsupported one, ended up deleted the newer one, ended up deleted both, and now I downloaded an entirely newly upgraded version again, wat
@200_success I'm open to ideas for content similarity checks, but given the memory limitations of SEDE, and the fact that would probably require some kind of cursor... Sounds difficult...
18:51
I wonder if a character count of the post's bodies (+/- a certain number, say 100-200 maybe?) would make sense as a sort of similarity comparison
That could be one heuristic incorporated into a similarity score.
@Phrancis Jamalized posts would throw it off ;-)
Surely Jamal doesn't add or remove that much most of the time!
Oh, I missed the 100-200 diff threshold.
Wait why does my phone want to autocomplete "Oh, " with "Canada"
@200_success one reason I incorporated a maximum amount of time between posts on the two sites is to limit false positives as much as possible... say for example user JD posts 1 question on SO 1 Java year ago, then 50 Java on CR this year, all 50 would show as cross-posts to the 1 SO question
18:55
@Mat'sMug Better than some 4-letter word.
@Mat'sMug Your national anthem?
yeah I sing "Oh, Canada" all the time on my phone :)
Is it a Blackberry?
Google / Android
Zak
Zak
Woo, I just found pringles I didn't know I had.
19:01
lol
Zak
Zak
Also, I can't VTR yet, but I believe this shouldn't be closed.
1
Q: Delete rows quicker

Mohammad ImranI have worked on some VBA code for past couple of days and everything seems to be working fine till one fine day when I added the below code to it. The execution time increased to such an extent that I myself don't know when it is going to complete. I have waited for almost 2 hours but it contin...

IT's code that works and runs, he's just trying to do it on too large a scale.
> This datasheet that I have is about 15 MB in size and contains around 47,000 rows with 25 columns filled with data.
lolol
That was in my e-mail today...
@Mast spam?
19:05
@Mat'sMug No, company trying to be punny.
oh, "Force"?
I guess lastRow5 is a typo — Heslacher 7 hours ago
@Mat'sMug Yup, it's a Star Wars joke.
Once that gets fixed, we should be able to reopen it.
that code needs a rubber duck
and some StringContainsAny method that exits when a first match is found.
Zak
Zak
19:09
Is an obvious typo grounds for VTC?
the part I don't get is, how does one end up with a "typo" in their CR post if they copied if from the working code in their IDE?
Yay they added another parameter to this proc for this release, bringing the grand total to 115 parameters now.
2
115 parameters? ...does SRP not apply to SP's?
You would think...
0
Q: Fast 32x32 bit multiply on ARM M0

AShellyI have a time-critical calculation running on an ARM Cortex-M0. This is the fastest 32x32 bit -> 64 bit multiplication that I can come up with. The following C compiles almost 1-1 to assembly instructions. //consider each arg as two 16-bit parts. //r0 is Aa is A<<16+a. r1 is Bb is B<<16+b //the...

0
Q: Apply text labels to images in directory. Use changes in color to find correct location for text label

mcgyver5This command line program applies defined labels along with Monday's date to a directory of images. The script has to handle not being run on a Monday. Others are asking for the script so I cleaned it up as much as I could. I want to make it as friendly and as cross platform as possible. La...

19:12
Well, it is SRP, exec usp_AddWorker ... for some values of SRP
for the record, "SRP" does not stand for "Sublime Rack of Parameters"
3
And finally, my finals are finished
private static final Final _finished;
4
@Mat'sMug What do you mean, "mmph"? (I know, super-old message, but you left right after you said it so I couldn't ask at the time.)
@Mat'sMug goto dead;
19:18
Are you sure that there aren't any classes you registered for and forgot to drop?
@Pops haha, the only place I saw retVal used, was in messy VB6 (and VBScript / ASP Classic) code :-)
Ah. I was hoping you could help me articulate why it made me feel icky.
@200_success I always feared that
well, it'll get garbage-collected by next week anyway
@200_success That's just evil.
19:21
@Pops well, retVal is a bad name because it concatenates two abbreviations "return" -> "ret" and "value" -> "val". One abbreviation is ugly enough... result is 6 characters, retVal is 6 characters too.
I feel icky just typing retVal in chat, I can't imagine in code...
What if it returned something other than a value?
retJustASuggestionImNotYourMotherOrAnythingButIThinkIHaveAGoodPoint
8
retFun
Zak
Zak
retCon
@Phrancis returning Valerie wouldn't be politically correct
19:25
@Mat'sMug lol
Zak
Zak
That's a request btw.
I use result too in most generic cases
I ♥ result.
I need to type up my annual self-review. "result-oriented" must come up.
2
Lol. You seem kind of obsessed, that's scary. :p
Added Duga comments for interesting results, albeit it creates some duplicate rows due to multiple qualifying comments on some posts
19:37
@Phrancis nice!
Maybe the content of the comments is not really important and I could just make a Yes/No column to indicate whether or not there were Duga comments on the SO Q
You seem to have a bad join that lost distinctness.
/*Bring in @Duga comments*/
left join [StackOverflow].dbo.Comments as SoComments
    on  SoPosts.Id = SoComments.PostId
    and SoComments.Text like '%code%review%'
^^ that one, yes
left join (select PostId,DateCreated,Text,row_number() over (partition by PostId order by DateCreated) RN) from [StackOverflow].dbo.Comments ) SoComments on ... and SoComments.RN = 1
?
something like that
SQL voodoo
19:42
  , [Has@DugaComments] = case
        when SoComments.Id is not null then 'Yes'
        else null end
^KISS ;0
right
specs: show duga comments. specs are hard, show "yes/no" instead.
I've got two bounties expiring in three days.
@Hosch250 playin' Santa :)
@Mat'sMug (y)
The trouble is, neither of the questions has an answer.
18
Q: SIMD matrix multiplication

PeterI recently started toying with SIMD and came up with the following code for matrix multiplication. First I attempted to implement it using SIMD the same way I did in SISD, just using SIMD for things like the dot product for each particular entry, which was actually slower (still trying to figure...

23
Q: Siamese neural network

DavideChicco.itI have been studying the architecture of the Siamese neural network introduced by Yann LeCun and his colleagues in 1994 for the recognition of signatures ("Signature verification using a Siamese time delay neural network".pdf, NIPS 1994). I had some problems in understanding the general archit...

19:44
@Hosch250 That's really interesting, but also really difficult
That's pretty freaking cool, what was your inspiration for this? — Ekult3k 8 hours ago
You put a bounty on a Lua Q? You're just throwing away rep dude
@Hosch250 Problem is, I understand nothing of this
@Phrancis well... the flipside is that it could motivate a reviewer to come along
come January we'll be able to make community ads saying "WANTED: LUA REVIEWER"
Only 12 unanswered out of 56.
19:47
yesterday, by Duga
I'm not sure why your CR account is deleted but FYI there's a bounty on an old question of yours: codereview.stackexchange.com/q/93690/36214Bjørn-Roger Kringsjå 44 secs ago
OP was pinged yesterday on SO
@Mat'sMug hehehehehehehe I know Lua.
Now I just need to hack together the additional post links and the user links, clean-up a bit, then post on CR
@Phrancis you still need that distinct?
But the only thing in the world that uses it is WoW, so there's no point reviewing it kek
19:51
@DanPantry well there's actually 50 points for reviewing it...
50 internet points you say...
50 uncapped internet points
Plus all the glory you get for killing an ooooold zombie
Oh baby, you know how to push my buttons.
@DanPantry Hey, the government uses it for cyber warfare.
At any rate, that question is far above my level of.. well, not understanding.
19:52
Stuxnet/Duqu/Flame/Gauss are written in Lua.
I understand it just fine. But I don't think I could give it a good review.
well, TIL. That's an interesting tidbit. Got a sauce? @Hosch250
@DanPantry Yes, sir.
I did also lie a bit because League of Legends also has some limited parts written in Lua.
Just give it your best shot! :-)
Flame, also known as Flamer, sKyWIper, and Skywiper, is modular computer malware discovered in 2012 that attacks computers running the Microsoft Windows operating system. The program is being used for targeted cyber espionage in Middle Eastern countries. Its discovery was announced on 28 May 2012 by MAHER Center of Iranian National, Computer Emergency Response Team (CERT), Kaspersky Lab and CrySyS Lab of the Budapest University of Technology and Economics. The last of these stated in its report that Flame "is certainly the most sophisticated malware we encountered during our practice; arguably...
I originally saw it on Lua with a different reference than Wiki, though.
19:56
@Mat'sMug Fixed with this:
  /*Check for @Duga comments*/
  , [Has@DugaComments] = case
        when exists (
            select 1 from [StackOverflow].dbo.Comments as SoComments
            where SoPosts.Id = SoComments.PostId
            and SoComments.Text like '%code%review%'
        )
        then 'Yes'
        else 'No' end
It's not mutually exclusive, the Lua interpreter is written in C. I've personally mixed C++ & Lua.
Very fast check too, lot faster than the join
0
Q: Copying data to another workbook from an import

Liking_VBAI have put together a code that I would like reviewed before trying to use it. The purpose is to copy data from one workbook (named "Hourly Extract") based on specific criteria, to the next empty row in a specific worksheet ("Master) of another workbook ("Master December File.xlsm") If the cell ...

0
Q: Improvements for Address filter with PHP using regex

JamesI developed a PHP function to get a not formatted address and split it in a street name and number. Following are some patterns of received addresses StreetName Number SrtreetName, Number Number StreetName Number-Number StreetName StreetName, Number, Complement StreetName Number...

Well, it is used in some of them, but possibly not in others.
The sources seem to be a bit contradictory.
The source is strong in this one
19:59
The sauce is strong with this one.
3
I shall call him.. bolognaise
@Phrancis indeed makes an interesting result set for aggregates

« first day (958 days earlier)      last day (3357 days later) »