Forrest

very cool

Does an eager spool count as materialization?

Developing a gulf with it?

have you tried disc compression?

Cool!

@SeanGallardy you won't see Forrest for the trees?

@ErikReasonableRatesDarling You have a backyard? Did you move to France?

I used Adobe After Effects - there was a steep learning curve

I am currently caring for my newborn son :)

@ErikReasonableRatesDarling sorry to have missed your earlier question on gif creation

@ErikReasonableRatesDarling Classic appeel

@PaulWhite automatic seeding

@PaulWhite Ha! love the pic for that.

minute details

can't help but rag on their development priorities

@PaulWhite Thanks! Will update

@ErikReasonableRatesDarling I might hit my threshold and switch to something else

I'm halfway through a post complaing about adaptive joins in Query Store

you're not 'k with it?

@PaulWhite Cool! Thank you

I assume you can repro from an ssms call?

but no other ideas, sorry

ooooh, Azure SQL DB, that's where I think I saw it

gotta ask, TFs?

I don't remember if psp messes with them

psp?

I feel like I've seen this before, but I'm trying to remember context

@ErikReasonableRatesDarling I can see how that story bubbled up

@ErikReasonableRatesDarling Wow.

If my name were Stormy, my tagline would be "I get things done lightning quick!"

I'm a little surprised you didn't get batch mode. SO2010 or a low compat?

@ErikReasonableRatesDarling The top in the plan is from a top/max transformation?

where else might you encounter an apply running off a hash table?

Also frustrating is how an adaptive row threshold of 1.5 is morally equivalent to a threshold of 100k. But that's a blog post for later.

@ErikReasonableRatesDarling No, it started building the hash table, spilled, and then continued as a hash join despite being under the row threshold

TIL that adaptive join spills force the scan branch. That was interesting.

Constantly improving with a commitment to nonstop comparison with actual outcomes?

How does it compare to NYC? Food culture, rude people and full of tourists?

Must be all the mathematicians - they like a good proof

potato wine

@PaulWhite at least it's polite enough to wave goodbye

@PaulWhite moral hazards

@SeanGallardy I just assumed you were always on

What if your dream castle is bouncy?

if you're wondering whether the parallel hint blocks off some transformations, see if you get the no query plan error with a use plan hint?

even with use plan hint?

Don't give Erik any ideas for his face tattoos

I like how a weird kiwi has his ear

Oooh, is it time for a pun war? Let's go mad!

@ErikReasonableRatesDarling Atomic operations only