@J.D. yes but they claim heaps of things that aren't true like landing men on the moon

@PaulWhite Don't be jelly that the United States of Freedom and Bald Eagles is the only country to ever land on the 🌝

@ypercubeᵀᴹ thanks. I ll ask them.

@PeterVandivier The only difference is when a user has heaps of votes, then they're transferred to the Community user so people don't lose out. That said, it is possible to undelete a user, but it's a very manual process requiring SO dev involvement. Merging a new account with an old and deleted account would likewise be possible, but unpopular.

As I understand it, deletion is mostly a soft deletion (unless performed for legal reasons).

Daylight Saving ends in a few hours 😢

@J.D. that's sarcasm, right?

@J.D. to ever land men you mean ;)

Oh I don't know, some recent US history suggests they may not be on this planet

conspiracy theories?

I usually counteract the theory that NASA never landed on the moon with the one that says that there is no Americas and the whole Columbus discovery was fake.

Everyone's got a theory

that's just what they want you to think

Good luck getting people to think

i'd prefer if they like and subscribe

@HannahVernon more like American stupidity baked into the arrogance too. 😉

Good morning.

@ErikDarling Did you ever run the Ozar consultancy challenge script? 2016 v 2019.

@PaulWhite i hadn't gotten to it, no

fair enough

did you?

status unchanged

I just happened to come across yet another link to the blog post and followed it to see how the comments went

Dr No chipped in with some links about Spectre/Meltdown and Kejser suggested running xperf

100,000 other people just mashed their keyboard and hit enter

joe chang is also unchanged

oh yeah

What are y'all on about?

Cheers

Transcript as a Service

We all need a Paul as a Service in our lives.

Increasingly of the opinion we should delete the account of anyone posting a new question as an answer

Time and again, I see these go through review, get the usual (helpful) canned advice and eventually deleted. They're then reposted exactly as a new question without a moment's thought given to formatting, presentation, or answerability. The new question gets comments asking for clarity, down votes, and eventually closed. User abandons question. Heaps of effort.

whatever happened to that question asking wizard that was supposed to guide users towards better quality questions

was it not welcoming enough

I think they decided on SO it was hard to maintain and cover all cases adequately so we all got the cut-down version of self-review currently in place

wouldn't it be sensible on more specific sites

or am i missing something

For the most part, people just do the bare minimum needed to click through without errors

next-next-accept agreement-finish

@ErikDarling You're missing the fact that no one wants to put the effort in

Especially for not-SO sites

no i understand that

More to the point, not every potential question can or should be saved

A 'wizard' that simply graded the first effort and deleted the user if it failed to pass would be better

The latest example got through while not improving the question body one iota. It did add several irrelevant MySQL tags

Perhaps a redirect to reddit or chatgpt would be the ideal

> We have successfully posted your question to Reddit. Redirecting in 5 seconds.

we should have an open queue/vote system for new user questions

oh yes the sandbox idea

that's floated around for a while

(from 2014)

i feel unwelcomed by that answer

Things are v different these days

ISTG if I see one more post about AI this week

What do I swipe and in which direction to get a new Current Thing

just have to wait for it to burn out

have a drink and take a nap

read a book

good advice

write frightening verse to a buck-toothed girl in luxembourg

payment sent

It is now 2am for the second time today

remember what they stole from you

top wordler

non-top wordler :)

When developers attack: dba.stackexchange.com/q/325503/32281

@ErikDarling The tabs might be a bit more complicated

Tab works as a multiple of length (4 in this example). So replacing \t with 4 spaces might mess up the formatting.

If you’re going for prettification to that standard, pure powershell probably won’t cut it

Or rather… it might but it’ll be spaghetti code with edge cases that annoy you

Sounds like power shell

@ErikDarling 🤔 well you could sort of achieve that by checking elapsed time in a different way using various DMVs to avoid the runtime constant thing but it wouldn't exactly stop the query just prevent more rows being returned. A cursor and client side timing check could work too. But yeah silly idea

@Zikato but achievable given fixed tab stops?

My wife did 5/6* Wordle today she's so lame lmao

lol

relationship goals

@PaulWhite well V1 has "replace all tabs with 4 spaces". I'm tired.

There’s ways to do that but… 🍝

but… perfume?

(spaghetti)

Speaking as someone who has done a lot of tsql text prettification in powershell

I did that before. You just have to work on strings on char at a time

$tabSize = 4
$charIdx = 6

# Gives you the amount the tab will represent - 3 here
$tabSize - (($charIdx - 1) % $tabSize)

galaxy brain dot gif

Some weird people use a two-space tab size

But yeah, modulo

There'll be someone out there using 4 for the first tab stop then 2 after that

Anyone using tabs doesn't care about formatting anyway

"Works on my machine"

I spent most of the time on the github action figuring out the files changed and how to commit and push back. And I'm not even sure it will work properly for PRs or forks

I mean… it’s an actual accessibility thing when you drill down deep enough. Consistent indentation is a support issue for folks with visual impairment

Yeah but fuck those losers right

but the CRLF fix was easy enough - github.com/amachanic/sp_whoisactive/pull/96

@Zikato No one is ever sure anything github will work

I've heard Paul is expert on git

But one feels productive, which is the main thing

yeah, GitHub has more green squares than Wordle

Excellent point

@PaulWhite that’s a lot of words to say no.

Git as next level Wordle. I like it

@ErikDarling It would be, but the whole answer isn't "no". Given certain restrictions the answer could be "yes" but it's still daft.

I am specialising in saying "no" using many words today

Not as many words as Jay Dee spends being wrong, but hey

We're all on a journey

Don't stop believin'

Yikes

Anyway, it's getting late here

@Zikato what if there's an embedded CR or CRLF in a t-sql string?

???

@Zikato Try setting your clocks back

will that help my brain?

Somehow, I'm even more confused now

Fucking chat markdown

@Zikato Not if you embed CR or LF in strings, no

\u000d

@PaulWhite I’m still reading no here

\nou

@ErikDarling bouncer brain

Easier than putting lipstick on a pig, but not easy

@HannahVernon git-scm.com/docs/gitattributes#_text - It stores all the files as LF but changes the line end for the local copy on checkout

@PaulWhite I mean if you wanna explore 14 million timelines and find one that works cool

@Z I think the question is how you handle line breaks and carriage returns embedded in a string literal

That’s a lot of no though

Ok. For the simpletons of New York, the answer is "yes, but"

Or "no" for short

Jeez

Is that picture from a dream you had of having a garden?

@PaulWhite I'll test when I wake up

Set your sleep forward an hour?

I am hanging out in my back yard

In any case, you could fix it with Power Shell

@ErikDarling don't get lost

In the forest

That seems like a good forest for getting lost in

tbh

@PaulWhite lol you nailed it

Like Jesus

When he built a canoe

@PaulWhite sometimes you gotta be wrong to be right.

@ErikDarling cleared up into a pretty unexpectedly nice day today, eh?

It has been nice all day here

@PaulWhite I wonder if that's @Forrest approved

Might get a tornado later or something

Is that a drink?

Isn't everything

Cloudy here

@ErikDarling ah, we got a lot of rain out this way today. Was supposed to keep on all day / night, but cleared around 3 and been sunny since.

Seems to be something afoot now

@PaulWhite someday.