The Heap™ – Consultancy ©®

Tom V - try topanswers.xyz

07:01

@billinkc I like pubs

Andriy M

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

Paul White 9

07:19

@AndriyM "pubs" was an early SQL Server sample database

microsoft.com/en-nz/download/details.aspx?id=23654

Andriy M

@PaulWhite9 Thanks!

Paul White 9

I think it was a database for publishers rather than anything alcohol-related

McNets

07:36

Morning

Philᵀᴹ

08:06

ƃuᴉuɹoW

McNets

09:03

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

ypercubeᵀᴹ

09:14

If I was participating in the site I'd ask: Why is the question still open?

Peter Vandivier

trends.google.com/trends/…

ypercubeᵀᴹ

@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

Tom V - try topanswers.xyz

10:10

@PeterVandivier WAT

ypercubeᵀᴹ

> 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.

Tom V - try topanswers.xyz

@ypercubeᵀᴹ We're being welcoming by not participating

2

ypercubeᵀᴹ

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).

McNets

@TomV-trytopanswers.xyz not even reviewing queues?

ypercubeᵀᴹ

10:25

@McNets not even voting

McNets

@ypercubeᵀᴹ ok

Tom V - try topanswers.xyz

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

ypercubeᵀᴹ

I managed to have a day without signing in, after 3 years

Tom V - try topanswers.xyz

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

this one is a gem as well

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

ypercubeᵀᴹ

10:50

@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.

Tom V - try topanswers.xyz

11:34

@ypercubeᵀᴹ Task scheduler is basically windows' at. Its impossible to say what they are running with it

ypercubeᵀᴹ

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 ;)

Peter Vandivier

11:52

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

Tom V - try topanswers.xyz

@PeterVandivier optional?

Peter Vandivier

weak v strong relation maybe? but how tf does the auto-generated ERD define that?

ypercubeᵀᴹ

@PeterVandivier yes, I think so.

It checks if the referencing columns are part of the PK of the table.

Peter Vandivier

🤔

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)
);

ypercubeᵀᴹ

That would be weak ^^

Philᵀᴹ

12:00

@TomV-trytopanswers.xyz But we are the Elite!

Peter Vandivier

@ypercubeᵀᴹ so it would seem

yup

create table c (
  id int not null primary key references a (id)
);

Tom V - try topanswers.xyz

@Philᵀᴹ Oh right, I forgot

Philᵀᴹ

-3

Q: Duplicate entry '' for key 'name' in mysql

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

Another ridiculous one

Peter Vandivier

i guess TIL the difference between strong and weak realtionships 🤷‍♂️💫

the mo' you know

dot gif

Philᵀᴹ

12:20

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

Peter Vandivier

- - - - -
☝️dotted line that's a weak analogy

Tom V - try topanswers.xyz

@Philᵀᴹ still added a downvote anyway

nah!

James

13:34

@TomV-trytopanswers.xyz its ok to say MS Access is for peasants

Peter Vandivier

as long as you're not pejorative to the peasant class while you say it

Robespierre has a gold star badge in vba

Tom V - try topanswers.xyz

13:59

@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

MikeTheLiar

@PeterVandivier throw new Bourgeoisie();

Peter Vandivier

ON ERROR BEHEAD NEXT

MikeTheLiar

@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

Peter Vandivier

😂

@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

MikeTheLiar

14:17

nAmEs sHoUlD Be cAsE InSeNsItIvE

Peter Vandivier

☝️ i respond to this energy

Paul White 9

@ypercubeᵀᴹ Similar. I broke a 1,000-day streak recently. I forget the exact number.

Philᵀᴹ

14:31

Needs more nukes: dba.stackexchange.com/questions/260732/…

Tom V - try topanswers.xyz

@Philᵀᴹ Plz send teh codes

Reminds me: thedailywtf.com/articles/plz-email-me-teh-codez

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

Peter Vandivier

Feb 18 at 14:44, by Philᵀᴹ

This is a good SO story: https://twitter.com/Foone/status/1229641258370355200

Tom V - try topanswers.xyz

Yeah we could all be rich

10 years from now people would still be mining for us

MikeTheLiar

github.com/drathier/stack-overflow-import

Peter Vandivier

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

MikeTheLiar

14:42

from stackoverflow import PC_LOAD_LETTER

Peter Vandivier

for a guy named @MikeTheLiar you're sure dropping some truth bombs

MikeTheLiar

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.

Andriy M

@TomV-trytopanswers.xyz "Simmller" (as in "I work on simmller project"), what a delightful word

@MikeTheLiar One could also choose not to believe Mike

MikeTheLiar

Mike knows much, tells some. Mike knows many things others do not.

Paul White 9

15:00

I got fed up looking at the review queue red dot and took a flame thrower to it

Peter Vandivier

kill-it-with-fire.gif

Philᵀᴹ

15:40

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

ypercubeᵀᴹ

16:17

@PaulWhite9 ah. Mine was 909 :(

billinkc

graph.keepa.com/pricehistory.png?domain=com&asin=B01BOWFRF0

(price of Purell hand sanitizer over time)

James

17:15

wait til they find out that hand sanitizer is for bacteria, not viruses

Vérace

18:34

@Philᵀᴹ There's climbing in the Olympics? Deadly!!! Thanks for the heads up!

ypercubeᵀᴹ

19:31

:53660043 who is from Germany?

Tom V - try topanswers.xyz

I suppose a_horse. From the link in the deleted message?

ypercubeᵀᴹ

I saw the link, yes.

But didn't remember where the horse is located ;)

Tom V - try topanswers.xyz

Was that message flagged?

@ypercubeᵀᴹ I have no idea. I just assumed

ypercubeᵀᴹ

By the way, you are missing Schwarzeneggers
Posgres doesn't like it when they are missing ;)

Max Vernon

@PaulWhite9 that's why you're so boss

ypercubeᵀᴹ

19:37

@TomV-trytopanswers.xyz Likely.

John aka hot2use

19:47

@TomV-trytopanswers.xyz Yeah

Morning

Philᵀᴹ

@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 😂

Vérace

20:23

@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? :-)

Philᵀᴹ

@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?

Cade Roux

20:40

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

Vérace

@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...

billinkc

Welcome to come to our local Boy Scout camp

"ice" climbing in 90 degree weather (and probably 90% humidity) is something else

Philᵀᴹ

21:02

It’s so good going after work. You forget about everything else. You’re just concentrating on the wall. Just perfect

images.app.goo.gl/MHu7wHnUeKuHMHnH6 Is my local wall

Philᵀᴹ

21:17

@billinkc nice little walls. I’d probably end up with splinters in my knees 😂

billinkc

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

Philᵀᴹ

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?

billinkc

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

ypercubeᵀᴹ

22:39

@McNets why the explanation says CROSS JOIN but the code has CROSS APPLY?

McNets

Because I've checked both options but I've not posted the correct link

@ypercubeᵀᴹ edited

Bed time

ypercubeᵀᴹ

23:26

@McNets consider adding this example: dbfiddle.uk/…

Transcript for

The Heap™ – Consultancy ©®