The Heap™ – Consultancy ©®

4:25 AM

twitch.tv/watchmeforever

3 hours later…

7:12 AM

Morning

5 hours later…

12:11 PM

How is this question/answer so highly rated?
https://dba.stackexchange.com/q/322895/88609

HNQ effect dba.stackexchange.com/posts/322895/revisions

but how did it even get into HNQ?

It doesn't take much on a slow day

I like that chatGTP added the ordering for determinism

I'll have a quick check at the voting

12:28 PM

Taken care of.

1 hour later…

J.D.

1:35 PM

Good morning. In SQL Server, is the lock compatibility matrix the same regardless if an optimistic concurrency isolation level is used vs a pessimistic one? If not, does anyone have a resource by any chance for the optimistic concurrency lock compatibility matrix?

Same, yes

J.D.

Gotcha, thanks!

Btw that article you posted yesterday on Optimized Locking was interesting. Hopefully on SQL Server one day.

Yeah

in the good old days, five people would have yelled at that guy for wanting to store csv data

1:51 PM

Yeah, well, benefit of the doubt there. He says he wants to create a new table, but I think it more likely it's a result set.

I really dislike the terms pessimistic and optimistic to describe isolation levels

What conclusion did you come to for read uncommitted?

Hopelessly optimistic, perhaps

yeah let's rename stuff

right here in this chat

and force it upon the masses

let's be tastemakers

i think we could rename the isolation based on sobriety level

snapshot being around the Balmer peak?

yeah I don't think that's going to work

let's not bring balmer into this

it's a weird non-linear sort of scale

is completely alcohol-free worse than the opposite end of the spectrum

there's undeniably a sweet spot

2:02 PM

Sobriety vs Death, tricky one

My documented high score in that game is .38.

how was your coma?

i hope it was a restful api

Too short for my liking at the time.

did you go to waffle house after

That would have been a good move. Although I probably would have fit in better before rather than after.

2:08 PM

I'm pretty sure this is Erik's goal, to hit over .45 and stay alive

I remember the doctor expressing surprise that I was able to talk to him.

Look at Josh, breaking glass ceilings

Also, I really really really hate this whole .net interop crap

I can see why people don't want to do it

I said "oh yeah, I do this all the time" which I intended to be helpful but just got a lot of stuff written in my chart and a psych consult.

Masochism

@JoshDarnell top notch

2:10 PM

"I'm not crazy, I was tested"

@SeanGallardy 😂

alazyworkaholic

111 2

Someone's sock puppet

can one of our highly defended moderators ban their account and ip address

😱

2:40 PM

so what's everyone working on today

i'm counting on you to inspire me

I'm making a bunch of semi-pointless changes to web apps for security compliance reasons. I apologize that it's not very inspiring.

c'mon josh

lie to me

this morning i fixed a problem by specifying cursor options

i did not use fast forward

2:55 PM

I'm working on automating things in the cloud and also working on some dump automation stuff

I probably should buy 25 minutes of Josh's time

as josh's agent i object

there is a one hour minimum on my client's time

I request negative 25 minutes then

denied, pay up

:'(

Lamak

3:03 PM

@ErikDarling I'm kinda free today, so just chilling

I'll give you 4 eggs

plus interest

apparently that's worth like $80 in NYC

@Lamak what are you gonna do? some journaling?

Lamak

took a nice breakfast on the company's dime, reading a little and escaping from the heat

3:10 PM

Sounds like Lamak works at Google

Lamak

there aren't many days like this here, so just making the most of it

John K. N.

3:46 PM

@ErikDarling you don't want to know.

> BRAND NEW - DATABASE DEVELOPER - CONTRACT $80/HR - $100/HR -HYBRID
Inbox

lol

Q: How two phases locking ensures serializable?

4:08 PM

I have read many sources, and they say one of the ways to implement serializable in the database is to use two-phase locking. But I don't really understand how two-phase locking could ensure serializable in this example from Jim Gray. An example is we have two rows in the database, one has the va...

locking isolation-level serialization

REEEEEEEEEEEEEEEEEEE

John K. N.

@ErikDarling Not bad.

1 hour later…

A: Update Statistics on a 4 billion record table - SQL Server 2016

5:11 PM

"so that it does not rely on statistics to generate the execution plan"

saywhat

-1

Depending on the usage of your data I would not update those stats. At least not for those tables. I have some tables like those you described, and I have no stats on them, there are a few settings that you need to turn, and when addressing such tables, I generally tweak improve (a mechanism or s...

2 hours later…

mustaccio

7:12 PM

Are the questions asking to explain ChatGPT logic allowed?

-1

Q: Can anyone comment on the validity of an optimization done on an upsert query by ChatGPT?

Here is the original query: INSERT INTO {schemaName}.{tableName} (id, ticker, interval, ts, price_top, ts_top, continuity_top, price_bottom, ts_bottom, continuity_bottom) VALUES (@id, @ticker, @interval, @ts, @price_top, @ts_top, @continuity_top, @price_bottom, @ts_bottom, @continuity_bot...

postgresql query-performance

Cade Roux

8:09 PM

@ErikDarling templates, templates, templates. tweaking my old templates and entering metadata and parameters to code generate all kinds of SQL for a new type of cardiac finding in my data warehouse. Until one day ChatGPT can write code that writes code that writes code.

And good morning

I deleted some obsolete files too, so that was nice.

8:32 PM

@CadeRoux new cardiac findings! scary!

3 hours later…