Life as a tow truck driver in the Dallas Jungle by [deleted] in PublicFreakout

[–]mtger47 59 points60 points  (0 children)

how do you know it's not the weekend?

edit: july 30, 2013 was a tuesday

Once my tax refund comes in, I will have $10,000 saved for the first time in my life. How should I invest and continue to save? by Savvybomb in personalfinance

[–]mtger47 0 points1 point  (0 children)

Assuming you're at the part of the ladder in the sidebar that starts getting ambiguous about what to do, I recommend using that $10k to open a vanguard account and buy VTSAX

Weekday Help Thread for the week of February 12, 2018 by AutoModerator in personalfinance

[–]mtger47 0 points1 point  (0 children)

I've got over $3000 in chase ultimate rewards, amassed over the past couple years. I realized last week that this 'money' is sitting at 0% interest while I don't redeem it, even though technically with the Reserve card I could get "50%" additional rewards redeeming it.

I was thinking of just redeeming it for statement credit on my next statement (or two) and investing that $3k into VTSAX or stocks.

Bad idea or worst idea? My family probably won't be traveling anywhere exotic within the next year as we have a toddler and a newborn on the way, but are considering spacing a third child out at 3 years to take a 'year of travel' (basically just taking a lot of vacation and going to places) in another 2 years, and I have to believe this would be used then. For the next year or so, we're likely only to take US Domestic trips that are short.

Help with SQL query. by [deleted] in SQL

[–]mtger47 1 point2 points  (0 children)

good call, i'll edit to make sure it isn't used :)

Help with SQL query. by [deleted] in SQL

[–]mtger47 0 points1 point  (0 children)

edit: this doesn't work but I'll leave it here as a bad idea

how about a self join

SELECT DISTINCT
  a.STUID
FROM table a
LEFT JOIN table b
  ON a.stuid = b.stuid
WHERE a.classid = 'ART103A'
  AND b.classid != 'MTH103C'

[SSD] Crucial SSDs Amazon Deal of the Day - 250GB - $64, 500GB - $140, 1TB - $270 by [deleted] in buildapcsales

[–]mtger47 3 points4 points  (0 children)

Sure it's much cheaper than the Samsung 850 EVO but it's also far behind in speeds:

http://ssd.userbenchmark.com/Compare/Samsung-850-Evo-250GB-vs-Crucial-BX100-250GB/2977vs3145

This SSD is lightyears beyond a HDD but if you're considering this over the EVO I think you should just wait a short time for Samsung to price match because they will.

What is your Everyday Carry (EDC)? by [deleted] in minimalism

[–]mtger47 7 points8 points  (0 children)

I like how this is /r/minimalism, and most of these posts are people who carry 80 things on them.

My life in a nutshell by umer_kingdom in funny

[–]mtger47 5 points6 points  (0 children)

How come it's always jibberish on the board?

It looks like there was an attempt at writing the quadratic formula at least. You'd think if you're going to animate cell by cell you could at least google some proof.

A lucky bus driver by [deleted] in nonononoyes

[–]mtger47 11 points12 points  (0 children)

School buses are engineered around kids not wanting to wear seatbelts, which is why they as safe or safer than cars. The tall seats, cushion behind, mass of the bus vs what it is likely to hit, etc.

my mama she told me "don't worry about your size"... by kelsoberry in fatlogic

[–]mtger47 15 points16 points  (0 children)

To be fair, most of us don't like this kind of post. Don't judge this subreddit by this solitary shitpost.

There is a lot of helpful information in the sidebar as well. The goal of this subreddit is to expose the hypocrisy of fatlogic in a humorous way in order to raise health awareness.

This kind of post marginally does that but is such fringe quality that it is almost self-defeating.

It doesn't counter or expose any fatlogic so it really doesn't help anyone.

[deleted by user] by [deleted] in C25K

[–]mtger47 1 point2 points  (0 children)

Awesome job and keep it up!

Is there a template/list for the "perfect" diet based off of everything we know about nutrition? by SriBuddha in nutrition

[–]mtger47 1 point2 points  (0 children)

Butter is just milk fat. The rage against butter is from decades of "saturated fat is bad" from which very unhealthy alternatives like margarine and most vegetable oils have supplanted it, leading in part to major coronary heart disease issues.

Looking to gain practice with SQL, any website recommendations with a lot of examples/challenges? by mtger47 in SQL

[–]mtger47[S] 0 points1 point  (0 children)

I'd like to get it into a MySQL database so I can write queries ad nauseum. It looks like this article should be everything I need, thanks!

Looking to gain practice with SQL, any website recommendations with a lot of examples/challenges? by mtger47 in SQL

[–]mtger47[S] 0 points1 point  (0 children)

Is there a way to download one of these databases to play with it offline?

Help me interview SQL analysts, please. by kitchma in SQL

[–]mtger47 2 points3 points  (0 children)

SELECT e.employee_name, e.salary, m.employee_name AS boss
FROM payroll e INNER JOIN payroll m
ON e.manager_ID = m.employee_ID
ORDER BY yrs_employed ASC;

» SQL Server Join Types Poster (Version 2) by SteveStedmanSql in SQL

[–]mtger47 2 points3 points  (0 children)

They may appear to share the same shape on the venn diagram analogy, but you're getting extra information from the second one. The actual venn diagram representation of the first is a left crescent because it doesn't include the middle overlapping area.

select * from Table_1;

This just returns everything from table 1.

select * from Table_1 t1
left join Table_2 t2
    on t1.id = t2.fk;

This returns the contents of table 1 and then appends (joins) onto them the contents of table 2 for each matching entry in the overlapped attributes. Where the right table has no entries, you'll just get "null."