The Heap™ – Consultancy ©® - 2024-12-06 (page 1 of 2)

Sean Gallardy

00:23

@HannahVernon Agreed, it's also because most people put AGs in as an afterthought and don't know their network, workload, etc, and then complain they have problems even though they were there the whole time.

Yeah since it's such a low hit rate - you're the only person who has hit the issue so far as I know - there isn't much traction on getting it fixed. I was going to look into a fix but have a different feature right now taking all my time... well, when I'm back in the office.

Erik Reasonable Rates Darling

01:01

Maybe you two can kiss at the AG

Hannah Vernon

01:22

441 million rows inserted now

.com is complete - it's working on .info now

Erik Reasonable Rates Darling

02:29

Announcing a limited public preview of the ABORT_QUERY_EXECUTION query hint

Paul White

02:53

That seems almost pointless

Hannah Vernon

583960K rows inserted.

Paul White

What a disappointing outcome for a very promising idea

Erik Reasonable Rates Darling

03:13

yes

quite silly

Paul White

03:27

Reeks of being externally funded

Titanic deckchair material

Erik Reasonable Rates Darling

all someone has to do is make some minor change to their query to get around that

it's absolute idiocy

Paul White

Less useful than query governor

🤪

Why can't AGs support bulk logged recovery model.

Erik Reasonable Rates Darling

03:57

Why can’t SQL Server support unlogged tables

Zikato

07:42

Non-durable hekaton tables are unlogged

Zikato

09:01

Looks like the Hawk Tuah girl expanded her brand to pump and dump that thang

Paul White

Weird because new crypto meme coins are usually very safe investments

Zikato

I know, right? In unrelated news I've lost all my savings

But the next meme coin will go straight to the moon, just hodl and get a lambo

Lol, autocorrect fought me 3 times on the hodl spelling

Paul White

diamond hands, bro

Wordle 1,266 4/6*

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

Zikato

haven't heard that one before

I still don't understand bitcoin

Paul White

219

Q: What is a good way to concisely explain Bitcoin?

Often I'm asked to explain Bitcoin to someone and occasionally I come up with something stellar that really nails it, but most times it's a rambling incoherent mess. What I would like to see is a short and simple explanation of what Bitcoin is that is suitable for someone non-technical to under...

Their top-voted question

Zikato

09:15

But no one actually uses it as a currency. Everyone only buys more and holds like a cult. And it still works after all these years

Paul White

09:25

You say that like it's something remarkable. Have you seen the value of shares recently? Especially AI-related ones

Digitial currencies will probably be a significant thing in our lifetimes

Nov 8 at 0:17, by Hannah Vernon

so my mail server has been running a little slowly today, and the server fans are whirring excessively. Turns out the Windows Server Update Services database ran out of space early this morning and started spamming me with SEV017 errors. There are a lot of those emails in my inbox now. As in over 430,000 lol.

@HannahVernon Did you get many emails from icann.org at all

Zikato

09:39

@PaulWhite Yeah but shares and even AI have some intrinsic value. Bitcoin is just there

Paul White

Everything has the value people decide it has

Apr 10 at 7:26, by John K. N.

Gold is not valuable. It only has a value because the majority of the human population has decided to allow it to have a value. The paper bills that we call money have no value. But somewhere in history people switched from gold coins to paper to allow for better transportation.

There's no fundamental valuetron elementary 'particle' or whatever. It all becomes philosophy eventually

Zikato

09:57

You can make electronics or drug cartel weapons out of gold. Paper bills are backed by the government. Bitcoin is backed by (checks notes) crypto bros?

Paul White

Are you suggesting crypto bros are somehow less trustworthy than (checks notes) the government

Saying something is 'useful' or not, or 'backed by' something is a value judgement

Fiat money is called fiat for a reason

Zikato

So you can buy Fiat Multipla

Paul White

Houses are useful for living in, but that doesn't stop mindless speculation that has nothing to do with their utility

Belief in the potential for something to increase in 'value' has a value of its own, it seems

Zikato

I hate when you make good points about things I dislike

Paul White

The world sucks in general. I'm not responsible for that

Zikato

10:03

Can't a person just dislike stuff in peace?

Paul White

Sure, carry on. I apologise for the disruption

Zikato

Thank you. I will ignore anything I've learned from this conversation

Paul White

Our mission continues

John K. N.

Wordle 1,266 4/6*

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

Paul White

W

John K. N.

10:13

sadly, no frog.

Zikato

Frog with tire marks

Paul White

A sleepy frog then?

Or did you mean tyre marks

Zikato

yes

rare misspel

Paul White

Ah yes, Miss Pel.

Zikato

So many fond memories

Paul White

10:24

Not the best secretary I ever had

ConcernedOfTunbridgeWells

11:54

@ErikReasonableRatesDarling Has anybody actually built anything using it? I've found a possible use for it, and if somebody has first-hand experience with it I'd be keen to hear.

@JohnK.N. Ironically, that's what makes gold so popular.

Zikato

12:24

@PaulWhite you're still looking into the Query Store reindex?

Paul White

@Zikato Yes, I ran out of time/enthusiasm yesterday

Never really happy with partial answers

Reorganize, not reindex

Zikato

So if index reorg runs anyway why does only one DB have this problem? Does it reorg the query store persisted data or the partitioned heap?

John K. N.

Isn't QS a database focussed setting?

Paul White

@Zikato I don't understand your question. Where did you get "only one DB have this problem" from? What does "partitioned heap" refer to? But yes, the index organization is on the query store internal tables (persisted data).

@JohnK.N. Yes

Zikato

@PaulWhite I believe OP mentioned it only happens on one database. Perhaps in a deleted comment?

Paul White

12:39

@Zikato No, there's nothing like that

The OP only left two comments in total

Zikato

Paul White

> @SeanGallardy: I also thought something like this was happening but no reorgs are running. As soon as querystore is disabled, the huge logbackups disappear. – Frederik Vanderhaegen

Zikato

It was an edit then

Paul White

> @SeanGallardy: you are correct the log is telling me that reorg is running but how do you explain, as soon as I disable query store it is back to normal and the moment I turn it back on the huge log backups are back? Also according to the log, the reorg is happening on plan_persist_runtime_stats. – Frederik Vanderhaegen

Zikato

Ah, it's still there. The last sentence

Paul White

12:42

@Zikato Oh 🤣 completely missed that

Don't know. Perhaps the other databases are configured differently or have tiny Query Stores. There's no way to know.

Zikato

All this talks about reading comprehension and it was about gaslighting 😁

Paul White

Ha ha

Sean Gallardy

I also missed it was only happening on a single database

Zikato

Paul White

From what I can see, it should always be happening. Chances are it's just not causing a noticeable issue on the others. 🤷‍♂️

So anyway, what was the "partitioned heap" bit about?

Zikato

12:47

I believe that's how the place in memory is called where QS keeps all the cached statements to see if they qualify for the capture mode or not. So if you have lots of ad-hoc queries it might be large

Paul White

Ok

It's more of a general name for a structure, which the runtime stats do use

But at least I know what you're talking about now

I would imagine memory pressure from there, the statement hash map or anywhere else, would just result in the interval being flushed early.

But I don't know

Zikato

Yeah. We've found a bug in SQL Server where query store size would be calculated as QS size + partitioned heap for one case and QS size only for another case. This triggered a see-sawing of switching from read-write to read-only.

Paul White

I do know that using TF 7748 or setting STALE_QUERY_THRESHOLD_DAYS to zero eliminates the routine index reorganizations for me

The code paths I've been looking at only call CDBQDS::GetOnDiskSizeKb

Zikato

Fair enough

Paul White

It's not a very convenient workaround, I grant you

CQDSRuntimeStats::CPartitionedStatsObject

Zikato

13:04

That sounds familiar

Paul White

Anyway, it turns out that spacebar heating is a real issue for some

sqldk!SOS_PartitionedHeap is the underlying structure

Zikato

How are you finding this so fast?

Paul White

Well, it's not all new to me. I was just lakhing context for the original question/statement

When SQL people talk about partitioned heaps, they're normally talking about database tables

I should have thrown an AmbiguousReferenceException perhaps

Zikato

ha ha

Erik Reasonable Rates Darling

yes hello i've arrived

arrivederci

is tf 7748 a qs best practice now

i'm thinking so

Zikato

13:15

@ErikReasonableRatesDarling you're leaving already?

Erik Reasonable Rates Darling

i'll be back

Peter Vandivier

@PaulWhite “Imagine if keeping your car idling 24/7 produced solved Sudokus you could then trade for heroin”

Paul White

chat markdown defeated

Peter Vandivier

Final boss was mobile

Paul White

@ErikReasonableRatesDarling ha ha probably not, but I couldn't find the zero setting for STALE_QUERY_THRESHOLD_DAYS documented either. The QS documentation is a bit all over the place, so perhaps I missed it

I can just imagine the designer adding the reorg as a lightweight and more concurrent alternative to index rebuilds

Never mind that it will warm someone's spacebar

Billions of tests and somehow never enough

Erik Reasonable Rates Darling

13:23

maybe they wouldn't need to reorg if they didn't delete everything one row at a time

have you ever seen wait stats cleanup

Paul White

Yes, but that's more concurrent, Erik

Erik Reasonable Rates Darling

i would like to talk to the batch manager

Paul White

FROM sys.plan_persist_runtime_stats WITH(NOLOCK)

That appears in sys.plan_persist_runtime_stats_merged

Referenced from sys.query_store_runtime_stats

Erik Reasonable Rates Darling

lol these ppl

Hello Eric, (sic)

Do you have any expence (sic) performance tuning with Microsoft Fabric?

We're having a lot of problems and wnat (sic) to find an MVP or someone
with Fabric ceritifications (sic) to help us make this faster. It seems
like every query is terrible (sic) slow.

Thanks,
[REDACTED]

Paul White

It's a shame to separate them from their money

I'm a little surprised they didn't ask for someone with ten years' ~~experience~~ expence

Zikato

13:28

Maybe they're searching for a tailor or seamstress

Paul White

It is possible. The encrypted message makes it hard to tell

And of course every query is terrible slow. Welcome to the cloud

Zikato

But what a (sic)k email

Paul White

The only part I don't understand is wanting an MVP. How would an ability to shill for MS help?

Perhaps Bitcoin will solve this problem

Erik Reasonable Rates Darling

how is anyone an mvp with a beta technology

all the certifications are in beta

what the good golly gosh is the point of any of this

Zikato

They started shilling early

Paul White

13:31

Shill preview

Zikato

Do you reply to these kinds of emails?

Paul White

It's all v awkward

Zikato

brogpt to the rescue

Paul White

That will get you SUED

It's Bro Pilot™

Erik Reasonable Rates Darling

i am tempted to respond publicly to the email

Zikato

13:35

New sued from genuine Microsoft fabric?

Erik Reasonable Rates Darling

with my thoughts on fabric, microsoft certifications, and the mvp program

Paul White

🤣 making friends

Erik Reasonable Rates Darling

might get me killed

Zikato

So grumpy on St Nicholas' day

Erik Reasonable Rates Darling

i can't type those letters in that order

sorry

Paul White

13:37

@Zikato Was he the patron Saint of apostrophe abuse?

ConcernedOfTunbridgeWells

@ErikReasonableRatesDarling Let me guess - bollocks, bollocks and more bollocks?

Zikato

yes

Paul White

@ErikReasonableRatesDarling yeah, I can't even bear to leave that in the transcript

Erik Reasonable Rates Darling

@ConcernedOfTunbridgeWells that's about what it'd boil down to yes

ConcernedOfTunbridgeWells

I think that we can say the state of the AI market is as much a reflection on the standards of the genuine article as it is on anything else.

Zikato

13:39

I'd like a Venn diagram of MVPs and experts please

ConcernedOfTunbridgeWells

@ErikReasonableRatesDarling In unrelated news, were the comments above on DuckDB actually a reflection of somebody's personal experiences with it or just taking the piss about the hype?

Paul White

Eric (sic) is constantly shilling for something. He wants to be an MVP

ConcernedOfTunbridgeWells

@Zikato ( MVPs ( @PaulWhite ) Experts )

Zikato

Sounds viking. Eric the Grump

Erik the Swift

> Erik can run faster than the other two, can jump, and can bash through some walls (and enemies) with his helmet.

Paul White

I bet the Vikings didn't have the first clue about vi

John K. N.

13:42

While millions of children across the globe get their Christmas presents from Santa on Christmas Day, in Hungary, Saint Nicholas, called Mikulás, arrives on the eve of 6 December, bringing sweets and nuts, and leaves the task of delivering the real Christmas gifts to the angels.

ConcernedOfTunbridgeWells

@PaulWhite Well the weren't called Emacskings for nothing.

Erik Reasonable Rates Darling

@ConcernedOfTunbridgeWells i've had some fun with it, but not had the occasion to do anything real.

Paul White

@ConcernedOfTunbridgeWells right

Erik Reasonable Rates Darling

if anyone is interested

ConcernedOfTunbridgeWells

@ErikReasonableRatesDarling I think I've found a use for it - a ceded reinsurance system.

Erik Reasonable Rates Darling

13:43

re query abortion hints

Paul White

I wonder what the Easter Bunny does 364 days of the year

Erik Reasonable Rates Darling

@ConcernedOfTunbridgeWells oh sure, i mean it's quite simple to try out and see. i'd recommend getting a gui like dbeaver to interact with it though. using the cli isn't an enjoyable experience.

Zikato

@JohnK.N. Same here

ConcernedOfTunbridgeWells

@ErikReasonableRatesDarling More about embedding it in an application, although step 1 is to benchmark it and see how quickly it could run through some scenarios.

I shall have a frig about with it, I think.

Erik Reasonable Rates Darling

sounds fun, let me know how it goes

Paul White

13:46

@ErikReasonableRatesDarling That's totally one big, rich customer missing the woods for the trees

Erik Reasonable Rates Darling

yeah

ConcernedOfTunbridgeWells

If it happens it will be the first C or C++ I've done in nearly 20 years.

Erik Reasonable Rates Darling

i'm trying my best

this thing needs an intervention

John K. N.

Rest and Relaxation
After the busy Easter season, the Easter Bunny likely takes a well-earned vacation, relaxing in a cozy burrow or hopping through peaceful meadows.

Egg Decoration Practice
It probably spends part of the year experimenting with new designs, patterns, and colors for next year's eggs, staying ahead of the trends.

Gardening and Farming
A bunny's gotta eat! The Easter Bunny might tend to its garden, growing carrots, lettuce, and other bunny favorites. Plus, it might cultivate plants that yield the dyes and paints used for decorating eggs.

ConcernedOfTunbridgeWells

@ErikReasonableRatesDarling Remember, you're not the idiot whisperer.

Paul White

13:47

@ErikReasonableRatesDarling Perhaps they'll add enable_ordinal to it in two release's time

@JohnK.N. "It"?

Also, "holiday mascots"

smh

Erik Reasonable Rates Darling

@ConcernedOfTunbridgeWells i will someday save a sql server feature from idiocy

Zikato

I bet Easter bunny personally nailed Jesus to the cross

ConcernedOfTunbridgeWells

@ErikReasonableRatesDarling Well, it's nice to have a dream, I suppose.

Erik Reasonable Rates Darling

my dream is smoking cigarettes in a french graveyard

that dream will come true in 10 days

ConcernedOfTunbridgeWells

Go to Paris and light up in Per Lachaise then.

See if you can get a selfie in front of Oscar Wilde or Jim Morrison's tomb.

Paul White

13:51

@Zikato She was a hot, cross bun that day

Erik Reasonable Rates Darling

@ConcernedOfTunbridgeWells i prefer montmartre

John K. N.

@PaulWhite In some traditions, the Easter Bunny is male, depicted as a jolly hare delivering eggs. In others, especially in folklore tied to fertility (like ancient goddess Eostre), the figure could be interpreted as female, aligned with the nurturing, life-giving themes of spring.

Erik Reasonable Rates Darling

specifically this guy

Hannah Vernon

14:15

@PaulWhite if by "many" you mean several thousand, yes

Paul White

@HannahVernon I did mean that, yes

Hannah Vernon

Sorry took me a while to scroll through the transcript.

Erik Reasonable Rates Darling

your scrolling is as slow as your data loading

Hannah Vernon

The best thing about the czds.icann.org website is having to click literally a thousand download buttons

@ErikReasonableRatesDarling heyheyhey

Wordle 1,266 2/6*

⬛⬛⬛⬛🟩
🟩🟩🟩🟩🟩

Every time I get it in two, my wife accuses me of cheating

Erik Reasonable Rates Darling

sleeping your way to the top clearly

Hannah Vernon

14:28

Ad-hoc whack-a-mole was choice

Erik Reasonable Rates Darling

ahem

one more edit

you're so close

~a~

oh you can do it

everyone cheer hannah on

Sean Gallardy

hooray

Erik Reasonable Rates Darling

📣📣📣

sean you don't seem v. oof

what's going on

did you get a resupply

Sean Gallardy

I'm on call Sunday - even though I'm oof - because why would there be proper staffing

Erik Reasonable Rates Darling

why do you need to be on call

Sean Gallardy

14:35

I wanted to move the dump analysis to a stand alone desktop application, but I also wanted to rewrite the debug engine interface, I am trying to find motivation to work on that and also the SSMS add-in given the new release of SSMS being 64-bit which opens up a lot more.

Because Azure is junk and doesn't run if people don't constantly fix it

Erik Reasonable Rates Darling

can't you just turn it off

Sean Gallardy

I so wish

Erik Reasonable Rates Darling

you must know where the button is

Sean Gallardy

The button is hidden well, it's the "create MI/Hyperscale Instance" button

Erik Reasonable Rates Darling

oh so the serbs know where it is

tickle it out of them

Sean Gallardy

14:36

It's kind of ridiculous the amount of hand holding that is done for this stuff

Erik Reasonable Rates Darling

not unexpected though

everyone is functionally r worded

Sean Gallardy

I've found code which doesn't check a return code and just keeps on failing the call. Never does anything, and waits 7 days before finally considering itself failed.

Then you have the Azure block storage (HDD over HTTP) which is absolutely worthless, you'd rather have nutanix.

Hyperscale isn't any better, remote log causing binds everywhere

People spend more time keeping Azure up than actually getting work done with Azure

Paul White

@HannahVernon What about the big blue Download All Requests button?

Josh Darnell

@PaulWhite Wow!

Paul White

Finally gets credit

Thank goodness for Josh

Erik Reasonable Rates Darling

14:47

Sep 10 at 19:18, by Josh Darnell

I just worked on a bug where someone assumed Task.Delay(int.MaxValue) meant a Task that waits indefinitely. And thus the thing they wanted to happen only once was happening every 24.8 days instead, causing all manner of inexplicable and confusing problems.

Sean Gallardy

Glad it's not just me running into this stuff

Although, makes you wonder how often AI tells people to do this

Erik Reasonable Rates Darling

well

if azure had 25 days of uptime that would be a good start

3

Erik Reasonable Rates Darling

15:06

does anyone need anything from boston

probably not

Sean Gallardy

Is there anything iconic that would be cool?

Erik Reasonable Rates Darling

uh

marlboro 100s and a budweiser

Sean Gallardy

Sure that isn't south western PA?

I still remember peoples cig orders from working at Sheetz

Also taught me quite a bit about people

Erik Reasonable Rates Darling

"this check is going to bounce"

Hannah Vernon

@PaulWhite lol

Sean Gallardy

15:10

"pack of Jacks soft, pack of tareyton"

Erik Reasonable Rates Darling

oof

Sean Gallardy

The older women who would come in, and you knew them, getting virginia slims

The group of... "men"... all ordering marlboro ultra light 100s

Erik Reasonable Rates Darling

tareyton had good ads

Sean Gallardy

Those people were the ones you knew smoked since they were 4

That and the Pall Mall people

Hannah Vernon

as a smoker since I was 12, I fixed it for you

I shouldn't say since - I've been quit for over 2 years now.

I used to love Benson and Hedges myself.

Peter Vandivier

15:19

lol i was pinwheeling trying to figure out if he was making a Paul pun

Sean Gallardy

@HannahVernon Oh man, another throw back

Erik Reasonable Rates Darling

@HannahVernon those were great

Hannah Vernon

yeah for sure

Sean Gallardy

Camels were popular with a crowd too, but more new-age

Erik Reasonable Rates Darling

i think the b&h gold were the ones i liked

Hannah Vernon

15:20

when I lived in Florida Camels were all I smoked

@ErikReasonableRatesDarling definitely

Sean Gallardy

@HannahVernon I didn't know you lived here before, where abouts?

Hannah Vernon

there were a few times when I went to watch the dog races or Jai alai that I'd inadvertently buy the Camels plain with no filters.

harsh or what.

@SeanGallardy Clearwater

well, Safety Harbor actually

Sean Gallardy

@HannahVernon Nice, I used to be there as well

Hannah Vernon

my sister still lives there

Sean Gallardy

I mean Safety Harbor, Clearwater, Tarpin, etc., are all together

Hannah Vernon

15:22

I'd visit her but yeah De Santis is too much fun for me.

Erik Reasonable Rates Darling

lucky strike were the only unfiltered i enjoyed

Sean Gallardy

lol

Hannah Vernon

@SeanGallardy yeah so many gorgeous places

Sean Gallardy

We had a bit of a cold spell, hit the 40's at night, but it's back to 80s

Hannah Vernon

the sponge dock at Tarpon was good

Sean Gallardy

15:23

Lots of good Greek places around there too

Hannah Vernon

for sure

those were the best places lol

at least according to the owner

not that I blame them

@Paul is still clicking download buttons I bet

Paul White

Why is everyone talking about B & H in the past tense?

Erik Reasonable Rates Darling

because i used to smoke them

Hannah Vernon

well for one, I don't smoke anymore so it's definitely past tense for me. Although, I'm getting a bit tense from thinking about smoking.

Paul White

Hannah Vernon

15:35

did you click that

Paul White

No

Hannah Vernon

lol it doesn't do what you'd hope

Paul White

Does it not

Seems badly labelled

Hannah Vernon

all it gave me was a spreadsheet with a list of TLDs I am subscribed to

@PaulWhite rather

Paul White

It's a clunky experience all around

Hannah Vernon

15:37

it makes me think they don't actually want people to have access to the zone files.

Paul White

Quite possibly

Hannah Vernon

they should be called ICANT

Paul White

Judging from the examples I've seen, almost no one should want the files anyway

Erik Reasonable Rates Darling

1

Q: What could cause a SQL Server non-cached temporary table to NOT trigger a recompile when a large amount of rows have changed?

I have observed (and reproduced) the following scenario with SQL Server 2022. I can't share my current repro code publicly, but I will try to put together a public facing repro in the next day or so and share it. The pattern in use code is executed via sp_executesql (no stored procedure is invol...

sql-server temporary-tables plan-cache recompile

Hannah Vernon

it's niche for sure

Paul White

15:40

RFC 1034/5 describe a format you'd only work with for money

Hannah Vernon

hahahah zone files are very painful

but 1970s

Paul White

you can sort of see why people invented xml and json

Hannah Vernon

definitely

gotta put some kind of structure in place

Paul White

you must be very motivated to want to do this for fun

Hannah Vernon

I don't know why but something about domain names and DNS in general is interesting.

Paul White

15:47

@ErikReasonableRatesDarling Sounds like an AG problem

Hannah Vernon

I have several DNS books from 1998 and I have been running a DNS server or three since that time.

Paul White

No wonder none of us has friends

Erik Reasonable Rates Darling

yet

Hannah Vernon

nyet

Erik Reasonable Rates Darling

russian collusion strikes again

no glastnost 4 u

Paul White

15:52

Why ask such a question before a repro is available. There will be comments

Hannah Vernon

let's face it, there will always be comments

Paul White

> Have you tried defragmenting your indexes

Erik Reasonable Rates Darling

perhaps someone may understand the behavior as described without a repro

i dunno

Paul White

Long shot

Erik Reasonable Rates Darling

low code questions are sometimes answerable

Paul White

15:54

Not denying that

But here's a super-rare scenario I think might be a bug without a repro?

I mean, I understand the excitement. I'm just concerned about the reception

Erik Reasonable Rates Darling

i think it's desperation more than excitement

right now it's happening on a MI readable secondary

not attempted on a primary

some diagnostics are missing on account of ags being stupid and awful

Paul White

Lose the AG, get off MI, add a recompile hint

Erik Reasonable Rates Darling

sensible

good advice strikes again

Paul White

and don't use SELECT INTO to create temporary tables

Hannah Vernon

Paul White

15:59

I know it's easier

Hannah Vernon

sorry for the delay on that image

Paul White

🤓

Hannah Vernon

undoubtedly

Paul White

@ErikReasonableRatesDarling I suppose one still can't set flags on MI? Or are globals allowed now?

Erik Reasonable Rates Darling

no dbcc trace commands

Paul White

16:01

did you hear that noise
that was my interest evaporating

Erik Reasonable Rates Darling

if you could do that you might be able to turn on in-memory tempdb or something

lol

my second guess was dns

Paul White

fweeep

> I'm curious if anyone else has seen it.

Tempted to add a CW answer, "no"

Let's clean the kitchen instead, shall we

Erik Reasonable Rates Darling

how dirty does your kitchen actually get

probably just dirty enough to wait for someone to change the topic

Cade Roux

16:17

@ErikReasonableRatesDarling That's the kind of question I used to ask and never get an answer until I figured it out myself or abandoned it with a workaround after days or weeks. Now I don't bother.

Paul White

@ErikReasonableRatesDarling not very, but that's because I clean it quite well every day

Erik Reasonable Rates Darling

@CadeRoux community spirit

@PaulWhite are your cleaning rates reasonable?

Paul White

@ErikReasonableRatesDarling free, if we're married

I don't even bother to invoice as already paid

Erik Reasonable Rates Darling

i accept your proposal

Zikato

16:43

The commute time will be bad though

Erik Reasonable Rates Darling

not once i become a nz citizen

Erik Reasonable Rates Darling

18:00

Boeing plea deal related to Max crashes rejected by judge

Erik Reasonable Rates Darling

19:01

Unless the code you’re running is also in that database context - I am running it manually in a SSMS session. — Maury Markowitz 45 mins ago

SuperUser over here

Sean Gallardy

I saw that, I was surprised... and yet I shouldn't be

Erik Reasonable Rates Darling

It would be nice if surprise resulted in some form of delight more often. Most of the time it’s just adding to the depression.

Sean Gallardy

Living in a real world idiocracy

The movie was ahead of its time

Hannah Vernon

20:59

@SeanGallardy each year I think maybe this year will be the year where things get better instead of worse, but so far I've been wrong.

still, soon I'll be dead, so there's that to look forward to.

Transcript for

The Heap™ – Consultancy ©®