The Heap™ – Consultancy ©®

1:42 AM

@PaulWhite Yes, but usually 15 hours after everyone else has.

@Phil I thought I could make something of it while using a hand-held. Unfortunately awetoekerrekt, genalised UI madness and small children got in the way. Unwilling to loose what (little) I'd achieved I saved the changes. Hopefully I didn't deviate too far from the OP's intentions.

Phil

8:09 AM

Morning minions

Tom V

Morning Phil

Andriy M

morning

YperSillyCubeᵀᴹ

8:24 AM

m

Phil

y

I currently have Curry Remorse. Seemed like a good idea at the time

Tom V

@Phil I think I speak for the entire heap if I say you can spare us the details

2

James Anderson

@Phil Vindaloo?

Phil

Just chicken tikka masala

dezso

10:29 AM

@Phil I've got (second hand) a bottle of chili sauce from a datacenter company we work with. Had to realize that my family is not that fond of spicyness, so offered it to a colleague. He asked what was in it - 40% red pepper and 8% dried bhut joloki. Hearing this, he said 'That's poison! Yes, I want it!'

no report about the effects yet

James Anderson

was it "dave's insanity sauce"? 3 drops in a curry and it's almost ruined

YperSillyCubeᵀᴹ

@dezso We have anew guy in the office who would like that. he has always a chilli sauce bottle with hime.

dezso

@JamesAnderson no, I guess

currently I cannot remember the brand

Mark Sinkinson

My old boss used to carry round a bottle of Cholula

Phil

10:57 AM

@JamesAnderson I've tried that

Nearly died

I have bacon. Order has been restored

Master Database

11:40 AM

0

Q: Merge crosstab tag into pivot

pivot has 131 questions and crosstab has 12. Is there any important difference between the two from a tagging perspective? If yes, please add your reasoning to the 'yes' CW answer below.

2

YperSillyCubeᵀᴹ

12:23 PM

the Yes and NO are confusing a bit.

Paul White

@YperSillyCubeᵀᴹ Feel free to edit!

Never mind, I'll try.

@YperSillyCubeᵀᴹ Better?

YperSillyCubeᵀᴹ

yes, nice.

I did some more changes.

(putting back the Yes and No, in opposite answers ;)

Paul White

Okidoki. Thank you.

YperSillyCubeᵀᴹ

12:45 PM

3

A: How to drop all triggers in a single database?

You can use Dynamic SQL and the sys.triggers DMV to build query that you can execute. is_ms_shipped excludes any triggers that were shipped with SQL Server. parent_class_desc filters for object level triggers, rather than database level. Change the PRINT to an EXEC once you are happy with the o...

Paul White

Surprised no one has posted a PowersHell solution yet.

Tom V

Could u plz Connect To My PC — Mastan Vali 3 mins ago

taking chat to a whole new level @PaulWhite

Paul White

Goodness!

Tom V

We should start selling SLA's for this site

YperSillyCubeᵀᴹ

@MastanVali Sure, just send me your bank account details, address, date of birth & mothers maiden name — Phil 27 secs ago

lets keep that before some mod eliminates it.

Paul White

12:57 PM

I'm not that slow, just appreciating it for a few minutes!

poof

dezso

1:14 PM

@TomV I see all the hidden dollar signs there

billinkc

@TomV That's why we're the consultancy

Tom V

Shiny new toy

Paul White

> The tool DynamicsPerf (Performance Analyzer for Dynamics) is a script that returns the word "sucks".

Surprisingly honest of them.

Looks pretty cool!

Tom V

it is

creates extended event sessions, persists dmv stuff, has analysis scripts for SSRS...

Paul White

1:30 PM

Indeed.

Tom V

Should be useful outside of dynamics too, it's really user friendly

unfortunately beta1 still breaks on 2008 R2 while they say it's supported but still

Phil

I'm stuck on 2008R2 too ;(

dezso

This hash is only slightly slower than the fast one (well, about double the time, but it's only 50 ms). The real difference shows itself in the Hash Right Join node - also, one smallint in the 10+ column list cannot cause such a big change, in my view. — dezso 37 secs ago

@YperSillyCubeᵀᴹ do I miss something?

YperSillyCubeᵀᴹ

@dezso No idea.

I'm still struggling with figuring postgres execution plans out.

dezso

@YperSillyCubeᵀᴹ that number really looks strange but the other numbers (memory consumption and time) are not that different

YperSillyCubeᵀᴹ

1:41 PM

FULL joins are evilᵀᴹ though. No doubt.

Yeah, rewrite the view (avoid the FULL JOIN) as you suggested is working perfectly! Thanks alot! — Xsasan 20 mins ago

dezso

@YperSillyCubeᵀᴹ someone, some day will read this and start advocating right joins

Paul White

Already up voted. Very brave effort given the question.

YperSillyCubeᵀᴹ

@dezso That's the only place where I've used them. To rewrite a FULL JOIN.

dezso

this looks rather counterintuitive, BTW

YperSillyCubeᵀᴹ

@dezso You would prefer 2 LEFT joins? I mean does the syntax looks counter-intuitive or the rewrite?

dezso

1:45 PM

but makes total sense

@YperSillyCubeᵀᴹ in this case (and only in this case), possibly no

I meant splitting the JOIN into two

the LEFT + RIGHT solution nicely shows the intention

YperSillyCubeᵀᴹ

Yeah, perhaps I should explain more, why.

Tom V

@PaulWhite Not in our implementations wink

Paul White

Well clearly

Brent Ozar

Howdy folks. Odd question: would it be crazy of me to move sp_Blitz/sp_BlitzIndex/sp_BlitzCache/etc support questions over to Stack? We're using Uservoice, and I hate it.

6

Paul White

@BrentOzar Hey Brent. I think that would be a good question for Database Administrators Meta.

Brent Ozar

1:59 PM

Thanks man! I'm on it.

bluefeet

@BrentOzar Just as an FYI on how this works

42

Q: Is it acceptable to use Stack Overflow as a Q&A for a specific product?

I work for a small software start-up and I love Stack Overflow. Is it acceptable to encourage our customers to post questions on Stack Overflow so we can answer them there and also let the community benefit from it? Would customers shy away from the fact that it is too public?

support outsourcing faq-proposed

Brent Ozar

Oh sweet, that's even better. I was trying to find something like that.

Paul White

@BrentOzar Could I also humbly and politely ask you to check with the community on meta before creating new tags like sp_blitz and sp_blitzindex, especially if you're planning a mass retagging exercise. Also: what the CM said :)

Brent Ozar

Hahaha, yeah, I read the documentation: stackoverflow.com/help/privileges/create-tags

It seemed way too light, heh.

Perfect - based on that meta question, it looks like we're in good shape?

bluefeet

@BrentOzar You probably won't get as much push back on DBA as you would on SO

Brent Ozar

2:03 PM

I'm only tagging the questions that are support questions about the scripts.

Yeah, I wouldn't do it on SO, doesn't make sense there.

Paul White

@BrentOzar Sure, I just remember Ola's tag was burned though I don't recall the exact circumstances. Seems like something the community might want to express an opinion about. Also I like making work for you.

Brent Ozar

HA

I was totally shocked when I searched for sp_Blitz* stuff this morning and found dozens of things on there already.

Felt really stupid that I hadn't already set up alerts so I could jump in and answer stuff with those keywords.

Paul White

@BrentOzar Yep understood, just remember our home page isn't as rapidly-changing as SO.

And I know the dba.se world isn't ready for a whole home page of Brent.

Brent Ozar

HAHAHA, yeah.

Paul White

Personally I have no problem with the retagging, so long as it's done gradually, but others might disagree with me.

Brent Ozar

2:08 PM

Yeah, I don't wanna do a tweet or an email to the list and say, "Head over here now to ask a question!" I'm trying to be more careful these days about using my megaphones.

dezso

@PaulWhite I, for one, don't disagree with you

Paul White

@BrentOzar Oh I'm sure we'd welcome the extra visitors, I just meant to limit the rate of retagging (home page bumps). Don't forget to add/suggest an excerpt and wiki for those tags when you get a moment.

Brent Ozar

Yeah, I'm done retagging already. I was kinda stunned that there were any questions.

Paul White

Okidoki!

Brent Ozar

Working on the excerpt & wiki next. Looking at a few examples because I wanna make doggone sure it doesn't look like it's promoting us.

Paul White

2:16 PM

I'm sure we can rely on your natural shyness and humility :)

Brent Ozar

/me puts away the billboard

Paul White

:-D

Zane

2:46 PM

Yo

Hmmm. Don't think I've ever seen @BrentOzar chilling in here before.

Brent Ozar

It's been a looooong time.

Kinda fading away from Twitter - the signal-to-noise is pretty rough. I switched over to our company internal chat room.

Zane

@BrentOzar we actually had someone ask about outputting sp_BlitzSomethingOrOther to an email friendly document so there's precedent.

bluefeet

@BrentOzar slumming it?

Zane

@bluefeet hey we are classy as F

Awww yeah got a gold badge on DBA finally!

bluefeet

@Zane of course, it's the heap

Brent Ozar

2:52 PM

HAHAHA, slumming it.

Yeah, I really want sp_Blitz output to email - specifically, the differences from the last run.

It's gonna require me writing the results to history in a database, and doing a diff between passes, and then getting that out via database mail. It seems doable. Then just like set it up in a weekly Agent job.

We wanted that really bad, and the sp_Blitz app we had a while back was supposed to be the first step down that road. We hit a small roadblock though. It was called "user tech support."

"The PDF export doesn't work for NT4"

Paul White

@Zane Congrats - a Famous Question!

@BrentOzar Approved your tag wikis. Don't forget about Database Administrators Meta, when you get time.

James Anderson

@Zane nice. I hadn't seen that question

Paul White

I have way too many tabs open at this point.

Brent Ozar

@PaulWhite OK, sure! About the meta - you want me to ask there, or to create the tags there?

Paul White

@BrentOzar Ask a question there if you're interested in getting community opinion on the support questions idea thing.

Brent Ozar

2:59 PM

Gotcha, cool.

Paul White

1 hour ago, by Brent Ozar

Howdy folks. Odd question: would it be crazy of me to move sp_Blitz/sp_BlitzIndex/sp_BlitzCache/etc support questions over to Stack? We're using Uservoice, and I hate it.

I know @bluefeet posted an SO link, which seemed pretty helpful, but it can't hurt to find out how the local regulars feel about it as well.

bluefeet

@PaulWhite yup, that was just our normal guidance but asking is always good

Zane

@PaulWhite I for one am deeply offended by the matter. :)

Paul White

@Zane Yeah well you would be ;)

Zane

you know offended I get by on topic discussion.

Paul White

3:02 PM

You and your Gold Badge.

I hope you don't think we're going to start taking you seriously now.

Zane

I would hope not.

I get far too much of that at work.

Oh joy. Wells patched my box and now my teradata drivers are hosed.

Paul White

Bailing for some sleep. Look after the place.

Zane

Yes Sir!

Oh perhaps you were speaking to a more reputable user....

Some day I will convince my DEVs to stop thinking proceduraly. That day is not today.

Tom V

When you plan to rant over sp_blitzindex in the heap and notice @BrentOzar around

9

Zane

Corporate blocking policy really knocks the punch out of that joke.

"Image not found" seems to be the punchline to a lot of jokes as far as I can tell

billinkc

3:25 PM

@BrentOzar I'm sure you've blogged it, but what are y'all using? Slack? Or was it the one that automatically does the gif thing?

Phil

T-120 minutes until Beer O'Clock

Brent Ozar

@billinkc Yeah, we use Slack now. We originally used HipChat, but switched over to Slack late last year.

@TomV HAHAHA

Paul White

@BrentOzar Congrats on hiring Tara by the way. Were there many applications?

Brent Ozar

@PaulWhite Thanks! We didn't do a public round of hiring this time. When we decided to buy Jeremiah & Kendra out of the company, I knew I had to backfill a couple of spots fast, so I contacted Tara because we'd talked to her in the past.

(We have another person starting Feb 1.)

Paul White

@BrentOzar Oh I see. I miss a lot on Tweeter these days.

Brent Ozar

3:35 PM

Me too, actually.

Paul White

@BrentOzar Ooo exciting!

Brent Ozar

I do love it when we do public hiring rounds - that's by far my favorite way to do it - but I just had the chance to get Tara, and I couldn't pass that up. She's awesome.

Paul White

Yep.

Brent Ozar

One of these days, we'll earn enough to hire you. I gotta get my Gold Bar Generating Script to work right though. Still some debugging to do on that one.

Paul White

Ha ha ha.

Right. Vote limit hit. Definitely off to sleep now.

hands over to @jcolebrand

billinkc

3:44 PM

Just a monkey with a gun...

Phil

I like Slack. Still amuses me that a company is making a fortune off IRC!

The Heap is where it's at, though

Zane

:26691880 nice