The Heap™ – Consultancy ©®

« first day (4477 days earlier) ← previous day next day → last day (688 days later) »

Zikato

07:07

Wordle 658 4/6*

⬛⬛🟩⬛⬛
⬛⬛🟩🟩🟩
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩

Paul White

07:43

Wordle 658 4/6*

⬛⬛🟨⬛⬛
🟨⬛⬛⬛🟩
⬛⬛🟨🟨🟩
🟩🟩🟩🟩🟩

L by night

3 hours later…

Erik Darling

10:25

🟩🟩🟩🟩🟩

Get on my level

Paul White

I'm surprised to hear you've heard of levels

Compatibility levels to make 2022 demos easier, specifically

Q: Issue with displaying Results to Grid, despite selecting the option

I am a learner who needs the community assistance to better my understanding and proficiency. I appeal for your time and expertise. I am using SQL Server Express 2022 and SSMS v19.0.2, despite having results to grid as the default, I still checked that from tools - options - SQL Query is set to '...

Gosh

Erik Darling

11:01

@PaulWhite sometimes you eat the bear and sometimes the bear eats you

Paul White

So true

Erik Darling

11:58

Maybe that person would enjoy the output clause

Good thing we have J. Drizzle to leave helpful comments

Paul White

Yep, he Excels at that

J.D.

12:58

@ErikDarling Only if Paul continues to decapitalize the words I arbitrarily choose to capitalize. 🙂

It's like an Easter egg hunt.

mustaccio

decapitalize wall street

Paul White

Oh I thought your SHIFT key was sticking

J.D.

Sticky Keys is a Windows feature...

Also, I don't understand StackExchange sometimes. I don't see how my answer on such a trivial thing is worth that many updoots lol.

Such is life though.

Paul White

Hot Network Question

J.D.

Worddd.

Paul White

13:05

I quite dislike product recommendation questions in general

They so often go like this or worse

J.D.

Yet they're valid on here, eh? Only a few weeks ago I Learn.Microsoft.com that from you.

Paul White

They are just ok if they are unusually well-specified

A: Would question about database recommendation be on topic?

database-recommendation questions are not off-topic, but experience has shown that they need to be better than average to avoid being ignored or closed, especially in recent times. Click on that tag to see existing questions. Be specific about the circumstances, requirements, and constraints you...

"better than average" is the euphemism I used before

J.D.

Gotcha. I believe OP did a reasonable job communicating their requirements. Not sure if their specific case is unique enough to be above the average though.

Paul White

Most of the time they're ignored. When they do catch fire, everyone has a product to offer and the details only come out in 683882243 comments spread all over the page

> $product is perfect for this!

Arguments often break out too

And ultimately, the Q & A often ends up being useful for precisely one person

So, yeah, I don't love them

J.D.

@PaulWhite "When they do catch fire, everyone has a product to offer" - It's interesting because that question was rather dormant until after my answer and the question itself received a few updoots. Then the other answers came in.

But I find StackExchange (at least the DBA one) operates like the news in the US. Being first is more important than being accurate, as long as you correct yourself along the way. So it's interesting anyone would offer another answer after the question gets Hot. Seems a little late, if you care about updoots.

Paul White

13:20

@J.D. Exactly. It depends how many see it and how keen they are to offer an opinion. The regulars here generally don't fall into that group and Easter weekend is quiet anyway. The problems start when the great unwashed across the network see it.

@J.D. I think it's not exactly Fastest Gun in the West here. Rather, the first answer tends to be a good one. If it's not, subsequent answers do overtake. But again, it depends on exposure.

J.D.

@PaulWhite I think first to answer is a factor, if the answer sounds reasonable. But I think rep / popularity also plays a role too, especially on helping subsequent answers overtake other answers. I guess there's a few variables though. But in general being first with a reasonable sounding answer appears to be an easy way to gather a few updoots most times, even if it isn't the authoritative or ending answer with the highest amount of updoots.

Paul White

Some of it is just human nature. A popular answer will sometimes beat a technically better answer, it's true.

J.D.

Yea, human nature indeed. Herd mentality I suppose.

Paul White

Not everyone is qualified to judge, and some people overestimate their ability.

Democracy was a mistake

J.D.

@PaulWhite Have an alternative idea? 🙃

Paul White

13:27

Benevolent dictatorships are best ofc

J.D.

Sounds a little contradictory lol

Paul White

I quite liked the Top Answers' idea of giving higher rep users the ability to grant more 'votes' at their discretion

@J.D. That's just because you are overestimating your ability to judge

J.D.

@PaulWhite oOo. That's sounds democratic in a good way perhaps.

Paul White

It's certainly worth a shot. The idea being that users with more experience are more likely to boost better posts

Which is just a system of layered dictatorial benevolence

Meritocracy, perhaps

J.D.

@PaulWhite indeed, given that the higher rep users were technically voted to that place by their peers on here. Democracy at its finest.

Meritocracy sounds better, yes.

Paul White

13:35

The Chinese flavour of democracy, perhaps

J.D.

My favorite kind of food too...

Paul White

Most Asian food is p yummy

J.D.

I'm actually rather big on Thai and Vietnamese, but I'm good for any of it.

Well this has been a Good Morning after a Great Friday, but I'm off to rugby. First game back since the season ended. ✌️Cheers!

Paul White

Yes Thai > Chinese for me

J.D.

🇹🇭

Paul White

13:40

Indian > Thai

Hannah Vernon

14:19

Wordle 658 6/6*

⬛🟨🟨⬛⬛
🟩🟩⬛🟨⬛
🟩🟩⬛🟨⬛
🟩🟩⬛⬛🟩
🟩🟩⬛🟩🟩
🟩🟩🟩🟩🟩

I mean, wtf

Paul White

Looks like a jump off a tall building

Hannah Vernon

14:34

Which is what I considered at the 6th attempt

@J.D. I know Paul already suggested the commenter edit their details into your answer, but there is nothing stopping you doing precisely that, and flagging the subsequently unnecessary comments for deletion.

I'd do it, but I'm a lazy DBA

Paul White

Too busy working on your SQL Server Express Edition answer eh

Hannah Vernon

lol

I was conducting critical research on my wife's ability to whistle

Apparently she can only whistle when breathing in

Paul White

Never mastered that super-loud whistle some people can do with their fingers

But it's not a skill I've really missed

Not heard the only-whistle-in variation before

My wife cannot do a convincing chicken impression

Hannah Vernon

@PaulWhite me either

@PaulWhite now I want to know how and why you know that

I feel like that's a pin-worthy comment

Paul White

14:52

Oh, I went through a phase of making chicken noises now and again, pretty well I think. One day, she tried to imitate me and I didn't stop laughing for half an hour

It may have been a Swedish Chef type thing, I don't recall exactly how it started

Hannah Vernon

LOL awesome. Why were you making chicken noises in bed?

Paul White

Nobody said anything about a bed being involved

Hannah Vernon

I assumed

Paul White

Yep

No, it was an ordinary everyday sort of chicken noise. Casual.

Of the bok-erk variety

Obviously way more sophisticated than that. Limitations of the current medium

Hannah Vernon

oh, I immediately understood the complexity of the Paul White Chicken Call

Paul White

14:57

ah, good

Hannah Vernon

There were undoubdtedly edge cases involved and things no one even knew chickens did. 😅

I hope she upvoted you

1 hour later…

Josh Darnell

16:06

Apr 3 at 13:51, by Paul White

@JoshDarnell Indeed. I hadn't noticed the typo in, "As demonstrated in the db<>fiddle link above, the Id column remains nullable after dropping the constraint using T-SQL." last time I read it.

It is finished.

Erik Darling

16:18

Good morning again

Will the math stack exchange site ever recover?

mustaccio

17:11

Erik Darling

17:39

Well done

Hannah Vernon

@ErikDarling been doing "research" again, eh?

Erik Darling

Might come in handy

2 hours later…

Josh Darnell

19:45

Wordle 658 4/6*

⬜⬜⬜⬜⬜
⬜🟨⬜⬜🟩
⬜⬜⬜🟨🟩
🟩🟩🟩🟩🟩

1 hour later…

Charlieface

21:13

@PaulWhite Oddly enough pinched fingers means "slow down" in Israel.

@ErikDarling Bit weird to have a "favourite quote" in a highly technical doc, but from the introduction, a statement which is untrue in every single word

> C# is intended to be a simple, modern, general-purpose, object-oriented programming language.

Also for sheer language design stupidity I give you Top Level Statements learn.microsoft.com/en-us/dotnet/csharp/language-reference/…

J.D.

21:56

@HannahVernon hmm? I believe Paul already did that earlier on. Or you just mean in general for future reference?

Hannah Vernon

22:25

@J.D. I'm going with the 2nd one

Over 1,200 comments have been deleted in the last 30 days, just for scale of the problem

Over 7,000 since the beginning of year

J.D.

23:02

@HannahVernon heh Coolio.

@HannahVernon crikey.

I'll keep that in mind the next time I'm thinking of commenting something unnecessary, for serious.

Hannah Vernon

Or just add an answer, which you can always expound upon

Paul White

23:33

@JoshDarnell Thank goodness

Josh Darnell

23:49

The nightmare is over.

Erik Darling

👍👍👍👍👍

« first day (4477 days earlier) ← previous day next day → last day (688 days later) »

all rooms

Transcript for

Apr7

Apr '238

Apr9

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