TopAnswers
or
Meta Question: How can we make db<>fiddle (and integration here) better?
Jack DouglasJack Douglas
What is the best method to restrict certain entries from taking on certain values
(asked)
Incorrect Result with Apply
Phist0nePhist0ne
sql-server
SQL Server unpredictable select results (dbms error?)
Ryszard BocianRyszard Bocian
sql-server-2012 sql-server-2008
Can I prevent users accessing data in global temporary tables?
Joe ObbishJoe Obbish
Why filtered index on IS NULL value is not used?
jerik1jerik1
sql-server
Ignore accents in 'where'
lumolumo
sql-server-2008
What is the best way to transfer encrypted columns via flat file?
JamesJames
sql-server-2014
Why does @@dbts increase after backup/restore?
StijnStijn
sql-server
Shared Lock issued on IsolationLevel.ReadUncommitted
dsumdsum
sql-server-2008
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