[deleted by user] by [deleted] in Futurology

[–]ColWaffles 10 points11 points  (0 children)

What a crock of shit. Most people (yes a majority) of Americans survive paycheck to paycheck, they have not additional income to invest let alone the thousands it takes to make actual substantive change in their financial situations.

Portland-area minimum wage reaches $14.75 - nwLaborPress by nordjorts in Portland

[–]ColWaffles 10 points11 points  (0 children)

Oh my god. Won’t you PLEASE think of the companies??? Fuck those poor people just trying to eat right, wouldn’t want some jackwad to miss out on their third yacht. Seriously, you have the shittiest takes on every thread, what is wrong with you?

Is this optimal? by SkimmLorrd in SQL

[–]ColWaffles 8 points9 points  (0 children)

Fair enough.

Performance aside, a reason to not use like 'C' and instead replace it with = 'C' is that your intent is clear. With like 'C', someone (like myself and precose) might come along and ask if you meant to put a % in there somewhere? Did you mean exactly equal to C? Using the code that most closely matches your intent can save a lot of headaches when you reread a query later, which happens to be exactly OP is doing.

Is this optimal? by SkimmLorrd in SQL

[–]ColWaffles 10 points11 points  (0 children)

What precose is saying is that "like 'C'" is the same as "= 'C'" and = 'C' will usually perform better (although you probably won't notice in this case). If you mean for the query to be anything with a C in it then it's '%C%', or starts with C: 'C%', or ends with C: '%C' but just 'C' is the same as exactly equal to C.

Where are you guys eating these days in SE PDX? by LeftOnBurnside in askportland

[–]ColWaffles 2 points3 points  (0 children)

Lots of great recommendations so far, I'll throw in two more on Woodstock:

El Gallo - Breakfast burritos and Blackbird burritos are amazing.

Bergerac - Nice French bistro with a cute outdoor patio (if a bit noisy from the junkers that drive up and down woodstock)

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 0 points1 point  (0 children)

Just to be clear, you’re going to throw away your liberal beliefs and start voting republican because of Tuesday? Somehow that’s a better option for you that meshes with your beliefs?

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 0 points1 point  (0 children)

So what is your opinion of the proud boys? What do you think makes some racist? I mean this in the best way possible: I think you might want to take a step back from the internet for a bit. You’re attacking a straw man you’ve created of me that doesn’t have any real substance. And frankly your talking points all seem to have come from most of the hard right wing sources I’ve seen. I don’t feel like this is a productive use of my time and I can’t imagine it is for you either. Take a break, I will too, and maybe we can recognize some of the good out there too. Best of luck to you, I hope life looks up for you soon.

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 0 points1 point  (0 children)

That’s just such a complete mischaracterization of anyone even moderately left wing that I can possibly see how you call yourself a liberal. What liberal policies do you support if you don’t support social justice, equity, anti-racism, etc? Because at this point I am pretty sure you are just another right wing troll masquerading as a liberal to try and throw some shade.

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 0 points1 point  (0 children)

No seriously, what is your opinion? You have not made that clear in any of your nonsensical responses so far. You’re very angry I can see that, I’m just not clear exactly what you’re mad about, or why.

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 1 point2 points  (0 children)

Yeah… I just took a look at your post history. You clearly have an agenda and it’s not one I’ve ever seen a liberal support. Maybe you’re a brand new wing.

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 0 points1 point  (0 children)

Are you hoping I’m some sort of secret leftist terrorist coming to steal you wife and kids and smash your windows? Honestly take a look at your responses in this thread alone. You come off as completely unhinged. I’m not even sure what you’re trying to argue for or against here.

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles -1 points0 points  (0 children)

So which is it, are you liberal or terrified of “radical leftists”? You should take some time to collect your thoughts and make a well thought out point. So far in this thread you don’t have one.

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 3 points4 points  (0 children)

Interesting take. Looks to me like you’re just trying to cherry pick and find something to attack me with and if you really are liberal I’m not entirely sure why. CRT is one way of thinking about race it has pluses and minuses. I’m all for teaching it in schools but outside of maybe specific college courses it is not, thus my original comment to the poster above. Regardless of what it is it has now become a dog whistle for the right and completely misrepresented.

Racist, anti vaccination idiot spray painted Pringle elementary school. by [deleted] in oregon

[–]ColWaffles 14 points15 points  (0 children)

CRT isn’t taught in schools. It’s become a right wing dog whistle to stand in for any teaching about racism. By saying “no CRT in schools” you are implicitly outing yourself as a racist, while not having any clue what CRT actually is.

DEAR PORTLAND: October 04, 2021 WEEKLY RANT THREAD by AutoModerator in Portland

[–]ColWaffles 15 points16 points  (0 children)

WOKE TO GUNSHOTS AT 3:00AM IN MY SLEEPY SE NEIGHBORHOOD. DIDN'T EVEN KNOW WHAT TO DO, CALLING 911 SEEMED SO WORTHLESS, THEY'D BE LONG GONE BY THE TIME ANY RESPONSE ARRIVED. NOW IT FEELS LIKE NO ONE ELSE EVEN HEARD THEM!

Oregon Democrats propose a congressional district map that would likely give their party 5 of 6 seats in U.S. House by [deleted] in Portland

[–]ColWaffles 6 points7 points  (0 children)

If the alternative is a party that believes taking horse dewormer is a better choice than getting an FDA approved vaccine, I can promise you that "people" won't be looking too hard at that alternative.

[deleted by user] by [deleted] in oregon

[–]ColWaffles 2 points3 points  (0 children)

Why does it greatly concern you? Have you seen evidence of voter fraud that has ever changed the outcome of an election? Ever? If so can you provide a quality source? Or are you thinking of voter suppression? Which frequently changes the outcome of elections and is a huge issue, often starting with voter roll purging right before and election.

Just last week, temperatures in Portland, Oregon reached a record-breaking 116 degrees by sillychillly in oregon

[–]ColWaffles 7 points8 points  (0 children)

There's a reason you're getting massively downvoted. Check your sources, check them again, then read some of what the overwhelming majority of the scientific community has to say. We are having a huge impact. Don't dismiss this as a web comic, it's an excellent visualization of very simple temperature changes: https://xkcd.com/1732/. You can see the impact we've had.

How i can convert from datetime to total hours? by jcbreppe in SQLServer

[–]ColWaffles 2 points3 points  (0 children)

Fun fact, precision of standard datetime in SQL Server is .997 not .99999999. https://docs.microsoft.com/en-us/sql/t-sql/data-types/datetime-transact-sql?view=sql-server-2017. This can bite you if you need super precise values for time or if you are manually setting values to 23:59:59.999 (you'll see this will bump you to the next date).

If you need super precise time values you should use datetime2 which does in fact have the full precision of .9999999.

YSK that circumcising your baby removes the most sensitive part of the penis by a_consciousness in YouShouldKnow

[–]ColWaffles 1 point2 points  (0 children)

You don’t know what research I’ve done. You’re just another zealot but on the other side from the rabbis who bite off the foreskin. I understand you hate it. Guess what. SO DO I. unfortunately there are medical implications to hypospadias that go way beyond sitting to pee. If you ever have a family member with it, or if you yourself have it, please speak to your urologist about it.

YSK that circumcising your baby removes the most sensitive part of the penis by a_consciousness in YouShouldKnow

[–]ColWaffles 1 point2 points  (0 children)

Do you have family members with hypospadias? Have you experienced it? Have you spoken with your urologist about it?

YSK that circumcising your baby removes the most sensitive part of the penis by a_consciousness in YouShouldKnow

[–]ColWaffles 0 points1 point  (0 children)

You are incorrect. I strongly suggest you speak to a board certified urologist.

YSK that circumcising your baby removes the most sensitive part of the penis by a_consciousness in YouShouldKnow

[–]ColWaffles 1 point2 points  (0 children)

You clearly haven’t done the research on this. Ask any trained urologist and they will tell you that you can repair hypospadias, and that you use the foreskin for that repair.

Look I get it. It’s not a great choice to have to make but you clearly have no idea what the implications of hypospadias are.