« first day (2101 days earlier)      last day (2768 days later) » 

ypercubeᵀᴹ
ypercubeᵀᴹ
12:10 AM
@PaulWhite no worries.
I've relaxed a bit lately. Should have reached 1K flags by now,
 
avitex
avitex
12:59 AM
Howdy strangers, would like to know if I am starting to go overboard with references, (integrity?, normalization?).
First off, I have this example design (https://i.gyazo.com/8da768ad117c1b6467c4a37edefa5171.png), do tell me if anything jumps out as silly.
The idea with groups for example, is I can JOIN entities, type and ?groups to get all the information about a particular entity. Is this silly? Should everything should just work off entities, for example group_members, even if there are no other columns in the group table other than the primary key? My reasoning behind designing it this way, is to separate some concerns, for example, not every entity is a group.
 
 
4 hours later…
Tom V
Tom V
5:20 AM
@PaulWhite I got a ping about the schemabinding, I see what you mean but I'm not sure how to word it better
indexed view is intrinsically schemabound? does that sound better?
a chicken is an animal but an animal isn't necessarily a chicken if you see what I mean
 
Andriy M
Andriy M
6:18 AM
@avitex If groups is an abstraction for teams and orgs, perhaps the latter two should be referencing the former. Other than that, everything makes sense to me so far. I'd probably take further steps to make sure a users.entity_id cannot reference an entities.id whose type is O or T.
 
 
3 hours later…
Phil
Phil
9:04 AM
Morning, peons
 
War
War
9:16 AM
lol mornin
 
ypercubeᵀᴹ
ypercubeᵀᴹ
morning
 
 
1 hour later…
Paul White
Paul White
10:33 AM
@TomV Me either, hence (removed).
 
Phil
Phil
11:26 AM
 
 
1 hour later…
Aaron Bertrand
Aaron Bertrand
12:37 PM
sigh What RAM could possibly use a clean just installed SQL Server? — yaapelsinko 10 mins ago
Seriously SQL Server is too accessible
 
Tom V
Tom V
@AaronBertrand Not sure how his express instance would take 10GB rightaway though
 
Lamak
Lamak
@AaronBertrand and he starts with a sigh
siiigh
 
Aaron Bertrand
Aaron Bertrand
@TomV I don't know that it does
 
Tom V
Tom V
1:00 PM
@AaronBertrand He claims so
unless I misunderstand him
Still, not worth much effort probably
 
Aaron Bertrand
Aaron Bertrand
Well he also claimed SQL Server is only using 200mb of memory, so I have no idea where he's getting his data from.
 
Tom V
Tom V
LPIM and taskmanager is my guess
But you ask for clarification and he sighs, so....
Pearls before swine
One last attempt
@yaapelsinko could you answer Aaron's question about where you check your memory usage? I don't think the question is overly clear at the moment. Also what are the min/max memory settings on your SQL Server instance, and if you say there are other applications on the server, which ones? What is their memory usage? You say SQL uses 200MB memory, so why do you think it's SQL taking up all the RAM? Please clarify your question. — Tom V 16 secs ago
 
 
1 hour later…
billinkc
billinkc
2:38 PM
 
JNK
JNK
3:17 PM
Yeah I got an email on that, @billinkc
there's a webinar Friday!
I do love me some SQL Sentry too
 
 
3 hours later…
Phil
Phil
6:29 PM
The review queue needs some proper love
 
Tom V
Tom V
7:16 PM
@Phil skipped some, reviewed most of them
 
Lamak
Lamak
but you skipped some....slacker
 
Tom V
Tom V
@Lamak Prefer not to interfere in things I don't understand
But I agree I'm often slacking
or lacking
 
Lamak
Lamak
or both
 
Tom V
Tom V
at least I'm honest about it
drops the mic and walks away
 
Lamak
Lamak
did....did you call me dishonest?...and did you just drop a mic like that?
 
Tom V
Tom V
7:21 PM
Not really, just trolling
 
Lamak
Lamak
Ah, ok. Because mics don't grow up in trees
 
Tom V
Tom V
I should walk away more often I guess
 
Andriy M
Andriy M
They never grow up, I hear.
 
ypercubeᵀᴹ
ypercubeᵀᴹ
8:11 PM
useless fact: my rep at SO is 77777
 
Lamak
Lamak
@ypercubeᵀᴹ you were saying...?
 
Tom V
Tom V
Could we downvote enough to get it to 666?
 
Lamak
Lamak
@TomV kinda hard to pull off
 
Tom V
Tom V
@Lamak Oh I thought it was your rep
But that may prove even harder
 
Lamak
Lamak
@TomV that would be easier
 
swasheck
swasheck
8:21 PM
> CNN's KFILE has now uncovered two more Playboy videos in which Trump makes an appearance, including one in which he is depicted photographing fully clothed models with a Polaroid camera and conducting an interview with a potential Playmate.
"it's for work research! i SWEAR!"
 
Tom V
Tom V
@swasheck On another note, watching a lot of rallies and debates including last nights debate
Unfortunately y'all can't just pick Pence and fire the rest, he seems to be the most sane of all the runners so far
s/the most/the only/g
But yeah, unfortunately Trump is the nominee
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@ypercubeᵀᴹ - I think I understand how the site works (even though I don't like how it works in many respects). Give Gordon time to edit his answer; the OP just answered the question I asked in a comment. If I had gotten to it sooner I would have edited Gordon's answer already. (Done now!) — mathguy 6 mins ago
Gordon's supporter ...
 
Tom V
Tom V
oh and 86 left :)
 
Lamak
Lamak
@ypercubeᵀᴹ he seems to have some followers. I swear that his answers get insta-upvotes the moment he post them
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@Lamak now I have to find 10 answers to downvote ...
@Lamak Yeah. I don't mind that.
 
Lamak
Lamak
8:29 PM
@swasheck I'm still baffled that he really is a candidate for president for you guys
I'm not even joking
 
ypercubeᵀᴹ
ypercubeᵀᴹ
But really defending a obviously wrong answer.
 
Tom V
Tom V
@Lamak He would have lost by a mile against anybody but Clinton
 
ypercubeᵀᴹ
ypercubeᵀᴹ
And accusing someone else because they answered correct? And because they could have instead edited Gordon's answer? Why a 80 rep guy go and edit a 400K SQL "God"?
 
Lamak
Lamak
@ypercubeᵀᴹ I do, because they don't check if his answers work. Many times his first revision is broken
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@Lamak as it was this time
still was in +3 when I checked it
 
Lamak
Lamak
8:30 PM
@TomV but he is till there.....I can't understand it
 
Tom V
Tom V
@Lamak I follow it closely, it wouldn't be wise to get in an online discussion, but I do
To be honest and it's not an endorsement but I think he'll win the general election too
 
Lamak
Lamak
@TomV that would be just ridiculous
 
Tom V
Tom V
@Lamak Why? The opponent is equally weak?
 
Lamak
Lamak
I can't believe you guys would willingly choose someone like Trump to be your president
 
Tom V
Tom V
I have no choice and I probably wouldn't vote if I had to choose between Trump and Clinton, but I see why people dislike Hillary
And I see why people dislike donald too
 
Lamak
Lamak
8:36 PM
@TomV yeah, but....I mean....she can speak, and write....and I don't know, she can lie better?. Trump lies about what he just said
 
Tom V
Tom V
The thing is, he has no documented political history, she has
 
Lamak
Lamak
@mathguy now, you can have your opinion on what was the correct way to face this issue (and I disagree with yours), but the answer was objectively wrong, and this one was right. Why do you keep saying it wasn't wrong is a mystery to me — Lamak 3 mins ago
 
Tom V
Tom V
There is no Benghazi, national security on email server, etc on him, not because there isn't but because he was in the shadows back then
Her mistakes are out in the open, his are not. And that is a lucky coincidence for him but could work out in his favor
 
Lamak
Lamak
@TomV but there's so much on the way he makes business. And all the lies, with absolutely no respect to just lie directly to your face about public things
 
Tom V
Tom V
Also, a lot of people have had enough of classical politics
He lied about a lot, and she lied too, except her are documented and his aren't so much (not to the FBI for example)
but I agree he's an unguided missile don't get me wrong
And US elections are a joke anyway, you mostly need to flip a few swing states not popular vote
 
JNK
JNK
8:40 PM
@TomV it's a SPECIAL PROCESS :)
 
Tom V
Tom V
Again, don't misunderstand me, I'm not endorsing anyone (I couldn't endorse any of the current candidates)
 
Lamak
Lamak
@Lamak - please read the very first comment under Gordon's answer. You will see that I asked the OP for clarification. It is entirely sensible that, without further clarification from the OP, one might assume that the values of CC_CODE were restricted to the same small number of values. They aren't, which - with that knowledge - makes the answer incorrect. In the same comment, before the "new answer" was ever posted, I also suggested how Gordon's answer can be easily adapted to the more general case. Do you see it now? Do you understand why I didn't like the hijack? — mathguy 3 mins ago
 
Tom V
Tom V
get Ohio and flip Florida, all done
You can win with 35% of the popular vote, that's insane
 
Lamak
Lamak
@TomV yup, it is
 
Tom V
Tom V
And I seriously think he'll do it
 
Lamak
Lamak
8:43 PM
@TomV I don't think so. We can make a bet
 
Tom V
Tom V
@Lamak Honestly I already did
Most people would have bet when he entered the primaries too, yet he destroyed the entire GOP
 
Lamak
Lamak
@TomV but not with me
a bet sounds good
 
Tom V
Tom V
Using simple rhetoric and oneliners, but I guess that's how it works..
When he first entered I thought it was all a joke, but the joke could be on us at this point
 
Lamak
Lamak
@TomV well, not directly on us
unless you meant on the US
 
Tom V
Tom V
The rest of the world is highly influenced by US geopolitics
 
Lamak
Lamak
8:49 PM
@TomV well, I bet one dollar that he won't win
 
Tom V
Tom V
But this isn't a discussion to be had in the heap maybe
I'll bet you 5 upvotes on crappy answers :)
 
Lamak
Lamak
@TomV that sounds...wrong
but I accept :-)
 
Tom V
Tom V
I think the US voter is in a mess, having to pick between corruption, a baboon and a crazy herb lady
And most arguments I hear are "I vote for X because I don't want Y"
Which IMO is a decimation of demcoracy, voting against a person instead of for a policy
but I disgress :)
 
Lamak
Lamak
@TomV hey, sometimes you just have to vote against someone
 
Tom V
Tom V
It's just I think there isn't a good candidate this time... The decision will be made on who has enough animation with followers so they'll actually turn up
If there was any I would vote against all current candidates
Maybe 4 more years of Obama wouldn't be so bad but that would be illegal
 
Lamak
Lamak
8:57 PM
@TomV Enlightened absolutism is the only answer
@TomV also, how much older do you want the poor guy to get?
 
Tom V
Tom V
Goes for all three except the libertarian johnson
 
Lamak
Lamak
he gets like 4 years older per year been president
 
Tom V
Tom V
and even him
oh you mean obama
 
Lamak
Lamak
yup
 
Tom V
Tom V
Trump and Clinton look old too, and Stein is old but looks less so
But we shouldn't litter the heap with our crap, there is probably a politics.se chat room or something
I was just saying I think he'll win even if I couldn't endorse any of the current candidates
The only reasonable guy I've seen so far is Pence
IMHO again
And nobody should pick a president based on their running mate, that's for sure
 
Lamak
Lamak
9:02 PM
that would be the idea
 
ypercubeᵀᴹ
ypercubeᵀᴹ
9:23 PM
@Lamak Thnx for the folow up! I almost missed my stop while we were discussing this ...
That would have caused me 40-50 minutes delay ...
 
Lamak
Lamak
@ypercubeᵀᴹ ouch
good thing you didn't miss it
 
ypercubeᵀᴹ
ypercubeᵀᴹ
I wonder how long my last comment in that thread will stay alive (without some flag I mean), if I don't delete it.
 
Lamak
Lamak
the last comment seem pretty polite
 
ypercubeᵀᴹ
ypercubeᵀᴹ
@Lamak the "bullshit" or the "half-assed"?
 
Lamak
Lamak
half-assed is very tame in my opinion
 
Tom V
Tom V
9:30 PM
@Lamak Gordon FGITW Linoff
 
Lamak
Lamak
yup
 
Tom V
Tom V
Seems to work seeing his rep
Even if I'm not very active on SO and it's bothered me before
 
Lamak
Lamak
@TomV yeah, it works great
 
Tom V
Tom V
I thnk it works better if you already have high rep though
 
Lamak
Lamak
@TomV certainly
 
Paul White
Paul White
10:07 PM
So nice to get a please and a thank you on a custom flag. Better class of users here.
 

« first day (2101 days earlier)      last day (2768 days later) »