The Heap™ – Consultancy ©®

« first day (4448 days earlier) ← previous day next day → last day (718 days later) »

mustaccio

00:05

Would you prefer curly quotes?

Erik Darling

🫡🇺🇸culture🇺🇸🫡

4 hours later…

J.D.

04:18

Late to today's game, but 💥:

Wordle 628 2/6

⬛⬛⬛⬛⬛
🟩🟩🟩🟩🟩

2 hours later…

Hannah Vernon

06:40

Nice!

Zikato

07:35

Morning

Happy deadlift day!

John K. N.

07:50

Morning

John K. N.

08:22

Wordle 629 4/6

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

2 hours later…

Paul White

10:44

TLDR; Answer to 1: it cannot know unless it looks up the parent table, but once it does that then the rest of the plan will be skipped because 0 rows. Answer to 2: yes that's the whole point of the GROUP BY restrictions on indexed views, to make efficient updates. Advise to add INCLUDE (Amount) to the non-clustered index, and possibly a filtered index WHERE (STATUS = 'READY') to the parent table — Charlieface 10 hours ago

I'm going to let that answer comment live, at least for now, because the question is closed as a duplicate.

Paul White

10:55

I don't decline comment flags very often, hence the special annoucement

2 hours later…

J.D.

12:43

There's potential for a Dos Equis meme there.^

Zikato

13:01

The most interesting question in the world

Peter Vandivier

13:54

Atlas shrugged and Paul declined a comment flag

Hannah Vernon

14:05

Y'all really do make this a worthwhile place to be.

Wordle 629 4/6*

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

could have been a three except I guessed backwards

Peter Vandivier

i get the same feeling reading y'all's worlde updates as i do reading someone explain an execution plan

Zikato

More like someone explaining their performance problem without sharing the execution plan

Peter Vandivier

14:21

development and production wordle are the same, so why are they giving different answers?

John K. N.

14:53

git activity

@HannahVernon I took one word over the other, so I missed the 3/6

J.D.

15:11

@HannahVernon I just did the same. It's almost always the less common of the two words lol.

Paul White

15:25

*fewer

Erik Darling

*freur

Freur - Doot Doot (Official Video)

►

Erik Darling

15:43

also HAPPY FRIDEE to all those who celebrate

even mustaccio who wounded me terribly during our duel this morning

Paul White

but it's Saturday

Erik Darling

15:54

this site is weird sometimes.

we have a closed question with three upvotes and an unclosed question with at least five downvotes

Paul White

Do you refer to this? dba.stackexchange.com/q/324573

Erik Darling

that's the one

Paul White

Is it not reasonable to ask how that query solves the problem?

Correlated EXISTS clauses are tricky for some people

I mean, the question could be clearer, but I don't think it's -5 & close as unclear bad

Maybe it's a relational division duplicate at heart, but still

Erik Darling

16:12

it's not unreasonable to ask, no. few questions are.

anyway my point was that it's weird to see -5 and not closed

Paul White

Sure

I took you to mean it ought to be closed

I suppose not everyone who can downvote is able to VtC

Or perhaps they just thought the formatting was terrible

idk

Erik Darling

i will be captain save-an-op

It might help you to get a better-received question and faster answer if you follow the advice here, particularly around providing sample data to populate the tables you've defined: Help me write this query in SQL — Erik Darling 1 min ago

Paul White

16:30

An mcve is often helpful, but it's not really needed to explain how a SQL query delivers a described requirement.

Erik Darling

no, but it might help illustrate steps along the way, e.g. the outer select, the joins inside the not exists prior to the outer correlation, etc.

andriy does that in his query writing answers and it's a good teaching tool i think

Paul White

Indeed, a great answer would likely do all those things

And fair enough, people don't like the question and don't want to answer it

Erik Darling

Paul White

Lovely.

Much better than the square boxes earlier

It's too late tonight, but if I'm still motivated tomorrow I might give it a shot

Erik Darling

how has the birthday celebrating been going

Paul White

16:42

I think it's fair to say everything I had control over went well

1 hour later…

J.D.

17:43

@PaulWhite I think what happened with that one is it went through multipe poorer versions of its former self that got downvoted along the way. And not all the downvoters came back to undo their vote or care enough to undo it.

But if you look at the original Post before all the edits, it was just a title, and an unformatted query. No description lol.

Josh Darnell

I did the exact same thing as @HannahVernon 🤣

Wordle 629 4/6*

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

J.D.

lol yep

Josh Darnell

@J.D. Ah, I just noticed your message that you did the same too haha.

Tough day for all of us.

J.D.

Yea I been on the 2s and 3s streak lately. That just ruined it for me.

2 hours later…

Josh Darnell

20:17

I just learned about local static variables in VB.NET and I'm just so angry I can't see straight.

cc: @HannahVernon, resident VB apologist

J.D.

@JoshDarnell Maybe I'm a bigger idiot than I thought, but what does that even mean? Lol

Josh Darnell

@J.D. You know when you declare a local variable in C#, it falls out of scope when the method exits? In VB.NET, you can declare a local variable inside a method as static, and it will continue to exist after the method exits, retaining its value across method executions.

learn.microsoft.com/en-us/dotnet/visual-basic/…

You would think the line Static totalSales As Decimal = 0 would reset that variable to zero each time the method runs, but it doesn't. That just sets the initial value. It doesn't run on subsequent executions of the method on the same instance of that class.

J.D.

Josh Darnell

It violates all reasonable expectations of reading imperative code.

@J.D. EXACTLY

Sean Gallardy

20:48

@JoshDarnell wait what? how TF does that make sense?

Are people trying to make programming easier for idiots at the cost of actually having correct stuff? What's the real use case for this?

What problem does this actually solve?

Move it out to a class memory or a global and call it a day?

Josh Darnell

Haha yeah, we are very much on the same page 😁

@SeanGallardy One of my coworkers likes it because it allows for putting the variable declaration close to its usage.

Sean Gallardy

...

Josh Darnell

I find it visually confusing, because it looks like it's part of the method, but it's really secretly being hoisted to the class level anyway.

Sean Gallardy

No one likes readable code

J.D.

@JoshDarnell yea I was going to say, almost like a global variable kind of hide and seek lol.

I used VB.NET a longgg time ago, never heard of this til now. But I was a young'n back then.

Sean Gallardy

21:01

I started using VB at VB5 and then VB6.

I loved how easy it was to make a GUI and put together a prototype, quickly.

1 hour later…

Erik Darling

22:31

i have never touched VB5

Erik Darling

22:43

wait i've never touched VB at all

cool

josh might remember the time i tried to use c#

that didn't last long

J.D.

@SeanGallardy I started using VB when QuickBasic wasn't enough...

I think my progression was QuickBasic, VB5 / VB6 (not a lot though), VB.NET, Java (🤮), C#

Sean Gallardy

23:26

@J.D. Mine was Basic, QBasic, VB5, VB6, C, C++, C#, PHP, C again

@ErikDarling but has it touched you?

Josh Darnell

23:54

@ErikDarling I do 😅

Really brings me back.

« first day (4448 days earlier) ← previous day next day → last day (718 days later) »

all rooms

Transcript for

Mar9

Mar '2310

Mar11

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