The Heap™ – Consultancy ©®

« first day (4544 days earlier) ← previous day next day → last day (623 days later) »

Erik Darling

01:38

your insouciance is cromulent

3 hours later…

Paul White - On Strike

04:45

A: June 2023 Data Dump is missing

Much has been written lately of the company’s decision to pause the distribution of the anonymized data dump that has historically been posted. Our intention was never to stop posting the data dump, only to begin to collect more information on how it was being used and by whom - especially in lig...

Official answer

Not to nitpick, but copying and pasting an identical answer across multiple questions goes against one of the tenets of Stack as a whole. The disappointment I'm feeling as a former employee grows every day. Even more so as someone who worked for years on the data dumps. — Taryn 6 hours ago

and ouch 🔥🔥🔥

While I'm happy that you've decided to re-enable the data dump, your ongoing dishonesty and gaslighting of the community you purport to preside over continues to be galling. Looking only at official statements, your CTO, Jody Bailey, posted an answer stating unambiguously that "Stack Overflow senior leadership…decided to stop the dump". Merits of that decision aside, it directly conflicts with your statement here that "Our intention was never to stop posting the data dump". Maybe you meant to add more qualifiers to that statement to avoid it being a lie? — Cody Gray - on strike 5 hours ago

and

I have confirmation via email from Prashanth that this is, indeed, the new official policy. I'm glad to see it. Creative Commons is part of our contract with the community, and it should never be broken -- however, CC does need to address the AI issue in an updated license, in my personal opinion. @wizzwizz4 I also edited the other post to cross link to this one. — Jeff Atwood 5 hours ago

I think we're at the stage now where we can't believe things the company says, we have to wait to see the actions

1 hour later…

John K. N.

06:03

morning

Observing this from afar,
This seems to be a big jar,
Full of uncertainties and mismanagement,
Of dishonesty and entanglement,
Me thinks this is a sinking star.

Zikato

Morning

Wordle 725 4/6*

⬛⬛⬛⬛⬛
⬛🟩🟩⬛🟩
⬛🟩🟩⬛🟩
🟩🟩🟩🟩🟩

John K. N.

Wordle 725 5/6*

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

Paul White - On Strike

06:45

Wordle 725 3/6*

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

4 hours later…

Sean Gallardy

10:29

@ErikDarling Improvements are bad? or these aren't the result of improvements?

Erik Darling

@SeanGallardy i'm not sure that unreliable behavior is an improvement

Sean Gallardy

Ahhh ok

You're up early

Zikato

10:59

No sleep four the wicket

Erik Darling

someone has to keep law and order around here

Zikato

The tv show?

Erik Darling

11:23

now that i have 2008 youtube subscribers, maybe i can get a bit part on law and order

1 hour later…

Hannah Vernon

12:36

Wordle 725 4/6*

⬛⬛🟩⬛⬛
⬛⬛🟩⬛⬛
🟩⬛🟩🟩⬛
🟩🟩🟩🟩🟩

4 hours later…

Hannah Vernon

16:24

Oh no, what will we do

Erik Darling

17:03

hello friends

i want to share something with you

today i had a client tell me that they're using a temp table

and the code looked something like this

WITH
    #cte AS
(
    SELECT
        d.*
    FROM sys.databases AS d
)
SELECT
    *
FROM #cte;

Zikato

wrong picture

Today I found out Snowflake doesn't have an OUTER APPLY. It has a LATERAL join that always acts as a CROSS APPLY, even if you specify LEFT OUTER.

Erik Darling

that's cute

John K. N.

@ErikDarling interesting

J.D.

@ErikDarling Technically true? Common Table Expressions are rather temporary.

Erik Darling

17:22

😒

Zikato

it's not surprising though
https://learn.microsoft.com/en-us/sql/relational-databases/databases/database-identifiers?view=sql-server-ver16#rules-for-regular-identifiers

> Although the number sign or double number sign characters can be used to begin the names of other types of objects, we do not recommend this practice.

J.D.

lol yep

Lamak

18:17

Wordle 725 4/6

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

Josh Darnell

18:29

@ErikDarling Oof.

That's painful.

Sean Gallardy

@Zikato did anyone reach out to you? I had a conversation with the TA.

Paul White - On Strike

18:52

Territorial Army?

Teaching Assistant?

Tubular Aardvark?

@ErikDarling I hope you put a hash in front of their invoice number

The pain is only temporary

Josh Darnell

The word octothorpe doesn't get used enough these days.

Zikato

@SeanGallardy Not yet. Have you olved it?

Erik Darling

19:08

@PaulWhite-OnStrike it mek me wep fren

Paul White - On Strike

19:21

Feels good to discover something less useful than a table variable though eh

Maybe we should start calling that construction a temporary statement-scoped table variable

Or an octothought

Sean Gallardy

@Zikato I don't have any access to data, I'm not in support anymore, so nope lol

@PaulWhite-OnStrike this!

Erik Darling

19:45

@PaulWhite-OnStrike i don't think that thinking entered the picture there

Paul White - On Strike

20:10

Ah true

J.D.

20:29

@JoshDarnell Too dull of a word, it's not Sharp enough. I personally prefer Hashtag.

Paul White - On Strike

20:40

Sharp, pounding hashtag? Ask your doctor if new Octothorpe Pro is right 4 u

Sean Gallardy

@J.D. I prefer pound because that's what it was called forever in non-UK places and also because it makes the tagging hilarious when read 😂

Paul White - On Strike

20:58

#Sand

Erik Darling

#cake

Paul White - On Strike

#Sterling

Erik Darling

¼#r

Paul White - On Strike

Royale with cheese

John K. N.

bonus star

J.D.

21:20

@SeanGallardy heh I was kidding about hashtag. I probably call it pound too, I can't remember anymore lol.

Paul White - On Strike

21:35

@e core do me a favour and select a few rows from a heap table with no indexes using a row lock hint under repeatable read isolation

Hannah Vernon

Chatgpt did it for you dbfiddle.uk/LLcSx8jp

Paul White - On Strike

22:14

Not interested in misinformation tyvm

Erik Darling

22:25

@PaulWhite-OnStrike is this the demo from your lock escalation series?

Paul White - On Strike

@ErikDarling No, I just watched one of your videos saying row locks need an index. This is an experiment you could run. Not near a computer rn

Avoid lock escalation

Key range locks (serializable isolation) do require an index

But that's a different thing

I didn't know delayed start meant two minutes btw

Erik Darling

22:53

Here we are, all learning something

I will check on that when I’m back at a computer, but I don’t run into a lot of people who are selecting from heaps under RR.

I guess my point was you’re more likely to get what you expect from the hint when there’s an index

Which is also a Paramore song I think

Sean Gallardy

@ErikDarling Arguably best kind of cake

Erik Darling

23:24

Steak cake

Erik Darling

23:35

I save a lot of time every day not looking at main

Sean Gallardy

You're not wrong

Also what kind of odd query question is this, "Think about it, what is a query that only passes rows and doesn't have columns"?

Also @Forrest I see you're making waves again

re: abominable rebuild

Erik Darling

23:59

@SeanGallardy where did this come from hahahaha

« first day (4544 days earlier) ← previous day next day → last day (623 days later) »

all rooms

Transcript for

Jun13

Jun '2314

Jun15

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