« first day (3341 days earlier)      last day (35 days later) » 

7:01 AM
@billinkc I like pubs
 
I feel like there was a joke there that went completely over my head.
But then it's often the case for me with Bill
Morning
 
7:19 AM
@AndriyM "pubs" was an early SQL Server sample database
 
@PaulWhite9 Thanks!
 
I think it was a database for publishers rather than anything alcohol-related
 
7:36 AM
Morning
 
8:06 AM
ƃuᴉuɹoW
 
9:03 AM
I didn't think I would need that. I have included the Output like and the index showing they are covered. Would you need the DDL for creating StatusHistory? — Evan Barke 6 mins ago
 
9:14 AM
If I was participating in the site I'd ask: Why is the question still open?
 
@MikeTheLiar have you solved the issue?
database "testuser" deos exist is common error. Means that testuser could connect successfully but the default in psql is to try to connect to a database with the same name as the user. If that doesn't exist, you get that error.
you need psql -U testuser -d dbname or psql -U testuser dbname
Oh, I see you already found that! nice
 
10:10 AM
@PeterVandivier WAT
 
> See also: Farm animals and dinosaurs. I am so confident that there exists children's media that involves dinosaurs driving trucks on a farm that I'm writing this without even Googling to check.
 
@ypercubeᵀᴹ We're being welcoming by not participating
2
 
Well they added the query now
... which is obviously a simple 5-table join, one of them (tables) being a view of 4-table join (actually 3 tables joined + 1 outer apply).
 
@TomV-trytopanswers.xyz not even reviewing queues?
 
10:25 AM
@McNets not even voting
 
@ypercubeᵀᴹ ok
 
I sometimes still vote or review, maybe a couple of times per week
It feels like an expression we have in Dutch "vechten tegen de bierkaai"
"Fighting a losing battle" doesn't do the expression much honor
 
I managed to have a day without signing in, after 3 years
 
We're literally drowning in crap, it's depressing to try to keep up
I don't even scroll the home page any more, before I always learned something, but nowadays it's just too much noise
this one for example how on earth does that answer assume the OP is even talking about mail broker. Task scheduler could literally be running any program. Why is the program failing when connected to another database? who knows, why even try to answer that question unless you're just trying to get in a lot of answers in order to (slowly) gain rep
It's not about being elitist, I think everybody deserves to ask questions somewhere. It's just a cost/benefit analysis on my part, and as it is now I have to put in too much effort to get something beneficial from this site
 
10:50 AM
@TomV-trytopanswers.xyz "how on earth does that answer assume the OP is even talking about mail broker.":
> Task Scheduler not sending emails [closed]
I guess they assumed it from the title but yeah, the question is so broad.
I've never worked with task scheduler or sending emails from SQL Server that I wouldn't know if it's a fair assumption or not.
 
11:34 AM
@ypercubeᵀᴹ Task scheduler is basically windows' at. Its impossible to say what they are running with it
 
oh, I thought task scheduler was some part of SQL Server. Didn't realize they meant the windows component
Question was closed, well done by the way ;)
 
11:52 AM
feel like this might be an aggressively 100-level question here... but i'm reading some ERDs generated in DBeaver and... does anyone know the significance of a dotted line vs a solid like in an FK relationship? github.com/dbeaver/dbeaver/issues/7019
looking at the definitions of a few i can't seem to grok it
not sure if it's an ongoing bug, but i'm wondering what it's supposed to represent
 
@PeterVandivier optional?
 
weak v strong relation maybe? but how tf does the auto-generated ERD define that?
 
@PeterVandivier yes, I think so.
It checks if the referencing columns are part of the PK of the table.
 
🤔
create table a (
  id int not null primary key
);

create table b (
  id int not null primary key,
  a_id int not null references a (id)
);
 
That would be weak ^^
 
12:00 PM
@TomV-trytopanswers.xyz But we are the Elite!
 
@ypercubeᵀᴹ so it would seem
yup
create table c (
  id int not null primary key references a (id)
);
 
@Philᵀᴹ Oh right, I forgot
 
-3
Q: Duplicate entry '' for key 'name' in mysql

Girish PandeyPlease resolve my duplicate entiry error in mysql database Error-type: Duplicate entry '' for key 'name'

Another ridiculous one
 
i guess TIL the difference between strong and weak realtionships 🤷‍♂️💫
the mo' you know
dot gif
 
12:20 PM
I guess it's like relationships. Your wife is a strong relationship because she has your surname (in some cultures etc), where the stripper from last night is a weak relationship because she doesn't, you just shoved dollar bills her way
 
- - - - -
☝️dotted line that's a weak analogy
 
@Philᵀᴹ still added a downvote anyway
nah!
 
 
1 hour later…
1:34 PM
@TomV-trytopanswers.xyz its ok to say MS Access is for peasants
 
as long as you're not pejorative to the peasant class while you say it
Robespierre has a gold star badge in
 
1:59 PM
@PeterVandivier At least until Catherine Théot expressed a vision of a service oriented architecture of an access database on an AWS file share with a desktop app and a web app connecting to it to run reports doing 1500 queries in a loop. That overthrew the whole system
 
@PeterVandivier throw new Bourgeoisie();
 
ON ERROR BEHEAD NEXT
 
@ypercubeᵀᴹ yes, thanks. I'm just going to user lower snake case for all my identifiers moving forward
let them = cake;
The processes are starving
then let them use disk swap
 
😂
@MikeTheLiar yea, i got bit by that recently
Dec 10 '19 at 10:30, by Peter Vandivier
> The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard, which says that unquoted names should be folded to upper case
it was a whole thing
i raged
 
2:17 PM
nAmEs sHoUlD Be cAsE InSeNsItIvE
 
☝️ i respond to this energy
 
@ypercubeᵀᴹ Similar. I broke a 1,000-day streak recently. I forget the exact number.
 
@Philᵀᴹ Plz send teh codes
We should all conspire to post malicious code as an answer to any "please give me code" questions
an npm install for a bitcoin miner linked to my wallet for example
 
Feb 18 at 14:44, by Philᵀᴹ
This is a good SO story: https://twitter.com/Foone/status/1229641258370355200
 
Yeah we could all be rich
10 years from now people would still be mining for us
 
did you learn nothing from Office Space? clearly what would happen is you'd misconfigure the miner and every server it got deployed to would overclock into a puddle of plastic & regret
 
2:42 PM
from stackoverflow import PC_LOAD_LETTER
 
for a guy named @MikeTheLiar you're sure dropping some truth bombs
 
There are some who say you should embedded BTC miners in SO answers. There are some who say Mike is a liar. You shouldn't believe either of those things.
 
@TomV-trytopanswers.xyz "Simmller" (as in "I work on simmller project"), what a delightful word
@MikeTheLiar One could also choose not to believe Mike
 
Mike knows much, tells some. Mike knows many things others do not.
 
3:00 PM
I got fed up looking at the review queue red dot and took a flame thrower to it
 
kill-it-with-fire.gif
 
3:40 PM
Kinda bored of Coronavirus now. If you're going to do a pandemic, just get on with it!
4
If it doesn't hurry up and make its mind up, they'll cancel the Olympics. I want to watch the climbing in the Olympics
 
4:17 PM
@PaulWhite9 ah. Mine was 909 :(
 
(price of Purell hand sanitizer over time)
 
5:15 PM
wait til they find out that hand sanitizer is for bacteria, not viruses
 
 
1 hour later…
6:34 PM
@Philᵀᴹ There's climbing in the Olympics? Deadly!!! Thanks for the heads up!
 
7:31 PM
:53660043 who is from Germany?
 
I suppose a_horse. From the link in the deleted message?
 
I saw the link, yes.
But didn't remember where the horse is located ;)
 
Was that message flagged?
@ypercubeᵀᴹ I have no idea. I just assumed
 
By the way, you are missing Schwarzeneggers
Posgres doesn't like it when they are missing ;)
 
@PaulWhite9 that's why you're so boss
 
7:37 PM
@TomV-trytopanswers.xyz Likely.
 
7:47 PM
@TomV-trytopanswers.xyz Yeah
Morning
 
@Vérace yup! Lead, speed and bouldering
I predict speed climbing will be one of the most popular events to watch
and my climbing wall will be way too busy for a few months afterwards
I’ve seen this loads if times and it still amazes me youtube.com/watch?v=n4n6xfu8VDU
been meaning to try the speed route just for a laugh. Reckon I could do it in a minute 😂
 
8:23 PM
@Philᵀᴹ It's been 5 years since I've put on a harness and boots - really miss it. Maybe watching those lithe young things scrambling up the slopes will incentivise me to get away from SE? :-)
 
@Vérace I was going to the wall 4 days a week until this time last year when I messed my wrist up. Surgeon had a look inside it and said there’s nothing he can do surgically, so I’m just hitting the gym hard trying to strengthen it
i miss it so much
I’m going to get back to it in the summer much lighter, stronger and ready to go :)
Do you do indoor/outdoor/trad/sport/boulder?
 
8:40 PM
I think I figured out my main trigger for this as it is now happening in my local build on SQL Server 2012: The query processor
ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely
complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If
you believe you have received this message in error, contact Customer Support Services for more information.
The main culprit seems to be an ITVF that was of the form:

WITH Results1 AS (SELECT SortOrder = ROW_NUMBER() OVER(ORDER BY X, Y, Z), TestTitle, TestResult FROM sometests)
, Results2 AS (SELECT SortOrder = (SELECT MAX(SortOrder) FROM Results1) + ROW_NUMBER() OVER(ORDER BY A, B, C), TestTitle, TestResult FROM someothertests)
, Results3 AS (SELECT SortOrder = (SELECT MAX(SortOrder) FROM Results2) + ROW_NUMBER() OVER(ORDER BY Q, R), TestTitle, TestResult FROM stillsomeothertests)
SELECT * FROM Results1
 
@Philᵀᴹ Mostly indoor, a bit of bouldering and a wee bit of outdoor. I'm a city boy, so climbs aren't that handy! :-( I just always felt great after a climb - it's really Zen - all that's on your mind is getting your hand that extra 2cm and f*** the boss, the job, stress...
 
Welcome to come to our local Boy Scout camp
"ice" climbing in 90 degree weather (and probably 90% humidity) is something else
 
9:02 PM
It’s so good going after work. You forget about everything else. You’re just concentrating on the wall. Just perfect
 
9:17 PM
@billinkc nice little walls. I’d probably end up with splinters in my knees 😂
 
The left wall is much more challenging as you can probably imagine from the overhang in the first picture. Right-hand wall on the first is more my style as it's just rappelling
They moved to an autobelay system this past summer and it's so much more efficient getting kids on and off the tower
 
Yeah, much easier than belaying. Autobelay routes are good for warming up. There’s some 4 and 5a routes at my local wall that you can do a few times in a row
Good little overhang
Do you climb yourself, or just help the kids?
 
I made it to the top about 6 years ago and did an indoor gym 7ish years ago but nothing since then
I like the concept and while terrified of heights and all that can go wrong, it's also good for me to do the things that terrify me
Past few years, I've just been a weak puss and stuck to photographing my charges
 
 
1 hour later…
10:39 PM
@McNets why the explanation says CROSS JOIN but the code has CROSS APPLY?
 
Because I've checked both options but I've not posted the correct link
@ypercubeᵀᴹ edited
Bed time
 
11:26 PM
@McNets consider adding this example: dbfiddle.uk/…
 

« first day (3341 days earlier)      last day (35 days later) »