The Heap™ – Consultancy ©®

Criggie

12:05 AM

> a process of consultation has been started today with employees in those teams who might be impacted by our plans.

well... shit.

Yano_of_Queenscastle

12:19 AM

Did they "started process of consultation" with you?

Also, damn corpo-speak.

Criggie

No, thankfully. But the atmosphere went to shit real fast.

Erik Darling

1:05 AM

@Criggie my rates are reasonable.

Criggie

1:26 AM

Brutal.... "there's one vacancy in (other team) and only one person can move over retaining all benefits and service history." Clearly work expected the ~3 eligible people to fight for it.

The two good ones said "fuckit gimme severance" and the shitty guy remains, thinking he won

bleurgh.

Erik Darling

1:43 AM

Clearly the only option is murder

The ultimate ~severance~

Criggie

severe severance

TERMINALnation

Paul White

2:43 AM

Companies downsizing always seem to expect the best people to stay.
That has never been my experience.

Erik Darling

it happens occasionally

Criggie

wtf am I still here ?

Erik Darling

so long as sufficient promises of compensation are made

Criggie

Oh right - the mortgage

Erik Darling

unless you're tethered by some other arrangement, you could always look for a different job

Paul White

2:56 AM

There is inertia to overcome in changing jobs

Plus, you become the "new guy"

And you have to learn all the stupid business rules at the new place

Erik Darling

of course. i'd rather be looking for a job while i have a job, though.

Paul White

sure

I'm saying that the opportunity for severance as an income buffer tends to overcome inertia for good people who were never fully happy

The muppets will tend to cling to any employment like a limpet

Which is the right strategy. Not least because they'll inevitably be promoted out of harm's way

The truly unemployable become consultants, naturally

Criggie

3:31 AM

okay long story short, I'm going through a divorce right now, for the last ~6 months.
Part of that is me buying the house and paying the other half to the ex.
That means getting a mortgage, which means good proof of income.

So yeah I need a high paying job to qualify as a single person owning a home

this job has a lot of bad sides, but satisfies the bank.

Paul White

2 hours ago, by Erik Darling

Clearly the only option is murder

Vérace

A chairde - Morning all!

Wordle 1,047 3/6

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

Hannah Vernon

3:57 AM

The designer of ReiserFS tried dividing by 0 but ended up opting for murder as it was easier

Or so he thought

Hannah Vernon

5:15 AM

Wordle 1,047 4/6*

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

Vérace

6:18 AM

@HannahVernon Had a chat with him once!

Before circumstances turned (ahem...) sour for him (not to mention for his wife).

Vérace

6:33 AM

db<>fiddle down?

Paul White

6:48 AM

Wordle 1,047 4/6*

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

Erik Darling

10:19 AM

@PaulWhite i was only referring to criggie's circumstances before he dropped the divorce bombshell on us

@Criggie how come everyone says "going through" a divorce rather than "enjoying" a divorce

my first divorce was quite satisfying

Paul White

> my first

Erik Darling

well who knows when current_wife will get sick of me

probably when i stop sending out invoices, ha ha ha

might need to get three precons next year to keep her impressed

Paul White

Erik Darling

@Zikato might sue you for that meme

Paul White

10:57 AM

always a risk

Erik Darling

11:56 AM

-1

Q: SQL Server CPU at 100% when more than 100 transactions per second

We are having a production Microsoft SQL Server 2019 Enterprise Edition with 128 cores CPU and 256 GB RAM. Max DOP set as 56 and Cost Threshold as 300. Disk IOPS is set at 32000. Database MDF on one disk and LDF on the other. Frontend Application is Dot Net Core Inserts and Updates are done throu...

sql-server

if i comment "My rates are reasonable" would that be considered spam

😊

Paul White

Probably not, in context

Erik Darling

My rates are reasonable. — Erik Darling 12 secs ago

there we go

Paul White

Flagged as spam

Erik Darling

12:12 PM

doh

Sean Gallardy

@Criggie Sorry to hear bud, best wishes!

@PaulWhite Upvoted anyway

I hear the first one is the hardest, smooth sailing after that

Erik Darling

like riding a bike

but not like drinking fernet

Paul White

I remember when marriage was for life

Erik Darling

where every one is the hardest

@PaulWhite that was when everyone died in their 30s

Sean Gallardy

fernet

Noun: fernet (usually uncountable, plural fernets)

A particular type of Italian amaro.
fernet m (invariable)
(countable and uncountable) fernet (Italian liqueur)
Hypernyms: amaro m, liquore m

Erik Darling

12:24 PM

it's concentrated bellyache

Paul White

12:37 PM

@ErikDarling I think people expected to live for about 70 years ("three score and ten")

The "modern" redefinition of marriage seems more like a tenancy agreement

Well, in some """cultures""" anyway

Erik Darling

i'm doing a much better job on the second one

Sean Gallardy

New high score?

Erik Darling

11 years this month

Sean Gallardy

Learned your lessons on goth punk chicks?

Congrats on 11!

Paul White

I've been on Twitter longer than that

Erik Darling

12:40 PM

@SeanGallardy well no, just found one that wasn't full on batty

Sean Gallardy

Didn't know that existed!

Erik Darling

it is an oddity

Sean Gallardy

odd oddities

Paul White

Ha ha your comment did get flagged

Possibly humorously, but moderators have no sense of humour

Like all bureaucrats

Erik Darling

a smart moderator would decline such nonsense

Paul White

12:51 PM

sounds like something an insurrectionist would say

or a spammer

Michael Green

@Criggie I imagine Private Thoughts would engage in a certain amount of naval gazing, no?

Paul White

Clearly a joke, but it had a Colonel of truth

Erik Darling

Sep 19, 2022 at 18:33, by Erik Darling

Sep 18, 2017 at 19:40, by sp_BlitzErik

@PaulWhite DATEADD(DAY, - 1, THE_REV)

Paul White

Divide that by zero

Sean Gallardy

I watched a whole series of things on dividing by 0 to fall asleep last night, what a rabbit hole.

Erik Darling

1:02 PM

what if we didn't have rabbits

what would we compare such things to

or make stew from

Michael Green

Easter Bilby

The Easter Bilby is an Australian alternative to the Easter Bunny and chocolate bunnies. Bilbies are native Australian marsupials that are endangered. To raise money and increase awareness of conservation efforts, bilby-shaped chocolates and related merchandise are sold within many stores throughout Australia as an alternative to Easter bunnies. == Concept and stories == The first documented use of the Easter Bilby concept was in March 1968 when a 9-year-old girl Rose-Marie Dusting, wrote a story, "Billy The Aussie Easter Bilby," which she published as a book 11 years later. The story helped...

Hannah Vernon

Fun times for Dell customers

Paul White

A world without rabbits would be pointless

Sean Gallardy

Rabbit, cooked properly, is one of my favorite foods

Paul White

Too lean to be properly nutritious, I was told

Erik Darling

1:04 PM

@PaulWhite frogs

Paul White

Meh, frogs are just a transcript meme. Rabbits are fundamental

Erik Darling

how very dare

Paul White

We could take a vote on it if you like

Erik Darling

i'm sure my vote would get divided by zero

Paul White

Bet on it

Not that spammers really get a vote to begin with

Erik Darling

1:09 PM

my spam is high quality

wagyu grade

Zikato

@ErikDarling I'm in a good mood today. 10th anniversary of my first date with current_wife

Sean Gallardy

There were some interesting videos of dividing by 0 on mechanical calculators, they just kept spinning and never stopped. Makes you think of infinity.

Charlieface

I've just discovered that GETDATE and friends are actually sniffed as if they were parameters. sqlshack.com/runtime-constants-sniffing I feel like I knew that or should have realized, but interesting to see clearly.

Erik Darling

@Zikato are you doing anything special for it

Zikato

It's also a bank holiday here, so we gave kids to grandparents and went to visit the city where we met

Literally a stroll down the memory lane

Erik Darling

1:14 PM

what a wholesome couple

@Charlieface that's a very clever demo, it's a shame dima doesn't blog much any more

Paul White

All his exports got sanctioned, unfortunately

Erik Darling

ouch dude

Sean Gallardy

Only exports I know off the top of my head that czech out is springfield and associated items

Charlieface

@ErikDarling Relevance:

1

Q: Any benefit in parameterizing the value of GETDATE() / GETUTCDATE()?

Is there any benefit in parameterizing the value of GETDATE()/GETUTCDATE()? The objective is to allow SQL Server to reuse execution plans, example: SELECT [c].[ID], [c].[Name] FROM [Customer] AS [c] WHERE [c].[ActivationDate] > DATEADD(day, CAST(-7.0E0 AS int), GETUTCDATE()) AND [c]. [Activation...

sql sql-server parameter-sniffing

Erik Darling

i would guess that if you replaced the parameters with runtime constants within the dynamic sql it would turn out better

Paul White

1:23 PM

Ah, StackOfComments.com

Erik Darling

different execution contexts and such

Paul White

I suppose explicit parameters are better for code clarity

Erik Darling

@Charlieface dbfiddle.uk/-OcPJ5q2

plan reuse is tough in there

BradC

1:38 PM

@SeanGallardy excellent, thanks

Charlieface

@ErikDarling Looks like plan reuse is working fine, not sure what you mean dbfiddle.uk/ovAdpfDr Obviously you may want to avoid it in this case, which is what I mentioned in my answer.

Erik Darling

depends on what you mean by "just fine"

that's why i avoided it

in the case of dynamic sql it's plan reuse rather than runtime constants being sniffed was my only point there

if you change the original demo to use the 1/2/3 = (select 1/2/3) it turns out the same as dynamic sql

the second query doesn't do a lookup with a 10 row estimate

Charlieface

@ErikDarling Nope you can see the value itself is being sniffed even within dynamic SQL even without any parameters dbfiddle.uk/L31UEXYE

ie this is not the equivalent of a local variable or using OPTIMZE FOR UNKNOWN

Erik Darling

@Charlieface where am i looking?

Charlieface

Two queries, the only difference is the calculated constant off getdate() which is then sniffed and a different plan selected. Using local variables does not behave in this way dbfiddle.uk/PKi6GrZQ

Erik Darling

1:54 PM

yes, i know the runtime constant is sniffed and local variables behave different

i think you're misunderstanding my point

Charlieface

probably

what is your point then?

Erik Darling

well, that i'm not arguing with you about anything. it's sniffed per statement. the reason the second query in dima's post gets a bad estimate is that the plan from the first is reused (with the initial sniffing). the recompile against the object invalidates the plan and forces a new one with a fresh stats calculation.

Paul White

2:13 PM

I wonder if the expression, DATEADD(day, CAST(-7.0E0 AS int), GETUTCDATE()) is always the same, or if the number of days changes

As an aside, doing calculations with dates doesn't always work so well with cardinality estimation from statistics

I'm trying to understand why [they think] they don't get plan reuse already

Erik Darling

perhaps an unsteady plan cache

Paul White

That CAST is a wonder too

One day I will not regret looking at a Stack Overflow question

Erik Darling

2:30 PM

doubt it

Paul White

Don't hear much about the PSP optimization these days

Erik Darling

2:51 PM

maybe sql server 2025 will have more promising features

Sean Gallardy

😂

Erik Darling

regex and whatnot

i'd be happy with optimized locking

Sean Gallardy

You say that now

Paul White

> Msg 12135, Level 16, State 1, Line 1
The Metadata needed for Optimized Locking is not populated yet. Please retry the operation.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.

Just checking

Josh Darnell

3:10 PM

@SeanGallardy ominous

Paul White

I believe Erik meant he'd be happy with Optimized Locking that works

Erik Darling

well yeah

Paul White

It ought to go without saying

There's something vaguely subversive in buying a breakfast cereal that is 100% grain then absolutely covering it in honey

It's awfully plain without honey though

Bleak, even

Josh Darnell

@PaulWhite "I'd be happy with in-memory tempdb metadata without runtime asserts and access violations"

That kind of thing?

Paul White

That kind of, as you say, thing, yes

All the benefits, none of the drawbacks

Using magic as necessary

Meantime, you can have shrinkdb with wait at low priority and like it

(may contain bugs)

Josh Darnell

3:22 PM

What we've all been pining away for

Paul White

Well, Forrest has for sure

Sean Gallardy

@PaulWhite But have you retried?

@PaulWhite Just like your cereal

Paul White

@SeanGallardy It's 100% grain tho

Sean Gallardy

I don't think crickets are required to be disclosed on the nutritional facts or ingredients yet

Josh Darnell

@PaulWhite We have a production database here with Auto Shrink on.

On purpose.

And it works quite nicely.

Paul White

3:34 PM

Good. I have no problem with that

Or auto close

If you need it, you need it

Josh Darnell

To be clear, I didn't mean to imply that you did have a problem with it 😀 Just replying for relevance.

Paul White

Yep, my reply is for the benefit of the transcript

And also to be on the cool team

That can use denigrated features for good

Josh Darnell

It's funny how we tend to speak in absolutes about certain things. Which is useful for general guidelines. But also tends to create zealotry over time.

Paul White

Very wise

Have a star

Now go defragment your database

I suppose I should make it clear that's not a serious instruction, like being told to go run checkdb

Sean Gallardy

Too late

Paul White

3:40 PM

Yep, he's gone for another few hours. Oops

In other news, hibernating a laptop when 128GB of RAM is full of SQL Server buffer pool takes a while

Won't be doing that again

Josh Darnell

@PaulWhite I'm still mad at Erik about that 🤣

Paul White

At least you won't be worrying about corruption

Josh Darnell

But mostly I'm dumb I guess.

4

Insta-star, dang.

Oh yeah right

Pinned now.

Paul White

🤣🤣🤣

Josh Darnell

Is it too late to edit that message to say "the Internet is slow in North Carolina" 😉

Haaaaaaahahaha

Chat is the best today.

Charlieface

3:52 PM

@PaulWhite I don't think plan reuse was the point there, yes obvious you get it. The point of the article was that GETDATE is sniffed, rather than working like a local variable or OPTIMIZE FOR UNKNOWN.

Unless you were referring to the Stack Overflow question. Well unlikely they ever heard of either parameter sniffing or plan reuse, so moot point.

Paul White

I was

> The objective is to allow SQL Server to reuse execution plans

Seems they heard of plan reuse at least

Sean Gallardy

What if you're too good to reuse plans like a common pleb?

Paul White

Then you get crickets for dinner

A double helping if you go on to request optimal plans depending on parameter values

Triple if you want all that without recompilations

Sean Gallardy

I want an optimal plan fast with a complicated query and multiple views which have 400 union alls in them

Paul White

And fifteen helpings if you try to explain Dima's article to me

You will henceforth be known as CricketFace

Erik Darling

4:01 PM

how about crikeyface

Paul White

Acceptable

Well, look at that. It's 4:04

moderator not found

Erik Darling

disappearing mods

if only there were a way to make the anarchy permanent

Zikato

4:42 PM

Oooh. Little Darling precon in Seattle

The most ambitious cross-over since MCU

Erik Darling

4:58 PM

there will be no time travel

Sean Gallardy

5:20 PM

Then is it even worth it?

Erik Darling

6:17 PM

Only time will tell

Criggie

9:22 PM

@ErikDarling I guess everyone's experience is different.

@SeanGallardy yeah well she had to move back in with me cos her temporary accommodation got sick of her

@SeanGallardy Rabbit is delicious, especially steamed in a hangi.

Those last two lines are COMPLETELY unrelated

Josh Darnell

@Criggie I didn't enjoy anything about mine (just to add to the discourse here 😀).

Criggie

Also, that its "ongoing" doesn't help. 6 months of flux, incurring lawyer's fees all the time

Erik Darling

@Criggie oh that is the worst.

Sean Gallardy

9:48 PM

@Criggie 😂🤣😂🤣😂😂

I've never been divorced... I guess I'm, once again, the odd one out.

Criggie

10:03 PM

@SeanGallardy I never expected it either. After 21 years too.

Erik Darling

I hope you’re still youthful enough to have some proper fun

Criggie

10:23 PM

I'm almost 50 - once all this paperwork shit is done and I own the house, I'll buy a small piece of farmland and go live in a tinyhouse, then build an enormous workshop then spend the rest of my life stocking it with old-school tools.

I don't need a large family home for me and the dog

I am not living in a tent or caravan though. A small-home at least.

Sean Gallardy

10:43 PM

Sounds great!

Erik Darling

10:58 PM

What are you going to build

Hannah Vernon