The Heap - TopAnswers

Max replying to Erik Darling

I deleted my dba.se answer, FYI

Max

I don't think, in the end, it would have been super helpful.

Josh Darnell

@Jack whenever you're around, could you grant Max access to STMGR?

Josh Darnell

Jeez, the query in the CXCONSUMER question has done 44 GB of tempdb allocations.

Josh Darnell

Maybe some huge tempdb spill leading to the CXONSUMER waits.

Josh Darnell

And tempdb seeming to be inaccessible.

Max

I'd love to be able to import questions from dba.se too

Erik Darling replying to Josh Darnell

i bet they're parallel spills

Josh Darnell replying to Erik Darling

I bet you've got a repro for that.  Parallel spills showing as long CXCONSUMER waits.  Right?

Josh Darnell replying to Max

Don't be shy about asking @Jack for stuff like that.  He loves when we ask him to do stuff.

Erik Darling replying to Josh Darnell

i can find out in a minitue

Erik Darling

yep, tons of it

Jack Douglas replying to Josh Darnell

@Max you should be able to chat in stmgr now. You can switch rooms with the dropdown in the chat footer below ↓↓↓

Jack Douglas replying to Max

and you should find the 'import' button in the header (top left) now too :)

Jack Douglas replying to Josh Darnell

sad but true :P

Max replying to Jack Douglas

Cheers, Jack!

Max replying to Jack Douglas

and that works, too.  Fantastic!

Max

I have a question about importing an answer of Sean's - details are here.  https://topanswers.xyz/databases?q=542#question

Josh Darnell replying to Erik Darling

Send repo plz

Josh Darnell replying to Jack Douglas

I knew it!

Max

@jack - just pinging you regarding https://topanswers.xyz/databases?q=542#question

Josh Darnell replying to Max

One more thing, sorry if I come across like I'm following you around and correcting you.  But make sure you click the identicon on the right to generate a ping.  You'll see a message above the chat window whenever a message will ping someone.

Josh Darnell

Unlike SE, just typing @jack doesn't ping Jack.

Paul White replying to Max

@Jack The error message importing Sean's answer is:  
```none  
23514: ERROR: new row for relation "account" violates check constraint "account_account_name_check" DETAIL: Failing row contains (738, Sean says Remove Sara Chipps, 2020-01-10 04:15:27.279779+00, 2020-01-10 04:15:27.279779+00, null, 1003, 0d49573e-1dbc-45a1-9751-e69dcd4efcf2, f, 4, 1, 58276, t, \xe73a996729430ea87a78e9abe2babef7f33492379159b192a9405b8dcde2f6...). CONTEXT: SQL statement "insert into account(account_name,account_license_id,account_codelicense_id,account_is_imported) values(trim(regexp_replace(seuname,'-|\.',' ','g')),4,1,true) returning account_id" PL/pgSQL function import._ensure_seuser(integer,text) line 8 at SQL statement SQL function "new_answer" statement 1  
```

Josh Darnell

> new row for relation "account" violates check constraint "account_account_name_check"

Josh Darnell

Maybe there's a check for "Sara Chipps" in there...:P

Josh Darnell

By the way, you know you're in a rocky spot with your users when you have to prefix a blog title with "[Humor] "

Tom V

Morning

Paul White

hi

ypercubeᵀᴹ

morning

Jack Douglas replying to Max

can you check with Sean if he minds having his accounts linked here? If so the name length constraint won't be an issue.

Erik Darling replying to Josh Darnell

come to my precon in chicago 😏

Tom V replying to Josh Darnell

Well it wasn't funny

Paul White

Things that need a [humour] tag rarely are

Tom V

Maybe if they explained it at great length it would be

Josh Darnell replying to Erik Darling

💩

Max replying to Josh Darnell

stalker.  But, actually thanks for all the halp.

Max replying to Paul White

that's the one.  I didn't want to paste the actual error here in case it sticks around for "eternity" since it contains table names etc.

Max replying to Jack Douglas

sure, I kinda assumed he'd already be here

Max

linked I mean

Tom V replying to Max

They are on github anyway

Max replying to Tom V

ahh.

Max

@Jack re the [non-PII profile thing](https://topanswers.xyz/transcript?room=2&id=307#c307) - it seems to me you might be inviting bad behavior that would be untraceable by not storing some kind of PII about each user.  I'm not sure what the laws are in the UK around that, but you have time to work that out before it becomes a problem, I suppose.  *Maybe you could cover that in a CoC or something*.  /jk

Max

I hope you haven't already discussed that at great length, btw

Max

because I hate making you rehash stuff for no reason.

Max

maybe I'll just shut up now :-)

Tom V replying to Max

We could be the next 4chan

Max replying to Tom V

exactly what I was thinking

Max

FYI, TopAnswers was the first tab I opened this morning.

GeorgePalacios

Hey all

GeorgePalacios

Happy new year

GeorgePalacios

I am returned once more

Max replying to GeorgePalacios

Happy New Year to you, too!

Max

also Happy New Decade.

GeorgePalacios

yeah you too

Josh Darnell replying to Max

No problem!

Paul White replying to Max

What sort of bad behaviour?

Max replying to Paul White

reasonable question, Paul.  Any messaging that could be detrimental to the site.  I realize it could be quickly "moderated", so perhaps it's not an issue.  And I like the idea of not storing PII unless strictly necessary.

Max

Is [this](https://topanswers.xyz/databases?q=548) a known issue where <pre> doesn't format correctly?

Jack Douglas replying to Max

yes, our markdown doesn't allow any html at all — everything is through markdown extensions

Jack Douglas

so you need to replace <pre> tags with ` ``` ` blocks

Max replying to Jack Douglas

ahhh, cool.  thx

Jack Douglas

some things get converted automatically on import, I'm not sure whether that's something we could add (auto-converting <pre> to ```) , but I don't think <pre> tags are that common on SE…

Max replying to Jack Douglas

probably not all that common, although there are lots in my answers :-)  Also, is there something I can do to control line-wrap?  (I reformatted it, and the wide table looks goofy).

Jack Douglas replying to Max

I think that might be a bug — that used to work. I'll take a look and see if I can figure it out!

Max replying to Jack Douglas

cheers, and best of luck!

Jack Douglas replying to Max

fixed!

Jack Douglas

needs refresh

Max replying to Jack Douglas

thank you.  so much better!

swasheck

  
"used to work"

James

wow, this is pretty fancy

Martin Smith

It is indeed! Are there many questions being asked here yet?

Max replying to Martin Smith

we're mostly migrating great questions from dba.se over here currenlty - hoping to gain traction.

Max

I know where *I'll* be asking questions, heh.

Martin Smith replying to Max

cool, are there any sorting options for the questions shown to the left of this or just one order currently?

Martin Smith

I see a new question!

Max replying to Martin Smith

@Jack is there question order sorting in the works?

Martin Smith

Specifically it might be good if they were ordered by original creation date so recently migrated questions don't push newly asked ones down

Jack Douglas replying to Max

yes in the works, and fairly high priority now.

Jack Douglas replying to Martin Smith

Hello Martin :)

Jack Douglas

and @James too!

Martin Smith

Hi Jack! You look as though you have been busy. Did you write all this site from scratch?

Jack Douglas replying to Martin Smith

yes we did, we started [on 14th October](https://github.com/topanswers/topanswers/commit/10e37242ca8e41c1faa0e49f2f6e1d5ee8ddc863). There are still quite a few rough edges…

Jack Douglas

we = me and James my son

Jack Douglas replying to Martin Smith

can I link your 'fake' profile to your real one? I think a fair number of your answers have been imported.

Jack Douglas replying to James

@James thanks very much for posting your question — that's the only thing we ahve been lacking!

Martin Smith

Most impressive! Yes please on the profile linking

Max replying to Jack Douglas

Sweet!

Jack Douglas replying to Martin Smith

'tis done, thanks

Martin Smith replying to Jack Douglas

👍

Paul White replying to Martin Smith

Welcome Mr Smith :)

Martin Smith replying to Paul White

Thank you!

ypercubeᵀᴹ replying to Erik Darling

that's a nice title for a blog   
SQL Server Mysteries

Paul White

Isn't that the title of Sean's blog?

Tom V replying to Paul White

Bob Dorr IIRC

Paul White

Oh yes Sean's avatar was Unsolved Mysteries for a while, that's what I was thinking of

ypercubeᵀᴹ

USSR  
Unsolved SQL Server Riddles

Andriy M

USSR on the one hand and SQL Server on the other... Off the top of my head, I could think of at least one person who'd probably have mixed feelings about that

Paul White

Evans above

Andriy M

You're probably right, he would be above that