The Heap™ – Consultancy ©®

« first day (5025 days earlier) ← previous day next day → last day (63 days later) »

Paul White

11:22

Wordle 1,206 4/6*

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

2 hours later…

Hannah Vernon

13:46

Wordle 1,206 3/6*

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

2 hours later…

Erik Reasonable Rates Darling

15:22

well everyone certainly had a wordle weekend

Zikato

15:52

made me chuckle

Erik Reasonable Rates Darling

16:16

sp_configure_automatic_tuning finally got documented about a month ago

Hannah Vernon

16:26

@Zikato becoming

Paul White

@ErikReasonableRatesDarling That's gr8, though it is less exciting to use documented features

Erik Reasonable Rates Darling

@PaulWhite yeah it definitely makes you feel a bit limp in the evening region

Paul White

I suppose it's more exciting when you're one of only a handful of people who know about it

That might not change as much as one might think with it being documented

Maybe it's linked to from somewhere people might actually search for the option

Erik Reasonable Rates Darling

no, it may add a second handful

Paul White

The Darneli Documenteers will be all over it

Erik Reasonable Rates Darling

16:38

i have linked to it in my blog about it not being documented via a helpful update

Paul White

Quoting it left, right, centre, here, there, hither, yonder etc

It's still funny to me that no one thought of it b4

Like, what do you mean you'd like to disable it for a particular query

It stretches credulity far enough to imagine anyone turning such a super feature off at all

Do you not like automation? Against tuning? What's your problem

Perhaps you prefer your query plans uncorrected

Erik Reasonable Rates Darling

> Note: Storing the results of the subquery in a table var and then joining the table var with the Dim table actually performs marginally better when using hierarchyid, but unfortunately that is not an option.

why do they do this

Paul White

use hierarchyid or table variables?

Erik Reasonable Rates Darling

Q: Azure SQL: hierarchyid performance issues

(Apologies for the lengthy post - first post on SE) I've been using the hierarchyid type in various applications for about 10 years now and I've been generally happy with the performance. I occasionally came across reports of poor performance with hierarchyid and always assumed it was due to inco...

@PaulWhite care if you're getting hithers involved, someone might get shot

Paul White

> (Apologies for the lengthy post - first post on SE)

What is this meaningless fluff for

Erik Reasonable Rates Darling

16:47

Heathers - I love my dead gay son

►

Paul White

No one cares, now or in the future. Just ask your damned question already

And what's the connection between length and being a first post?

Or is this just stream of consciousness stuff

Erik Reasonable Rates Darling

i believe it's an attempt at ~forum etiquette~

Paul White

Fuck em

Erik Reasonable Rates Darling

be nice 👋

Paul White

This is nice

Erik Reasonable Rates Darling

16:49

someone hasn't had their breakfast gin yet

Paul White

Though I am reminded of that famous quote apologising for the length of a missive due to a lakh of time to make it shorter

Anyway, it's a nice post so I voted on it

I don't usually vote on questions due to that arbitrary decision to double the points

Maybe I vote half as often 😃

Erik Reasonable Rates Darling

yes aside from the fact that most query rewrite suggestions would likely go in the "can't do that pile"

i'm actually not sure what the question is, but there's a decent amount of good and relevant information

Paul White

Oh I didn't actually read it. Just admired the general shape

Pictures and formatting

Gr8 job for a 1st post

Erik Reasonable Rates Darling

not much 2 apologize 4

Paul White

btw I'll do the second pass review thing within the next 24-48

Erik Reasonable Rates Darling

16:54

cool, ty

did you get a delivery email from 2paddocks

Paul White

I've had nothing but emails from 2P for several weeks now

Erik Reasonable Rates Darling

a happier topic than most emails

Paul White

Hey! We're thinking of shipping a thing. Check your details etc

Just a reminder that you can check the thing and change stuff!

Hi again, did you notice we're going to ship a thing?

About that thing we're intending to ship, be sure to check your details are correct!

etc

Erik Reasonable Rates Darling

if it's annoying i can cancel it

Paul White

It's more funny than annoying

I get far more annoying emails

Like random people wanting free private analysis

Or book publishers wanting quotes for a blurb on a book I've never heard of

Erik Reasonable Rates Darling

16:57

do you send invoices

Paul White

Who has time with all these emails to read

But no, these are not invoiceable people, they're just chancers

Erik Reasonable Rates Darling

do you respond or just file them away

Paul White

I try to respond to all but the most egregious ones

People wanting quotes and for me to write an article promoting their product don't get a reply

No matter how exciting an opportunity that would be for my readers

I don't think they know I only have six

Erik Reasonable Rates Darling

6.5

if you want to account for skimmers

Paul White

I should stop investing time though. Most often it's just annoying.
Like when a detailed and interesting reply is responded to with
"Thanks for confirming"

Get out of here. You didn't have a ducking clue

Which is fine. There are plenty of things I know nothing about.
Just don't BS me

Erik Reasonable Rates Darling

17:02

lol

that's the worst

"i was thinking that too"

Paul White

They know I know they weren't

Erik Reasonable Rates Darling

oh then why didn't you say that to begin with so i could have just agreed with you

Paul White

Exactly

Erik Reasonable Rates Darling

would have cut down a lot of words

now i have to apologize for my length

Paul White

Crikey, I have four weeks of unread Microsoft Community Hub Community: Weekly Digests

Where does the time go

Zikato

17:06

@PaulWhite sorry for my English, it's not my first language.

Paul White

never will be

with that attitude

Zikato

I guess I'll keep being sorry then

Paul White

I get why people do it. It's just fluff though

Zikato

all the pleasantries are fluff

Paul White

> Hi! This is my first post on Stack Exchange. I hope you're all having a wonderful day!

> I have a dog. His name is Jeff

Go tell it to an AI

Zikato

17:09

Maybe your dog's name is also Jeff and it was the tipping point that made you answer a bad question.

Erik Reasonable Rates Darling

i'm going to start asking people for their birth date, time, and place

Paul White

And for a recent weather report

Zikato

Ask for all 7 symbols on the stargate to get the most accurate place.

Paul White

Still can't believe they cancelled SG

Erik Reasonable Rates Darling

17:23

it had been on for like 19 years

ran out of fake egyptians to fight

Paul White

Indeed

But there were several opportunities to end it earlier

They left it on a really epic cliffhanger in the end

Zikato

I stopped watching when RDA quit. The Ori plotline wasn't for me

Erik Reasonable Rates Darling

17:41

you can just call him macgyver for short

Paul White

There were plenty of terrible episodes and storylines

But there was always a gem lurking just around the corner

One only recalls the good times ofc

Erik Reasonable Rates Darling

it's sort of like how i only remember the xena warrior princess episodes with callisto in them

Paul White

low-demand tv

Erik Reasonable Rates Darling

Xena: Warrior Princess – Callisto Episodes

🫡

thank you 1999 internet

Paul White

It would have been nice if the bad guys had won now and again

More realistic

2 hours later…

Erik Reasonable Rates Darling

19:49

perhaps they have automatic script correction enabled

Sean Gallardy

Milton, heading over, looking for his stapler...

Erik Reasonable Rates Darling

it's headed right for you, you're within your legal rights to shoot it

Sean Gallardy

Exactly!

One of them should hit its heart and take it down! It's basically the final boss of the Florida Man game.

Erik Reasonable Rates Darling

there's apparently a hurricane headed for europe too

too bad they're a bunch of gunless wimps

hurricanes aren't scared of nato rounds

Sean Gallardy

20:05

They are not, can confirm.

Erik Reasonable Rates Darling

20:25

> The REDO process will load the pages needed according to the analysis pass data

@SeanGallardy are all the words in that sentence correct?

i'm having a hard time parsing that one

Sean Gallardy

@ErikReasonableRatesDarling I believe so... as in, I can confirm they are not scared of europeans

@ErikReasonableRatesDarling REDO will load whatever is needed into memory, I can change it if there's a better way

Ok, I made a slight tweak to make it easier to read

Erik Reasonable Rates Darling

20:45

that seems better, thanks

Sean Gallardy

21:34

I aim for your heart, but also to please :D

Erik Reasonable Rates Darling

21:46

i would be pleased by a quick death

« first day (5025 days earlier) ← previous day next day → last day (63 days later) »

all rooms

Transcript for

Oct6

Oct7

Oct8

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