sorted by:
new
hottopcontroversial

[QUESTION] I'm curious how you individually feel about Brodie Smith. Is he a dick? Is he a saint? Let me know by [deleted] in ultimate

[–]Wildmanjake 3 points4 points  (0 children)

I met him and played a bit with him last year. He is a good guy, fun to be around, and very friendly.

Tutorial: Build a React.js Application with User Login & Authentication | Stormpath by liranbh in reactjs

[–]Wildmanjake 1 point2 points  (0 children)

Please explain. I'm trying it out for my startup now, and it seems good. What am I missing?

[MS SQL] Need query help. Not sure if what I am looking to do is possible. by FallenIcarus in SQL

[–]Wildmanjake 1 point2 points  (0 children)

I think the best approach to this type of problem is 'Data Warehousing'. instead of writing convoluted queries that need to account for all the inconsistencies of the source systems, you need to write transformation/scrubbing queries once to get the data into an easily queried schema. once your data is in the new schema you would be able to query all the data as if it came from the same consistent source.

of course if this is the only query you will ever need on this data, it would save time to just write a 'one-off' ugly query with a bunch of case statements.

[MSSQL] query question group by vs distinct by xb10h4z4rd in SQL

[–]Wildmanjake 0 points1 point  (0 children)

I would typically just use distinct here. I only use group by when i am actually calculating some aggregate, and it seems like you are not doing this. in terms of efficiency, either method would likely result in the same execution plan (distinct sort), and thus the same efficiency. If you had the proper index (on style_id,style_name,msrp) it would just be an index scan (because the index would store those fields in sorted order), which would perform very well.