The Heap™ – Consultancy ©® - 2017-07-27 (page 2 of 2)

4:28 PM

@JoeObbish has your spool question gotten any votes today?

5:02 PM

@sp_BlitzErik No, why?

my blog post that links to it went live this morning

cries

you're on my list of blogs to read, but I haven't figured out how to subscribe to anyone

we should both get twitters

i have enough problems

5:17 PM

is there an ozar method for getting your posts sent to me?

email?

i'm old so i have an rss feed

I'm too young for rss feeds

rss feeds lead to visible pores

hierarchyid::GetRoot()

is that some weird data type?

never seen it/worked with it

eh: docs.microsoft.com/en-us/sql/t-sql/data-types/…

5:22 PM

that looks complicated

how did you get a scan count of 0 for users but there are still logical reads?

are recursive queries always single threaded?

the recursive parts are

but you can get a parallel zone after you've 'materialized' the hierarchy

I still don't get the scan count 0 thing

does that happen often? I can't remember seeing it

i've never noticed

heh

@JoeObbish yes.

@ypercubeᵀᴹ with a non-zero read count?

5:29 PM

@JoeObbish Sorry, I was referring to the weirdness of hierarchyID

oh, no worries

anyway, Good Post Brent

your blog posts have a lot of style

it's like creative writing

mine are like a textbook or something

in which a student occasionally writes a smart ass remark

that's how i hide an utter lack of content

5:43 PM

I think you'll like the one about aggregate pushdown

there's like, at least 12 different restrictions on it

I think MS tells you about two of them

Max Vernon

6:05 PM

"Oldest person on stack overflow, Joe Obbish"... That's pretty cheeky!

6:30 PM

@MaxVernon i've added cheeky to my repertoire of "hacky" and "morally inconsistent"

@JoeObbish adaptive join?

@sp_BlitzErik this is a legacy demo

ConcernedOfTunbridgeWells

hm. ssms 2017?

@PaulWhite Just filling ordinary glasses with beer will suffice.

Draft Beer Administrator

8:27 PM

got a query here such that (ID > CONSTANT OR ID < CONSTANT) gives a better CE than ID <> CONSTANT

wild day

what if you change the or to an and

;^}

it took me longer to get the joke than I would have liked

9:08 PM

what if you put the constant in lower case

Lamak

yeah, no one likes yelling

SO UNHELPFUL

0% tho

Yep fully optimal

No need to worry about the 4000+ inputs

9:30 PM

@JoeObbish nice!

That ought not happen (assuming no pilot errors).

@PaulWhite what are you doing?

They're rewritten to the same form before the initial cardinality estimate.

@JoeObbish A demo

@PaulWhite is this in reference to my comment earlier about the CE?

@JoeObbish Yes I was replying to typocubeᵀᴹ

9:35 PM

so you're interested in a repro then?

The misaligned inputs to Concat started in SSMS 2016 I think. It looks amateur.

@JoeObbish Sure why not.

For the usual range of values of "interested"

not sure what that means

but I am interested also

so will try to find a clean repro

can't just send the query out

looks to be legacy only

@ypercubeᵀᴹ Thanks

→ 1 message moved to Trash

@JoeObbish In this case, it means I'm interested enough to take a look if you can provide a repro, but I'm not going to worry about it if you can't.

So it's somewhere on the scale of things that would interest me.

9:44 PM

somewhere between new shoes and new trace flags

2

What do you think of this answer? dba.stackexchange.com/questions/182017/…

recursive CTE in a function and CROSS APPLY. Looks a bit too complicated for what it does

i don't generally find his answers helpful, unless they're quotes from BOL

so i'd be biased

dances off stage

@sp_BlitzErik I can bet that most people in this room will have the same feelings

group hug

10:00 PM

that's brutal

10:12 PM

15 Close votes?

@McNets ?

@PaulWhite Usually there are less than 10

@McNets Are you talking about the review queue size?

@PaulWhite Yes sorry

Perhaps "someone" has been on a mission

10:20 PM

Haha sure

@PaulWhite where someone = Max ?

@ypercubeᵀᴹ I haven't had chance to check yet, but Max would be a prime suspect yes :)

I cast a bunch earlier reviewing the queue, but no new ones

It's typically someone looking for old questions that ought to be removed and casting the first close vote that kicks off a review task.

Though really if the goal were deletion I'd also expect a question down vote and a delete vote (from users with the privilege)

Well, I say "expect"... :)

10:44 PM

Circumstantial evidence: went through the queue and the 2 questions that got closed show Max as having cast the 1st stone.

Very small sample to be sure.

Hm, found 3 more questions closed.

close'em all

11:01 PM

FYI if you see something in the review queue that can be improved (to the point where it no longer needs closing) with an edit, please do so. That will end the review and save other people some time. Obviously, if it should be closed, vote to close.

hey Aaron. Thanks for your answer. The query is running fast now with my new indexes, but I tried with your sugestion, and I got no improvement. — Rafael Piccinelli Jul 30 '15 at 14:08

"then why did you accept it?"

@RafaelPiccinelli I rolled back your last edit because it removed all the image links. Also: Why did you accept the answer that did not solve your problem? As far as I can tell, the real solution to your problem was adding indexes. If you can detail what you did in an answer, it might be worth keeping this; otherwise, I am minded to simply delete it (and the mess of comments). — Paul White ♦ 33 mins ago

(buried in question comments so not surprised you missed it)

Ask me sometime whether I see any drawbacks to the comment feature at all.

yes, I was reading the comments under the answer. hadn't clicked to unroll the 10+ comments in the question

I think we know why he accepted the answer, but it really does the site no favours.

i.e. to "reward" the only person that tried to answer in an actual answer, or to somehow mark the question as "resolved".

Perhaps I'm just in a bad mood because it's cold and rainy today :)

Rain here, too but not cold. Athens was in the 40 degrees this week. I'm flying there on Wednesday

Q: Disclaimers, every post/comment or is profile enough?

11:11 PM

@ypercubeᵀᴹ Centigrade?

If so, wow that's hot. If not, wow that's cold.

0

Many of you may know that a good portion of those who ask and answer on this site work for companies that may have a hand in different solutions or consulting services that could otherwise sway visitors one way or another. My question is not about individual company policy, but overall transpare...

@PaulWhite yes

wow that's hot

How many Freedom degrees is that?

104 broken democracy degrees

(just been reading about the latest shenanigans in the US Senate)

ever see that comic with the dog in the house that's on fire?

11:19 PM

this is fine.

yes, exactly

also I contributed to meta

That phrase used to one box to the cartoon during "Winter" Bash

@PaulWhite end of June were the hottest days (41). It's around 30-32 now and expected up to 36 next week.

Dec 20 '16 at 15:29, by Paul Vargas

@JoeObbish You know that won't ping him eh

yes

11:27 PM

I think that @sp_BlitzErik should be required to post a disclaimer each time, but only because his disclaimers are usually pretty funny. — Joe Obbish 8 mins ago

I'm never quite sure whether quoting in chat will ping.

Or within a code section like DECLARE @JoeObbish sql_variant;

Testing @PaulWhite — ypercubeᵀᴹ 10 secs ago

So, did you get 1 or 2 pings?

@PaulWhite this pings

also why sql_variant

@ypercubeᵀᴹ Highlighted but no DOINK!!!

just used DATETIME2 for the first time

I had no choice

@JoeObbish Seemed most flexible

> Same for you @ypercubeᵀᴹ?

11:32 PM

so here's a question

why don't comments have an expire option?

like by default they get automatically deleted after 72 (?) hours, unless someone checks a box

But really we need a chat message or on-site comment for real science

@PaulWhite I got the doink!

@ypercubeᵀᴹ Ooo!

@JoeObbish It's been proposed.

that's not surprising

Q: Allow for setting comments to "auto-expire", to become "temporary comments"

18

Meanwhile, in August 2009 "noise" was added as reason for comment flagging, and the comment flags show in the 10k tools. And Allow low-rep users to suggest edits is on its way. Hence: I don't care for this request myself anymore. An explicit [status-declined] would be fine. What about being ab...

feature-request comments

11:33 PM

are you in favor or some kind of system like that?

> guy lists 7 bolded reasons

> guy doesn't feel strongly about it

11:46 PM

> mfw I have to post disclaimers for Joe's amusement

@sp_BlitzErik mfw?

@JoeObbish It might be one element in a complete solution. I'm not completely persuaded it would be a good idea.

My face when

Ah. You youngsters and ur abbreviations!

Sorry, mobile, otherwise I'd actually post a face

@sp_BlitzErik I like to imagine the robot dancing for me

11:49 PM

😵

good news

I have a repro that's ok to share

although probably a bit dirty

How long does an Enter key last for you on average?

Whom is that addressed to?

m

e

!

It's pretty annoying actually. The chat program here always tries to censor me

@sp_BlitzErik Joe CRLFish

11:51 PM

but I persevere

I get throttled a lot.

Who was it we used to tease about their Shift key not working?

must be written by old people

who assume that people can't type quickly

unlike me

that you can't even see this

@sp_BlitzErik Not as much as if you were here in person, I suspect

I can type

so quickly

11:52 PM

We had a 10xer once who could type much faster than that

Mar 2 '16 at 18:45, by Paul White

@ypercubeᵀᴹ By the way, your newly-repaired shift key seems to be working very well.

@PaulWhite I'm unstoppable.

Unless you're much bigger

May 19 '16 at 18:46, by Paul White

But then I remembered @swasheck has no shift key.

What is a 10xer?

@sp_BlitzErik No, just persistent

mine was fixed

11:54 PM

Eaml

@sp_BlitzErik You really don't want to ask

And yet I have

I think his name was Matthew Scrotum or something

Because I ran out of Candy Crush lives

hey Erik

should I make an animated gif that proves Paul White wrong?

this is a rare opportunity

so I'm trying to figure out how to best go about it

11:56 PM

Gifs are the best way to express yourself, so yes

They're an excellent replacement for emotions and thoughts

ok I'm on it

Also most words

@AaronBertrand Again I don't expect that everyone will agree with everything I say, even if it is factually correct and I have 17 years of experience as a 10x database developer to back it up. My issue is that people are not using the up-vote, even in situations where they agree with me in the comments. Like "Hey, thanks for suggesting I remove the DISTINCT clause, it was unnecessary and sped up the query by 15 seconds" And yet did not up-vote the answer. That question had 3 answers, all reasonably good, and none were up-voted or accepted. — Matthew Sontum Feb 16 at 17:42

And friends

What the everlasting crap does that even mean

4 mins ago, by Paul White

@sp_BlitzErik You really don't want to ask

11:59 PM

You win this time, Pablo.