The Heap™ – Consultancy ©®

Paul White

12:50 AM

I really don't like peanut butter

Hannah Vernon

@ErikDarling "junior" lol

J.D.

1:17 AM

@PaulWhite That's a bit blasphemous. Have you tried it with chocolate?

Paul White

I already know I like chocolate

J.D.

Who doesn't? But sometimes things can be better.

J.D.

1:37 AM

Wordle 641 3/6

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

Hannah Vernon

3:58 AM

Yves Tumor - Secrecy Is Incredibly Important To The Both of Them (Official Video)

►

John K. N.

6:57 AM

Wordle 642 4/6

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

Zikato

Morning

John K. N.

morning

Zikato

Robbed of 2
Wordle 642 3/6

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

Charlieface

10:25 AM

@PaulWhite Re your "Finding Distinct Values Quickly" article: it's slightly faster to do the recursive CTE if you create a iTVF to do the TOP 1 and APPLY that inside the recursion, rather than pulling the row-number trick dbfiddle.uk/bo9S3OV5

Note by the way the use of an extra parameter on the iTVF, which is completely inlined and logic-folded, because it's only ever passed as a constant.

Hannah Vernon

12:16 PM

Wordle 642 4/6*

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

dammit

Lamak

Wordle 642 4/6

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

was a hard one

Hannah Vernon

12:48 PM

Sparks - The Girl Is Crying In Her Latte (Official Video) - Starring Cate Blanchett

►

Josh Darnell

2:33 PM

The solution to everything in Docker is to build more docker images to use with your other Docker images.

On a related note, I'm running out of disk space.

Erik Darling

mustaccio says disk is cheap in the cloud or something

Josh Darnell

2:51 PM

Classic mustaccio.

Typical, even.

Sean Gallardy

0

Q: Blocking in SQL Server LCK_M_IX

UPDATE statement is blocking INSERT statement, that results in Multiple INSERT statements failing.

:D

Pro OP

J.D.

3:27 PM

@SeanGallardy lol. I wish the Closed reason was just "True".

Sean Gallardy

Haha I thought about answering and saying "Correct"

Erik Darling

🟥⬜⬜⬜🟥
🟥🟥⬜🟥🟥
🟥⬜🟥⬜🟥
🟥⬜⬜⬜🟥
🟥⬜⬜⬜🟥

J.D.

The old GMail logo

Paul White

3:50 PM

Wordle 643 3/6*

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

More Wordle art

This one is called, "palm tree in front of a pyramid"

Hannah Vernon

nice

ever notice that seven is a five letter word, but five is a four letter word, and four is a four letter word?

also, three is a five letter word, which is weird

Paul White

because seven eight nine

Hannah Vernon

yeah, that

Lamak

is four the only one that has as many letters as the number it represents?

Hannah Vernon

that's a good question

Paul White

4:13 PM

@Charlieface Sure. Similar things have been proposed before (when I wrote the original article sqlperformance.com/2014/10/t-sql-queries/…). It reminds me of circumventing other restrictions by putting e.g. RAND in a view. The downsides are the extra database object (which you didn't bind by the way) and not being able to talk about a cool optimizer transform.

Erik Darling

not cool enough to talk about twice though

Hannah Vernon

@PaulWhite as opposed to a hot transformer

annoying gif: i.stack.imgur.com/ePcLj.gif

you're welcome for that gif by the way

I hope it's not annoying onyone

J.D.

I dig it

Erik Darling

i thought gifs were b& in here

Hannah Vernon

<--- mod mistress

Erik Darling

4:28 PM

is there like a swear jar for gifs

Hannah Vernon

there should be

Paul White

I have to drive our visitors back to Wellington airport shortly. I'm happy to do it at 5:30am of course, I just wish I didn't actually have to do it.

Hannah Vernon

how rude of them to have a flight at 7:30am

Paul White

It's not until 8:45 or something, but international check-in requirements, traffic etc.

Better to be waiting at the airport than miss the flight I guess

Charlieface

@PaulWhite Does it make a difference if you schema-bind an iTVF? I thought it only made a difference for scalars?

Paul White

4:42 PM

-1

Q: Blocking in SQL Server LCK_M_IX

UPDATE statement is blocking INSERT statement, that results in Multiple INSERT statements failing.

sql-server locking blocking

LOL at the edit

Hannah Vernon

Oh, there's an execution plan. Lovely.

Erik Darling

oh dear me

Hannah Vernon

Why are stadiums so cool?

because every seat has a fan in it

Erik Darling

there should also be a swear jar for those jokes

Paul White

@Charlieface Well, I suppose it depends if you mind if someone completely changes the definition of the table without your function being consulted

Erik Darling

4:50 PM

they posted an exact dupe too

Paul White

@ErikDarling only briefly

and now they can't do it again

Erik Darling

:O

at least the missing index request isn't on the table that takes over a minute to scan

what would be the use in fixing that

Charlieface

5:05 PM

@PaulWhite But perf is the same as far as you are aware?

Hannah Vernon

5:27 PM

The man who invented the umbrella was originally going to call it the brella.

But he hesitated.

J.D.

5:40 PM

@HannahVernon I like that better than the previous one.

Erik Darling

5:59 PM

BOOOOO

Erik Darling

6:24 PM

it sure is high quality question day

Zikato

That's what happens when you push the idea "there are no stupid questions" too far

3

Sean Gallardy

7:40 PM

I've found multiple Docs/Learn pages that literally took my old blog posts and copy/pasta'd the information. Not sure if I should be honored or saddened.

Zikato

Well, if they asked for permission, linked to the original source or at least gave a shoutout then it would be kinda ok. If not, that's straight up plagiarism

Sean Gallardy

They did not :/

Zikato

I once had a person ask on Slack how to solve some problems. I gave him several possible options. The next day I found those ideas in their blog post - no attribution

And I think Paul has plenty of similar stories

Sean Gallardy

/sigh. Discouraging for sure.

Zikato

7:55 PM

In Czech, we say: "Na každou svini se vaří kotel" which is loosely translated as "to everyone his due".

I guess, the more knowledgeable you are, the more you get plagiarized. So it's a honour of sorts.

Paul White

Back from the airport

Sean Gallardy

Did you get detained?

Paul White

Dropping people off for their flight home

Josh Darnell

@SeanGallardy That sucks. Like, your old blog posts on one of the now-defunct Microsoft blogs?

Sean Gallardy

@JoshDarnell Yeah, some of which came from my personal, but w/e at this pont I guess.

Erik Darling

8:05 PM

@PaulWhite are your arms tired?

Paul White

@ErikDarling No, because I am very fit

Erik Darling

@SeanGallardy did you reply to that email from this morning?

Sean Gallardy

@ErikDarling I have no emails.

well, nvm, I apparently do now

Erik Darling

congratulations

is six hours eventual consistency?

Paul White

still better than replication

Erik Darling

8:08 PM

are these UK people you dropped off?

Paul White

friends of the neighbours, yes returning to the UK somewhere

Erik Darling

their flight might be worse than replication

depends on if they're in first or not

Sean Gallardy

This is the 2nd time my email hasn't been working. sigh. /MS products

Erik Darling

have you tried restarting it

Paul White

email is new and advanced tech, give them chance for it to bed in, work out the initial wrinkles etc

Erik Darling

8:11 PM

highly, HIGHLY advanced

Paul White

maybe the bing ai assistant decided you didn't need those emails until just now

Erik Darling

today a client complained that an email alert i set up for them to notify when blocking happens didn't have any information about what was blocking

i changed it so it would run who is active and send results

now they think the emails are too long

🙃

Paul White

are all these steps invoiceable

add compression

Erik Darling

prepaid minutes but you know

Paul White

pre-invoiced is good

Erik Darling

8:13 PM

i refuse to work without that

union rules, or something

Paul White

Imagine if people knew what they wanted and specifically asked for it

You'd be drinking german wine

And eating crackers

Instant noodles, whatever

Erik Darling

if people did that it would be because germany took over the world

we'd all be drinking german wine anyway

Paul White

Well they are sort of due for another shot at that

Erik Darling

should we let them win one?

those wolfenstein games are pretty fun

Paul White

blue / green it

Anyway, I don't know if they'd be up for it

Seem a bit low on confidence these days

Erik Darling

8:16 PM

a bit sedate yeah

they need a good rally

boost spirits

Paul White

Maybe they're playing the long game

Lulling us into a false etc

Maybe they'll have a rally in the spring when the weather's a bit warmer

Just need to find someone who can give a rousing speech of some kind

Erik Darling

"hey everyone, look how crazy america is. they're the real bad guys, hahaha."

Paul White

Anyway. I have a friend living in Germany atm. She says German efficiency is a total myth. There's piles of meaningless paperwork for everything. They still fax.

Erik Darling

well no one would ever accuse them of not being overly bureaucratic

Paul White

@ErikDarling Have you ever considered running for leader of Germany?

Erik Darling

8:20 PM

@PaulWhite yes, under the name charles liebling

Paul White

It's not ideal, perhaps, but France is nearby

Close enough to annex, one might think

Erik Darling

it would be a really friendly annexation

like a big hug

Zikato

Have you ever seen a Query Store entry for a stored procedure that has query_store_query, query_store_plan, but no query_store_runtime_stats?

Paul White

Generalfeldmarschall Darling might have

Erik Darling

sounds like a join problem

Sean Gallardy

8:27 PM

@ErikDarling Is anyone ever happy?!

Zikato

it's not a join problem. Those dmvs are not hard to join

Paul White

Sounds like a join problem

i.e. when you decided to join this chat

Erik Darling

@SeanGallardy only people in new zealand

Paul White

thinking we'd be helpful

Zikato

YouGotMeHeisenberg.gif

Paul White

8:31 PM

Every now and again, I decide to give Domino's another shot. I don't know why I do it

Erik Darling

i thought you were partial to devil face pizza or whatever

Paul White

Slow learner, perhaps

@ErikDarling Yes, I am

Zikato

@PaulWhite Those who forget their history are Dominoed to repeat it

@HannahVernon would be proud

Paul White

@ErikDarling Domino's is closer and cheaper, and had a new range of Taste of India pizzas. They sent me an excited email all about it

Sean reminded of it by mentioning email

I might start Wordle with EMAIL today

Zikato

Domino's are cheaper?!

Paul White

8:33 PM

Oh yes, much

PIZZA would be a bold starter word

Zikato

do it!

Erik Darling

pizza? in my email?

@PaulWhite which part of india did you taste?

Paul White

The bits that flow into the Ganges from densely populated areas, I think

It wasn't that bad. But putting paneer cheese and some sort of orange dressing on a normal pizza wasn't what I was really expecting

Perhaps I expect too much

Or believe advertising

But why would they lie to me

Over email

Erik Darling

9:08 PM

check out this guy

pizza authority

I’ve had some Indian inspired pizza that I really liked, but it was at Indian restaurants

Or maybe it was pizza inspired Indian

Josh Darnell

10:17 PM

Wordle 642 3/6*

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

I am not familiar with that word.

Hannah Vernon

@Zikato why, did someone mention pineapple?

Charlieface

11:42 PM

Only works on an NCI though. Why don't you add that as an answer, after all we're not supposed to answer in comments. — Charlieface 1 min ago

I'll get my coat

@PaulWhite Just kidding you around :-)

Paul White

Using my mind-reading skills, I think the OP is more worried about the performance impact of the index build/rebuild on other processes than the locking, but I might be wrong.

That question gets asked a lot. I would've thought we'd have a good duplicate but I couldn't find one quickly

Charlieface

index creation online isn't supported either anyway, now that I think about it, for standard edition.

Paul White

No, but IIRC it only takes a shared table lock, not Sch-M, so concurrent reads are possible, matching your existing restrictions

I think there's a reason the duplicate index, drop and rename isn't used more often on Standard Edition but I don't immediately recall the details

I don't think I've ever worked on Standard Edition for real so it's not something I'm very confident about

Index rebuilding is mostly a meme anyway, I suppose

Transcript for

The Heap™ – Consultancy ©®