The Heap™ – Consultancy ©®

debugging already?

hm

that's... regrettable

@sp_BlitzErik I was curious about changes for Spectre, Meltdown etc.

Also waiting for SNAPSHOT_MATERIALIZATION

@Joe I think I've most often ended up with processing a single partition at a time, inside some looping construct.

ooh yeah

4:30 PM

One would think the ETL tools would have built-in support for looping over partitions

Sliding window maintenance etc.

@PaulWhite That's mostly what we do, although we try to process partitions concurrently

There's a scenario in which we combine partitions together though

Sure, looping with some pool of workers

and process those as a unit

Part of the reason I was messing with SSDT/SSIS the other day

would a worker table make sense for that?

4:33 PM

Certainly one implementation option

oh yeah, you'll be proud of me Erik

I successfully used XE to diagnose a problem yesterday

you've got one up on me :)

I even made it through all of the ridiculous typos in the event and field descriptions

I successfully used XE to waste several hours of my time once. Does that count?

It produced xml

@JoeObbish you're a machine

4:34 PM

@PaulWhite Excellent, things are going as planned :evil laugh:

I suspected

notice he doesn't comment on SNAPSHOT_MATERIALIZATION

nothing planned, apparently

So I made 4 pounds of beef jerky last night, forgot I set an alarm and at 3 am I thought my place was burning down

@SeanGallardy-Microsoft I thought you work from home?

Life is safer as a vegetarian

4:36 PM

@JoeObbish I work from wherever, sometimes from home but last year 40 weeks on the road

sounds like poor planning!

what do you use to make the jerky?

@PaulWhite @sp_BlitzErik and I discussed last night, we eat vegetarians

@SeanGallardy-Microsoft no that was vegans

@JoeObbish 1) flesh from a dead cow. 2) an oven

@PaulWhite Their are #1 on the list, but vegetarians will do in a pinch

do you do it often? if so I would consider a dehydrator

that's what I use

has a timer so no ruined beef jerky or fires

4:37 PM

We lack B vitamins

@JoeObbish I like the smokiness :)

@JoeObbish Preach, I was looking at some electric smokers for outdoor use...

try liquid smoke!

@JoeObbish I have -500% luck with that

it really is such an odd product, right?

"liquid smoke"

Like when I made my character I rolled +200% to being hit by vehicles and -500% to smoking meats

4:38 PM

Like smoked-flavour bacon vs. actually smoked bacon

salad eating homebody

@SeanGallardy-Microsoft "Florida Man starts huge wildfire due to beef jerky making error"

Like "Dry Milk"

@JoeObbish Haha if you ever see that headline.. totally me :)

Send Jerky care packages

@PaulWhite It's bacon, I'm not complaining

So dawn broke 15 minutes ago

you had it beat by years

4:40 PM

@PaulWhite Happy start of the new week!

Smokers are v popular here. Flavoured wood chips.

@SeanGallardy-Microsoft Well it's 5:40am Sunday :)

@PaulWhite Isn't sunday the start of the week?

Monday

or do you use those southern hemisphere calendars that start on Monday?

heathen

4:41 PM

he's a foreigner

they don't understand weeks

I have the power of correctness on my side

we should liberate them

@PaulWhite Let me ask your wife about that...

touche

Also Re: parallelism, you're right I was thinking parallel branch operators

4:42 PM

No worries

I'm not a religious person, but isn't Sunday the traditional day of rest?

and for Joe, there should be in the actual XML a <ThreadStat ..... > element

Like everything created in 7 days and the last one was a rest day

Depends on who you subscribe to

Tom V

To be fair the old continent usually considers Monday the first day of the week too

It would seem odd to start the week on a rest day

4:43 PM

@PaulWhite that's a terrible motivational poster

@TomV They are blessed with the Power of Correctness

"Hmmm, 6 days... that's too even. Let me just take a nap... OH CRAP IT'S DAY 7"

@SeanGallardy-Microsoft I know how to get the number of workers

I was asking for your preferred method because I thought it would be more convincing to you

Tom V

I was going to say something about sabbath and war but I won't

@JoeObbish does you algorithm take into account undocumented workers?

4:45 PM

I guess my point is that a rest day usually comes after work is done, not before hand

That was totally tongue in cheek btw

@SeanGallardy-Microsoft would you like a rant about how terrible parallel scans on partitioned heaps can be? :)

@PaulWhite I thought Saturday the "sabbath" was the day of rest?

@JoeObbish Always!

@PaulWhite I rest early and often

@SeanGallardy-Microsoft I'm no scholar but I think that is "lunch"

4:46 PM

LOL

@JoeObbish It's the American way!

you get lunch? Are you hiring?

@SeanGallardy-Microsoft it sucks

fix it

@JoeObbish I'm totally underwhelmed by this rant.

@SeanGallardy-Microsoft hire joe and make him fix it

4:47 PM

I even made popcorn

kettlecorn to be exact

@SeanGallardy-Microsoft the problem is that you're too nice to rant to

@sp_BlitzErik I like this idea :)

@JoeObbish Hahaha, awww shucks. thanks!

@PaulWhite in fact I'm resting right now

Is talk of resting and not working in America considered pornographic?

or heretical?

@PaulWhite what are you doing up this early?

@SeanGallardy-Microsoft Interacting with Americans in their own time zone

4:50 PM

@PaulWhite you have my deepest sympathies.

Oh it's OK it's entirely my own choice

It actually is lunch time here... just on Saturday

I work when I feel inclined and sleep when I am tired

@PaulWhite That'd be 10% work/90% sleep for me... I do like my ZZZZ's

Sleep time is very unevenly partitioned for me

Nothing better than a good long sleep though

4:52 PM

Stop using SQL Server to partition it for you ;)

@sp_BlitzErik I am thinking chest today...

@JoeObbish My Jerky is kind of bland, just salt and pepper - I'm allergic to onion, garlic, and soy, among others...

8 hour chest day c'mon

@sp_BlitzErik 5x5x5, gotta get strong

I'm just a weee tike

leave humanity behind

@SeanGallardy-Microsoft no wonder you need it to be smoky...

I wonder if anyone is allergic to smoke

@JoeObbish My sister, actually :(

5:03 PM

what do you guys eat for family meals? water and white rice?

she's just smoke and tree nuts

I just recently developed mine, could everything my entire life

also rice is off the list for me.

wut

Eggs and Milk, too

Sean Gallardy: ruining holiday meals since recently

LMFAO

May I use that as my new slogan?

5:05 PM

sure

Updated ;)

Q: Is it efficient to use plpgsql functions only to validate identifiers and values?

6:50 PM

HALLO MY PEOPLE.

McNets

7:05 PM

Hi

Qualphey

7:25 PM

Hey

Could anyone answer a few questions about SQL injection prevention

?

Qualphey

7:46 PM

okay i asked the question

0

Will my queries be safe from SQL injections if I use plpgsql functions only to validate identifiers and values, instead of executing queries. Here are the example functions: CREATE OR REPLACE FUNCTION validate_identifier(identi TEXT) RETURNS TEXT AS $func$ BEGIN RETURN quote_ident(identi); ...

9:12 PM

@sp_BlitzErik Just heard from Pedro, UI support will be in the next SSMS release

@JoeObbish you still never got that answer from @SeanGallardy-Microsoft.

Just wanted to remind everyone

Maybe I'll answer it today. ;)

yesterday, by Sean Gallardy - Microsoft

She should be back next week from here out of office, I'll put a reminder to bug her again

@EvanCarroll ^^^

@PaulWhite good morning to you too

morning

ahh

9:19 PM

that's good though. are they going to hire you to write less amateur documentation?

@sp_BlitzErik No but there'll be several blog posts from the Tigger Team next week

we should start the sql eeyore team

@sp_BlitzErik am I invited?

only if you dress up as eeyore

but why

9:22 PM

that's the uniform, ding dong

I've never seen Sunil or Pedro wearing a tiger outfit

a mostly parallel plan, to some, can look a lot like partly serial

is this a philosophical thing?

it's just a rip off of my favorite eeyore quote

a mostly sunny day, to some, can look a lot like partly grey

or something

I'm seeing blocking on a function definition

a function definition!

this is outrageous

9:25 PM

lol

go on.

nevermind, I'm too dumb to read a lock graph

@JoeObbish Sunil isn't actually a member of the Tiggers

What is he now?

oh man, there's a view involved

how gratifying

CXPACKET is for noobs

9:31 PM

it's a jr dba wait

Why doesn't dba.stackexchange.com/users/322/frank-heikens have the gold PostgreSQL badge?

@sp_BlitzErik Wait category: Other

wonder how many of my wait events are in other

@PaulWhite we'd love to have your contribution: github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/issues/…

I'm sure you would

9:38 PM

:)

so sassy

> You must have a total score of 1000 in at least 200 non-community wiki answers to achieve this badge.

perhaps some of his score is from community wiki answers?

Only 24 answers in that tag, right?

24 < 200

who can possibly know the answer to 200 questions

I know it's ridiculous

9:49 PM

you don't have to know the answer

you just have to post one

That's not the attitude Mr. Obbish

that's some real liberal arts nonsense

coloringbook.stackexchange.com

everyone gets a prize

hahah

@PaulWhite it's not?

why doesn't the badge require 200 ACCEPTED answers then?

that seems more in line with what Erik said

9:57 PM

sigh

> If you notice more than five spills within the same query plan's execution, contact your support professional.

@sp_BlitzErik source?

docs.microsoft.com/en-us/sql/relational-databases/event-classes/…

"Very rarely, multiple exchange spills can occur within the same execution plan"

ahahahahaha

> Rewrite the query to produce a different query execution plan.

9:59 PM

@JoeObbish Exchange spills are pretty rare, aren't they?

not to me!

have you considered rewriting the queries?

no

I'm contacting my support professional

does anyone have a better reference on exchange spills?

10:14 PM

<RunTimeCountersPerThread Thread="6" ActualRows="2731"
<RunTimeCountersPerThread Thread="5" ActualRows="4112"
<RunTimeCountersPerThread Thread="4" ActualRows="2555"
<RunTimeCountersPerThread Thread="3" ActualRows="512933"
<RunTimeCountersPerThread Thread="2" ActualRows="1022"
<RunTimeCountersPerThread Thread="1" ActualRows="674"

oops

@sp_BlitzErik I blogged about it

what better reference could there possibly be?

link

@sp_BlitzErik ORDERBYSELECTNULL.COM

HTH