The Heap™ – Consultancy ©® - 2020-10-05

« first day (3562 days earlier) ← previous day next day → last day (1324 days later) »

7:04 AM

Morning

Morning

3 hours later…

10:12 AM

Morning all! Ireland looking set to go back to level 5 lockdown!!!

@Vérace Welcome! Level 5 is more or less restrictive?

@McNets Most restrictive - see here!

@Vérace the most restrictive here is: everyone at home unless you are an essential worker. None outdoor activities are allowed. But well, we have the worse ratios in EU.

10:36 AM

@McNets An excellent site on mortality figures - though I'd have my doubts about the results from certain countries! Germany (don't doubt the results there) seems to be doing very well - despite no lockdown! Ireland in 21st position!

Germany approx. 50th!

10:53 AM

if they gather their results like their auto industry does, I wouldn't put much trust in them ;)
(Germany, that is)

11:07 AM

@ypercubeᵀᴹ things happen everywhere. twitter.com/Reuters/status/1313071436286877698 I don't trust data sent from Madrid where ICU's are at 100%

yes, this is on the news today (the lost data)

I was referring to the emission scandal en.wikipedia.org/wiki/Volkswagen_emissions_scandal

@ypercubeᵀᴹ yes, I remember

1 hour later…

12:45 PM

Auckland will join the rest of NZ at level 1 (least restrictive) this Wednesday at 11:59pm

The broken/outdated links on the election page have been fixed (at this stage, by deleting them). Also, question collection will start today.

1 hour later…

2:17 PM

What "more detail" would this question need than what it has? It seems like the sort of thing that can help someone else in the future

2

Q: SQL Server options that influence log buffer flushing or commits-per-second performance?

I am investigating two SQL Server 2014 instances, both running identical software, both running identical hardware (VMs), both loaded with the same test database, but one with hugely greater performance on a microbenchmark. The benchmark essentially runs the following in a loop: BEGIN TRANSACTION...

sql-server sql-server-2014

@jcolebrand I haven't voted on that one but the comments ask for wait stats

Unfortunately the info was added in comments and not to the question

@TomV it's still early, apparently I need to wait for my coffee to kick in

Wait, you mean "writelog is top of list" is the wait stats?

Cos leaving that in the comments seems fine to me, it shows the conversational nature. We could leave the comment and put it into the question as an addenda note

But one of the answers shows a ref to that so it would be good from the answers alone

I think this is fine personally, so I'm unsure. I wanna flush the close votes if we like it as-is

I have an opinion!

@PaulWhite quelle surprise

You sound like me :p

Comments and "conversations" aside - I think you all know where I stand on that...

It seems like an odd sort of a question to me

> Guess why one of my two systems is slower than the other

There are three answers, but they're pretty much all saying we'd need more info to give you an answer.

2:31 PM

Aye, and the answer of "have your sysadmin look at the disks" is accurate but more importantly (for me) it's a matter of "hey, next person who doesn't know how to troubleshoot this, here's some guidance"

If we remove the opportunity for someone to learn from this one question we see it get asked again.

Why is there an animal in the attic this morning?

Maybe. But we could leave pretty much every question ever asked open on that basis.

The wife is gonna be frustrated when she wakes up ... sigh

If closed ones never deleted it would be fine, but I was under the impression they self-imploded after some period of time. Did I forget a rule change?

@jcolebrand That one is one of the more important pieces of wait stats

@jcolebrand Questions with multiple answers never auto-delete.

@PaulWhite "yet" :p

moderators are also trusted to be able to ask tricksy questions in private chat rooms

Until they aren't

2:34 PM

367

A: How does deleting work? What can cause a post to be deleted, and what does that actually mean? What are the criteria for deletion?

How can a post be deleted? By users: The author can typically delete their own posts at will; for exceptions, see When can't I delete my own post? below. To delete a post, just use the delete link below it, on the left (only available from a browser, not the SE/SO app). Moderators can delete an...

@jcolebrand Yes that's true, the rules could change.

I don't feel strongly enough about it to "vote" to close, but I can see why people would.

Josh's answer is kinda useful.

He doesn't get many of those so perhaps it would be cruel to delete it.

@PaulWhite "for the lulz" and "to get a sick burn in on fellow users" are the two best reasons to leave something open imo :D

Well it has 4 of 5 close votes already so it could get closed at any moment

I do disagree that "conversations" on questions help the site.
The details needed to answer should be in the question.
Always.

Anyway, at this point, the Q & A isn't going to be deleted. The remaining question is whether it should be able to accept new answers in its current state or not.

My issue is that as soon as it gets edited into the Q and we delete the comments then the comments make no sense even if they have value.

that's frustrating to me

to-each-his-own etc

@jcolebrand It is a rare comment that adds long-term value.

@PaulWhite It is a rare question that adds long term value

51

Q: TF203015 The Item $/path/file has an incompatible pending change. While trying to unshelve

I'm using Visual Studio 2010 Pro against Team Server 2010 and I had my project opened (apparently) as a solution from the repo, but I should've opened it as "web site". I found this out during compile, so I went to shelve my new changes and deleted the project from my local disk, then opened the ...

visual-studio-2010 tfs unshelve

2:42 PM

Ooo close votes are down to 3!

Like, why is this still a thing?

and yet, I get rep from it every so often

@jcolebrand Because Stack Overflow

Let's try to aspire to be better than that

@PaulWhite it's me, I retracted my vote

@jcolebrand Following the question edit by @AndriyM, I added Tibor's comment to his answer. The other points raised in comments seem to be covered in answers, so I nuked them as obsolete. I don't think anything has been lost, and it is easier to navigate and comprehend now.

@McNets Ok cool 😎

@PaulWhite oh conversations :D

2:47 PM

I think they have those on Discord

I wouldn't know ... >.>

I've never found a need to join Discord. I've got a login to one somewhere but I literally never go there

Me either, but I hear rumours they have conversations there

I really like the way Top Answers handles comments. I wish SO/SE would do the same.

I don't mind there being a side-discussion at all. I do mind when that side-discussion gets in the way of finding information.

@PaulWhite got an example?

So often I search Google, find a SO or DBA Q & A, then have to wade through a couple of dozen comments just to make sure I haven't missed a vital detail.

It literally happens every day.

The thing is, some to-and-fro is all but inevitable when the question is in the process of being answered.

It's rare for a question to be perfectly answerable right off the bat, sadly.

Once that's done, and the Q is A'd, the comments are almost always a burden.

Future readers don't care about the conversation or what sort of day the OP was having.

They want to see a clear question and one or several useful answers to that question.

See, that's a difference there. I always find the comment stream helpful if debugging took place

Cos then I can check myself on my steps too and also see how they got there

So if the comments were debugging related, then they really do help me, and by that nature, others

2:58 PM

@PaulWhite :o

@JoshDarnell you see nothing ...

@jcolebrand That was more common in the very early days of the site, when questions were few, and people had the time and inclination to really get into each one in comments. Of course, they should have been using chat, but that's another story.

These days, a question needing extensive 'debugging' will likely be closed. We even have a specific close reason for that very case.

It doesn't mean the debugging can't happen, but it does mean the question can't be answered until it is answerable.

@jcolebrand ha ha!

@PaulWhite You and I are talking about two different things I feel like

@jcolebrand Wouldn't be the first time I guess.

@JoshDarnell Is that your rebuttal? 😉

3:05 PM

@PaulWhite I'll let my work speak for itself 😎

Just don't, uh, look at it too closely.

We really ought to raise the threshold for Trusted User eh

What's the aim on show a red dot in Close Votes if I reviewed this queue? To alert someone else?

Sep 16 at 10:55, by Paul White

That dot must be one of the least useful and most annoying features ever

3

yep

It's just stupid

I see a red dot all the time. Even as a moderator, there's nothing I can do about it.

It just sits there being stupid.

Like a comment.

3:10 PM

It's reminding people how badly SO screwed up when they pissed of their higher-rep users to the point they stopped participating

2

heh heh heh

Hey, Close Votes queue can blow up, but...unfortunately you can't do nothing!

I would link to all the red dot explanations on meta, but my heart isn't in it

I try to only link stuff I can plausibly defend

At least on SO there's a mod doing 1,000 - 1,500 reviews / closes per day to help pick up the slack 😅

lol

3:13 PM

@JoshDarnell Feels like that sometimes. I did 90 in a day once. That was wearing.

I've really noticed the extended lack of regulars in the review queues.

I do understand why it is and don't fault them at all.

@PaulWhite I maxed out reviews on SO for a bit when I first got the privilege.

@JoshDarnell Yes I did too.

The queues on SO at the time were astronomical.

Like 50k or something.

Good morning

@bbaird morning

@PaulWhite I've only done 74 CV reviews here 😬

3:18 PM

@JoshDarnell Slack

I wish I didn't see so many questions that I feel uncomfortable voting on.

Like non SQL Server questions.

Have you tried sitting on a cushion?

@PaulWhite -_-

HtH

There is some work going into the review queues so perhaps they'll be more pleasant in future.

I would imagine that would include some filtering.

And no red dots.

user image

I'm here to change lightbulbs :p

@JoshDarnell Shall we have a race then? First to 100?

3:34 PM

@jcolebrand Sure! Winner gets all of Paul's rep.

I am leaving it all to Community♦ in my will

4:09 PM

Slack has an outage, developers' productivity is rising worldwide ;)

@ypercubeᵀᴹ it seems that Greece will hold a MS Azure Datacenter soon. t.co/yIaQuUHN2Y?amp=1

4:27 PM

Well, I haven't got a lot of work done today, but on the other hand I haven't doom scrolled twitter so I think I'm feeling a little better.

@bbaird "doom scrolled"?

@PaulWhite when you just read your timeline knowing it's going to be nothing but upsetting/enraging news

TIL, thanks!

@McNets interesting

@McNets - it appears that the Government is ignoring NPHET's advice and only moving the entire country to Level-3 restrictions!

4:35 PM

@Vérace as usual everywhere! Money first.

Hey @McNets I hope I'm not being ignorant, but is this in a language you could translate for us? dba.stackexchange.com/a/276532/1192

Theoretically Madrid is blocked right now, but you can take a flight or a train and nobody is controlling you.

@PaulWhite it's Portuguese

I could try

@McNets Don't worry about it. I know the author speaks English because they have English answers elsewhere on the network. I'll just delete it for now and hope they update it. Thank you.

@PaulWhite 👍

I can never tell the difference between Spanish and Portuguese.

Sorry.

4:46 PM

@PaulWhite No worries.

@Johnakahot2use Just FYI dba.meta.stackexchange.com/q/2739 is now under active consideration.

@McNets My partner works for the tax authorities and makes the point that if nobody's working, then nobody's paying tax and that the Health Service would grind to a halt (cancer screening &c...) and that people would start dying because of this also! Rocks and hard places come to mind! :-)

@Vérace that's true, but if hospitals are full of covid-19 people, they will die too.

5:03 PM

Weird. Two questions, one for for MySQL and another for SQL Server, posted with 10 min difference, with essentially the same problem, albeit different details and OP.
https://dba.stackexchange.com/questions/276542/unique-like-constraint-in-a-complex-scenario
https://dba.stackexchange.com/questions/276540/mysql-constraint-to-prevent-combinations-of-columns

and on a meta-meta-level, the same user posting identical comment on both ;)

🤔

John aka hot2use

5:36 PM

@PaulWhite thanks for the heads-up

Morning

2 hours later…

Master Database

7:12 PM

0

Q: 2020 Moderator Election Q&A - Question Collection

DBA is scheduled for an election next week, October 12, 2020. In connection with that, we will be holding a Q&A with the candidates. This will be an opportunity for members of the community to pose questions to the candidates on the topic of moderation. Participation is completely voluntary. Her...

discussion featured election

7:56 PM

I guess today is "downvote the answer I submitted last week" day.

1 hour later…

9:10 PM

@PaulWhite reddit.com/r/PoliticalHumor/comments/j5gl3h/… doomscrolling

« first day (3562 days earlier) ← previous day next day → last day (1324 days later) »

Transcript for

Oct '205

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile