"Am I high XOR is there no discrepancy?"

@HannahVernon i actually love duckdb

truth

@swasheck why though?

goodness me, you can run it as a WebAssembly

He's quackers

my browser is already using more memory than everything else

The delete statement in Duck DB is duck duck gone

lol

Something something duck down something something

in process fast analytics

of what though - wouldn't you need to load a bunch of data into it at runtime? Or am I just totally misunderstanding

🦆🦆🦆

There's no point criticising Duck DB

Rolls right off

Like

bahahahahahahah

Cuban cigars still off the agenda I see

30th anniversary UN vote to lift the embargo today

Almost unanimous as usual

185 in favour, 2 against, 2 abstentions

You guys hear about AWS GooseDB? Automatically migrates regions.

The coup de foie gras

Duck Duck Grey Duck

Paul, you're on your game this morning

Game ha ha

Whelp, answered the setup maxdop question. I see Joe did as well :D

finally out of meeting for 45 minutes

You all are chatty today

@SeanGallardy is the /2 for HT or?

@PaulWhite Setup doesn't care

I mean it does care

but if you turn HT off, you'll have 1/2 the logical processors

so it'd change the calculation

the /2 is just there, I don't know why

Heuristics I bet

it's only for >15/NUMA

It's always heuristics

HA!

I'm sure they can work in more CEIP just 4 u

"MVP P-Core announces they want more CEIP in SQL Server"

@bbaird I read it first like that, too.

My only guess is that > 15 means at least 16, since the docs say don't do more than that, we just divide by 2, as even 32/SOFT NUMA (which would be the max since you can't span a k-group) /2 would still be 16

but that's just a guess

probably a terrible one at that

K-group?

processor k-group, IIRC still limited to 64 per numa

nope, it's been updated! learn.microsoft.com/en-us/windows/win32/procthread/…

I did a bunch of research into it a while ago (2016ish?) when I was asked why cpu_id in the schedulers DMV had gaps in it.

Who could possibly need more than 64 processors

Top Microsoft Man explains what a k-group is without explaining what K stands for. Mod Hannah sad.

@PaulWhite or 640k of memory

youtube.com/watch?v=nmgFG7PUHfo Gauss remains #1 in firsties

@HannahVernon I believe it's named that because that's what they named the kernel structure

ahhh, probably "K" means kernel. Cheers

I hate making assumptions unless its about whether or not I'm running Service Borker

(that was for you, Paul)

Wait where are the Cubans

I don't think anyone calls them k-groups anymore

Aside from knackered old support engineers maybe

@ErikDarling embargoed

Technically the documentation uses both "processors groups" and "k-groups" depending on the document.

Knackered old documentation only

Also it's called Learn now

😛

One day I'll learn

Might've changed in the last hour tho

@PaulWhite no one tell my humidors

K-pop group

@SeanGallardy anyway thanks for adding that answer you're one of the few people who could

@ErikDarling I was actually a little more concerned about the Cubans themselves but yeah

@PaulWhite I wish we could import all of them.

I think they're mostly happy where they are, or would be if the US would leave them be

Oh you mean the cigars

just for future reference

best $50 i've spent today

I gotta make that page respond to a click

LOL both of those are great

how do I get strikethrough on my answer for text?

Don't. Just make the current form of the answer the best it can be.

Anyone interested in your prior errors can read the post history.

I want to poke fun and strike out msdn, bol, and docs

I don't think there's markdown support, so you have to use <strike> and <</strike>

Oh <s> and </s> also work, and <del> </del> too.

Oh <s>s</s>

YOU LIED TO ME

That's for the main site

For chat, three dashes work ---struck---

struck

Before and after

The enter key is too close to the other keys

testing

There we go

It's documented in the tiny "help" link bottom right of this page

chat.stackexchange.com/faq#formatting

ffft instructions, who needs em

The question comes up a lot

That's from ten years ago

@PaulWhite that must explain why they keep coming here

At any rate I’m happy to have them, cigars or not

Evening in Manhattan

@HannahVernon v2 is up, and click responsive.

@ErikDarling nah, I'm not jealous. Ok, I am.

@PaulWhite thank you :)

Apparently, I now have access to site analytics.

@ErikDarling Yes, I suppose the conditions imposed by the embargo would contribute to people wanting to leave.

@SeanGallardy They haven't worked properly for years.

But congrats.

Just my luck!

25k

Do I get a jacket now?

25k klub

or do I still lahk enough points

You can get a SO windbreaker and Zippo

The zippo will come in handy if cubans are ever allowed back in :D

The windbreaker will shield be from the 'canes

phew

washingtonpost.com/world/…

@SeanGallardy good luck with that in a canoe

@PaulWhite it is a generally bad policy but Cuba should liberalize to reciprocate lifting

Bit hard to get across with other member states in worse shape

I disagree. Other countries should be able to organize themselves in the way they think best.

I hope you never see the worst of that

Every country on Earth has seen that at one time or another.

> Since 1992, the UN General Assembly has passed a resolution every year condemning the ongoing impact of the embargo and declaring it in violation of the Charter of the United Nations and of international law.

@PaulWhite the difference is those that have and those that continue to. the problem with decided bad is that once it’s decided it’s hard to undecide. people in charge of bad ideas don’t often want to give up that control.

I think the issue is more that no one people or country gets to decide what is 'good' or 'bad' there. There are some things we have been broadly able to agree on, and the UN Charter is the best representation of that we have so far. Every country has problems today, in different areas and to different extents. It's too simplistic to try to break it down into a sort of cartoon good vs bad scenario.

One could think that over time, given the freedom to develop as they wished, it would become obvious which principles and systems work better than others. Attempting to force a particular system or set of values on another population with vastly different culture and history has never gone well. I see no indication it would work any better in future.

Yeah it’s a Star Trek episode.

I can't immediately think of any examples in recent history where interventions or unilateral action of any kind has worked out better for the people concerned.

Or, more importantly, where actually sitting down and reaching a workable compromise that suits more than one interest couldn't work better. That again is a principle of the UN Charter.

It's just amazingly arrogant for anyone to think they have all the answers, and other populations just need to adopt more of their perspective on things, for everything to work out.

Well yeah and because of that basic personal freedoms need to be represented and not infringed upon. I don’t hold the US up as a good representation of that, but I do think there are many countries that are worse representations.

Well, of course. It'd be strange if it were different. The trick is to agree on what "basic personal freedoms" mean precisely. And that's only one aspect of the types of problems countries face. Some would prioritise it higher than others.

Below eliminating extreme poverty, for example. Or free healthcare & education, a basic standard of living, a certain level of serious crime in society and so on.

It's not like there aren't enough actually tricky problems going around that need solving.

I always error on the side of more freedoms. I want people to be happy and I have very little empathy for people in charge.

I would agree that more personal freedom in general is a good thing, though I would caveat that a bit by saying, ideally, they would be constructive as well. People being happy is certainly something to aspire to, but it can be a bugger to pin down, or at least ensure it lasts. Transient happiness isn't as difficult.

I'm not at all convinced we have evolved the perfect system yet to ensure people who are actually good at leading get into power, with the right checks & balances.

Many countries seem to regularly choose quite unsuitable people, on the face of it.

It's a pattern that's so long-lived now, it's tough to put down to chance.

Even in my own country, it's quite hard to assess if anyone will be any good at their job before they get elected. On what basis to decide? Their personality? General promises? idk

And then we give them 3 years to make these great promises a reality, with honestly very little prospect of them being able to, even if they were genuinely committed to it

The alternatives may be worse, but it's hard to judge having never tried any of them

Oh yeah it’s a horrible indictment of the American social experiment to assign every freedom and allow every abdication of responsibility for those freedoms

Isn't there an ISO draft for the standard political structure? If not, there should be.

Heh yeah what we need is a standard - cue xkcd

Or an RFP perhaps?