The Heap™ – Consultancy ©®

« first day (5033 days earlier) ← previous day next day → last day (55 days later) »

Paul White

01:45

Wordle 1,213 4/6*

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

J.D.

02:05

@ErikReasonableRatesDarling you may be on to something. I didn't eat Ruth's Chris tonight.

7 hours later…

John K. N.

09:10

John K. N.

09:24

Wordle 1,214 X/6*

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

1 hour later…

Charlieface

10:36

@PaulWhite Did you have any insight on the hierarchyid question I noted above? I couldn't make head or tail of why it wasn't producing the optimization only when in a CTE.

Zikato

10:57

Martin Smith just casually posting like half of my unpublished blog post

A: Why does sys.fn_xe_file_target_read_file require an explicit cast on datetime2 column?

As a "fun" exercise I thought I'd see if I could get the push down working. It is a shame that it isn't working correctly as the query execution time can drop quite a lot with this predicate pushed down as shown in the execution timings below. It is sometimes possible to get this working by Fir...

1 hour later…

mustaccio

12:04

Wordle 1,214 X/6*

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

Sean Gallardy

12:23

@Zikato Martin was just helping you czech stuff off your to-do list

Hannah Vernon

12:53

@mustaccio ouch

Wordle 1,214 5/6*

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

@JohnK.N. oh no

Erik Reasonable Rates Darling

@Zikato publish the other half?

Zikato

13:23

I'll publish it whole, it's just a very random coincidence

Erik Reasonable Rates Darling

sounds like plagiarism

you should SUE

give'em the chair

Zikato

I couldn't even share with him what a coincidence it was. The only way I can contact Martin is via a comment and that is forbidden!

Erik Reasonable Rates Darling

well

if you go to this link

chat.stackexchange.com/users/26090/martin-smith

you should be able to invite him to a private chat

if you search the transcript, you might find other interesting people to invite to chat

Zikato

thank you, I've tried it

hopefully MascGayFurScruff will reply

1 hour later…

Paul White

14:42

Wordle 1,214 X/6*

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

Erik Reasonable Rates Darling

why did you cut that frog in half

you cruel bastard

Paul White

@Zikato I did the same at the time but gave up when most filetimes couldn't be represented

didn't they ship a v2 for that?

or am I thinking of something else

Charlieface

@PaulWhite Ah if only SQL Server had Unsafe.As like C#. Actually noooo don't go there....

Paul White

I don't remember all the detail, but I don't think it was as easy as remapping bits in a sort of union

Maybe it is. Can't be that hard if the conversion is possible at all

@Charlieface Not really, aside from a dim recollection that the optimization is performed very early and very specifically

I'm pretty sure it was mentioned in the OrdPath technical paper

Charlieface

which paper?

Paul White

14:53

The OrdPath technical paper

Charlieface

as in this one? cs.umb.edu/~poneil/ordpath.pdf

> ORDPATHs: Insert-Friendly XML Node Labels

Paul White

Probably

Charlieface

sorry not seeing anything relevant there, it seems to be to do with XML optimization

Paul White

Well that's all I can recall without doing any actual work

Lamak

Wordle 1,214 5/6

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

Paul White

14:56

@Charlieface HierarchyID uses OrdPath as well

You have to do some thinking to see the connection

@Lamak Congrats. Wife & I both failed today. We think it was a stupid word

Ended my 68-day streak

Charlieface

oh interesting. I thought it just used a binary string, where the path was a compressed form of the textual version

Paul White

That paper's worth reading

For the interested party

But anyway, the optimization for the query in question is a fairly obvious one, given the ordpath structure, hence specific support for it in the parser. Being where it is, it's not very flexible, but common use makes it worthwhile.

Lamak

@PaulWhite it was actually a typo

didn't know that word

Paul White

Right

Hannah Vernon

Wife Wordle 1,214 X/6

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

ouch lol

Paul White

15:00

Yeah, I thought there might be many failures 2day

Hannah Vernon

I'm amazed she almost had it in one

Lamak

had to look what it meant, what a stupid word

Paul White

It's a real trap

As evidenced by the green vertical bars

Zikato

@HannahVernon it's a frog ran over by a bike

Paul White

A few Wordlers might call it a day I think

I still remember MAMMA and MOMMY just recently

Erik Reasonable Rates Darling

15:02

yes, suffer, SUFFER

Paul White

There was a time when Wordle avoided US spellings

@ErikReasonableRatesDarling That's not v nice

Zikato

Suffer is 6 letters. It cannot be used for Wordle.

Erik Reasonable Rates Darling

neither is your frog bisection

Paul White

Well, it's only a picture

No actual frogs were harmed

ORDPATH, ORDPATH, everywhere

Bob was gr8

Zikato

wow 2007

Paul White

15:09

Some content does not require the Web Archive

@Zikato Don't make it sound like a time b4 computers

Zikato

A time before I could legally drink

Paul White

You were born l8 m8

Zikato

I can still die early

to compensate

Erik Reasonable Rates Darling

@PaulWhite i loved bob in his blogging days

Charlieface

@Zikato you're a poet and you didn't know et

Zikato