The Heap™ – Consultancy ©® - 2017-02-26

« first day (2245 days earlier) ← previous day next day → last day (2630 days later) »

3:16 AM

I was poking around and found this amusing thing:

947 3 8 13

c# decimal opacity type-conversion winforms

@EvanCarroll Wait, was your suspension queue question actually serious??? meta.stackexchange.com/questions/59806/area-51-suspension-queue

@ypercubeᵀᴹ Why is M always talking about how long he's been doing things? dba.stackexchange.com/a/164529/6236

Most people don't go around talking about how they've been coding since they were x years old and have y number of years under their belts and so on. I don't, unless I'm trying to get a job or am dealing with someone who is stating their own number of years, committing the fallacy of authority to try to strengthen a position.

1 hour later…

4:30 AM

Or am I just virtue signaling by saying this? That wouldn't be good, either...

1 hour later…

5:51 AM

@ErikE Virtue signalling?

6:18 AM

@PaulWhite That's when you do something to make yourself look good to a social group, usually by saying you hate something else but sometimes the opposite; and don't actually embody the virtue you pretend to hold but merely want to be seen as having it.

Ah, thanks. Hadn't heard that one before.

@PaulWhite If ragging on someone boasting to say that one doesn't so boast, is itself a form of boasting, then I guess I did it.

I didn't read it that way, if that helps at all :)

@PaulWhite Sure. :)

6:47 AM

@PaulWhite Hey, wait, is signaling one of those words that Americans spell differently (one ell versus two)?

Apparently yes en.wikipedia.org/wiki/Signaling_(telecommunications)

1 hour later…

7:58 AM

hi

Is it excessive to have 5 foreign keys in a table used to identify a row?

I haven't shown draw them the relationships, but i think it will be clear from column name

user image

Another alternative could be this one.

user image

Which one do you think better? when is one preferred?

is anyone here?

9:18 AM

user image

found on the interwebs today ;) From the C++ Lands blogpost

@Anwar it's Sunday, not many people around. I suggest you post the question at our site.

But add details of your analysis, how you came up with the design(s) you are considering, and especially the business details (how the entities are related, etc)

@ErikE He probably thinks that it strengthens his position. "I am working with SQL Server for 17 years and I haven't encountered this. So it must be rare" (something like that).

Which is of course not (strengthening).

It's like saying that partitioning doesn't have effects on execution plans. But hey, I haven't seen any in 17 years I've been using Expess edition.

9:50 AM

His high (I guess) IQ score in combination with the fact that the whole class of freshmen didn't believe him when he was teaching them the Monty Hall problem is another thing that he probably thinks backs him up in his insisting that he's right.

Apparently a class of freshmen and a group of professionals speaking from their experience (rather than beliefs) is the same thing in his eyes.

10:10 AM

@AndriyM Yeah. Plus we don't really know what he tried to teach with the Monty Hall problem.The story of that problem shows that it has confused even professional mathematicians.

2 hours later…

11:44 AM

@ypercubeᵀᴹ My favorite way to explain the Monty Hall problem is: instead of removing one of the doors, the host combines the prizes from the other two doors you didn't pick, to behind a 4th door. He also says that whatever is inside, you can only get one prize (the better one). In fact, he's removed all prizes you can't win.

Some thought should show why this scenario is equivalent to the one given, but I think it might help people who struggle with it because it emphasizes the combined probability instead of the tempting two doors = 50/50 mistake.

@ErikE Nice! I hadn't thought of this explanation.

@ypercubeᵀᴹ Oh. I didn't consider the weekend. We have friday as weekend here. Thanks for the suggestion

@Anwar Interesting! Where's that?

I'm from Bangladesh.

And Friday is the usual non-working day, while Sat and Sun are working ones?

11:57 AM

Yes.

Didn't know that. It seems it's common in many countries.

@Anwar So you work 6 days a week?

Wikipedia says that the working week is Sun-Thu there. @Anwar, do you have days off at Friday and Saturday?

Voting to close. Without more details - the whole query, table definitions, indexes and an execution plan - this cannot be answered. — ypercubeᵀᴹ 26 secs ago

1:03 PM

@ypercubeᵀᴹ To be fair, earlier they were asked to provide table definitions only including the relevant columns, which they did.

With poor formatting it was probably not immediately noticeable.

@AndriyM Yes, I saw them only after commenting.

1:30 PM

@ypercubeᵀᴹ Friday. Govt weekdays are Sun-Thu however some companies observe only 1 weekend, Friday.

Though It's sunday here

4 hours later…

5:18 PM

An interesting but quite lengthy read: The Marathon Man

5:29 PM

Hi @ypercubeᵀᴹ

hi

morning

hi

5 hours later…

10:47 PM

@ryanyuyu My experience with this site so far (and that's mainly in DBA Stack Exchange) is that passable content rises to the top. But I've seen a ton of questions where the best answer is at 0 or even in negative territory, because the answer is controversial. My best post, because it attempted to dispel a common misconception, is also my worst rated answer. It went negative because most people still hold the misconception. — Matthew Sontum yesterday

and

@BSMP I'm not sure about questions, but definitely answers, for subjects I am an expert in. I don't like it when misleading answers bubble to the top as they often do. I mainly have experience with the DBA Stack Exchange, so I don't know if it is a problem everywhere, but in the DBA Stack exchange I am constantly seeing bad answers bubble. I suppose in Meta as well. Take this question, every answer but the top rated one is solid. — Matthew Sontum 22 hours ago

(the top rated one is by Shog and at +250 ...)

@ypercubeᵀᴹ For someone who apparently hates, so much, being at StackExchange sites because of how bad everything is, he sure hangs around and participates a lot.

@ErikE only until he builds his own Q&A site ;) (stackoverflow.com/questions/42463504/…)

11:05 PM

> Since I already know SQL Server inside and out […]

Hmm…

So that's why he doesn't need execution plans.

I never heard that expression before that way. "inside out", yes..

Is it common in America to say "inside and out"?

@ypercubeᵀᴹ I think it makes sense to say it that way, especially because "inside out" refers to the inverted position of an item that has a distinct physical inside and outside (like, "when I realized my shirt was inside out, I ducked behind a bush and turned it right side out").

I've seen it in blogs and books.

on

@McNets on blogs and in books is best, "on books" is definitely wrong, "on blogs" is okay.

@McNets So the way you said it originally works :)

@ErikE ;) thanks.

11:14 PM

@ypercubeᵀᴹ In fact, I would probably get great pleasure from thinking about what it means to know a database "inside out". I'd imagine how a database could be physically everted, so that one could get experience with it to say one "knows it" that way.

@ErikE I

@ypercubeᵀᴹ Wait, how does he know that the worst answer won't be upvoted to the top and he'll be badly deceived as to the right way to go!?!?! I though that was an endemic problem with SE sites.

sorry, misplaced something

@ypercubeᵀᴹ Frankly, hearing someone suggest WebForms is, to me, like someone asking if I would like them to smear dog feces onto me.

Uh, how about "no thanks"?

I wouldn't know. I'm a Linux guy. SQL Server is the only thing I touch from MS technologies, although I was tempted in the past to play with C#

(and some experience, in the very long past, with Access)

11:22 PM

@ypercubeᵀᴹ If you want to do asynchronous, why you would start with WebForms is completely beyond me. You'd use ASP.Net MVC 4 w/ Razor syntax and then pick something, anything... Angular, React, etc. I don't even know what. Someone suggested others. Telerik, DevExpress, sencha, Syncfusion, Ignite UI. Just not WebForms.

11:36 PM

Have you used dbfiddle after SqlServer2016 has been added?

It seems to run slower.

« first day (2245 days earlier) ← previous day next day → last day (2630 days later) »

Transcript for

Feb '1726

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