Spyke

Replies

Comment on

debate club

Reply in thread

The problem with saying "both" is that there are 5 groups involved, maybe even 6.

  1. The Israeli government
  2. The Israeli people
  3. The West Bank Palestinian government (Fatah)
  4. The Gaza Strip Palestinian government (Hamas)
  5. The Palestinian people (arguably separate groups to account for differing levels of suffering and oppression)

I'd agree that "both" are bad if you mean the Israeli government and Hamas, though to different degrees at different times. I'd agree "both" are victims if you mean the Israeli and Palestinian peoples, though undoubtedly the Palestinians in the Gaza Strip are the most victimized right now and in general.

climate

Comment on

This is how big one tonne of CO2 is

Reply in thread

At standard temperature and pressure (STP) it looks like CO2 has a density of 1.96 kg/m^3. 1 tonne = 1000 kg, so a tonne of CO2 has a volume of (1000 kg)/(1.96 kg/m^3) = 510 m^3 at STP. A cube of that volume would have side length (510 m^3)^(1/3) = 7.99 m, so roughly 8 meters per side.

I don't know how tall that person is, but if we assume around 1.6 m (5' 3") then the cube side length should be about 5 of her. Seems pretty accurate to me.

memes

Comment on

Clean up on aisle 5

If this is real and in the US, I would love to see a Gen Xer or elder Millennial apply, make sure to mention their generation, and then get this dumbass owner to say in writing that they aren't hiring them because they aren't a Boomer.

IANAL, but that seems like a slam dunk age discrimination case as long as the applicant is at least 40.

Comment on

Kamala Harris Says She Is Ready to Serve as Biden Faces Age Scrutiny

Reply in thread

Lol, are you seriously still peddling the "if you don't vote for Hillary you're sexist" bullshit? It was pathetically transparent back in 2016, it's downright delusional now.

Couldn't have anything to do with her being an unapologetic war hawk. Or a Clinton (the last one helped set up our economy to crash in 2008). Or a weak candidate with weak positions pandering to the middle even during the primary instead of pushing left. Or an entitled narcissist who colluded with the DNC leadership to put their thumb on the scale. Or a petulant child who was too busy smearing her primary opponent even after the general was over to take responsibility for the fact that she and her campaign directly gave us Trump by propping him up as a pied piper.

Comment on

"Password Incorrect"

Reply in thread

My favorite is when systems will stealth truncate your password without telling you, but only when setting it. For some reason I often encounter this with systems truncating to 20 characters.

  • Set 24 character password: no error (secretly truncated to 20 characters).
  • Try to log in: credentials invalid (it checks the full 24 character one against the 20 character one).
  • Go to reset to what it should be, password can't be the same (again, stealth truncating to 20 characters).

Comment on

I'll just be a quick 3h

Reply in thread

Basically scripts you can run on the fly to pull calculated data. You can (mostly) treat them like tables themselves if you create them on the server.

So if you have repeat requests, you can save the view with maybe some broader parameters and then just SELECT * FROM [View_Schema].[My_View] WHERE [Year] = 2023 or whatever.

It can really slow things down if your views start calling other views in since they're not actually tables. If you've got a view that you find you want to be calling in a lot of other views, you can try to extract as much of it as you can that isn't updated live into a calculated table that's updated by a stored procedure. Then set the stored procedure to run at a frequency that best captures the changes (usually daily). It can make a huge difference in runtime at the cost of storage space.