The Heap™ – Consultancy ©®

jcolebrand

01:29

Hey @sp_BlitzErik quit being so bloody cheeky in your flags ;-)

sp_BlitzErik

@jcolebrand I just don't want anyone to look the fool!

jcolebrand

haha, I get it

I alerted him so we'll see if the other mods clear it before he sees it

Joe Obbish

it's too bad flags are confidential

jcolebrand

@JoeObbish some days I agree. I wanna shame some Erik's

I mean people

yeah yeah, that's what I mean, yeah

Joe Obbish

you're lucky there isn't a way to send a flag to a specific mod only

jcolebrand

01:38

@EvanCarroll for shame

> Thanks for seeing the brilliance in this proposal, despite the other two naysayers/downvoters. You should probably ban them. – Evan Carroll 1 min ago

You know better. Don't be like that.

sp_BlitzErik

I cast every flag solemnly and with a heavy heart

2

I don't know what you're even talking about

jcolebrand

You don't have enough messages pinned in here

Joe Obbish

mod abuse

everybody knows that Erik snitches early and often

sp_BlitzErik

I do my part to clear the review queue and be a productive member of the community

And also not ask ass chasing questions in chat

Just to get attention

JOE

Joe Obbish

01:53

that didn't even notify me

never heard the expression "ass chasing question" before. do old people use it?

sp_BlitzErik

I don't know any old people. Unless you count Brent.

Joe Obbish

there's nothing wrong with my chat questions

would you rather be asked if you can do math in sql?

sp_BlitzErik

02:07

At least that has a clear answer and requirements

Joe Obbish

wut

Paul White

03:09

@jcolebrand Imagine a smiley on the end.

Joe Obbish

@sp_BlitzErik you're good with XE, right?

hot2use

07:26

@sp_BlitzErik twas me and yes, it's a fine whisky

morning, afternoon and evening all

Tom V

09:56

0

A: What are the most relevant similarities between T-SQL and MDX?

First of all T-SQL and MDX are 2 completely different beasts. SQL is intended to query tabular relational data, while MDX is intended to query multidimensional data. I'll start with addressing your question about common mistakes. In my opinion the most common mistake is to try and apply SQL know...

If anybody still has that question in their review queue ;)

sp_BlitzErik

10:31

@JoeObbish pretty good, why?

@hot2use ah, nice!

dezso

10:42

> You can write the answer here in such a way that it doesn't look like we're promoting our product

from dba.stackexchange.com/a/192602/6219

and they have a friend here: dba.stackexchange.com/a/192600/6219

ConcernedOfTunbridgeWells

11:26

@TomV Oh, dear. The #1 source of confusion for new MDX programmers - it has a syntax that bears a superficial resemblance to SQL so people think it might work similarly. OP is in for a rude shock.

Tom V

@ConcernedOfTunbridgeWells Yeah, you only get reasonably good at it once you start thinking in the right mindset

The only "guide" for transitioning is "start over"

ConcernedOfTunbridgeWells

@TomV I have thought of doing an article on MDX for SQL programmers at various points.

@TomV Lakh Lamak sounds like a good name for an action hero from a Bollywood film.

3

Tom V

@ConcernedOfTunbridgeWells You misspelled "book"

ConcernedOfTunbridgeWells

@TomV I've seen a few attempts at that. None were particularly successful.

As an aside, I think Theo de Raadt has the best name of any prominent open-source luminary. It would make a great name for a bond villain.

dezso

@PaulWhite of course I didn't.

ConcernedOfTunbridgeWells

11:36

At one point I worked with a project manager called Sylbert Lobo, which also struck me as great name for a bond villain.

Paul White

@dezso k np easily missed

dezso

it really sounded like a comment to @ypercubeᵀᴹ

Tom V

@ConcernedOfTunbridgeWells Theo even looks like one :)

Paul White

@dezso Yes I see thanks.

ypercubeᵀᴹ

@TomV so MDX query result sets are cubes, not tables?

Tom V

11:44

@ypercubeᵀᴹ you can have more than 2 axis yes

Philᵀᴹ

Bitcoin is going bananas! Crikey

ypercubeᵀᴹ

@TomV so an hypercube ;)

Tom V

I don't know of an off the shelve client that knows how to render that though

I've done it in c# where you can just access the cellset.axis[x]

@ypercubeᵀᴹ It's called a cellset, the cube is the database

ypercubeᵀᴹ

cellset, nice name

Tom V

@ypercubeᵀᴹ I'll add that to the answer, thanks for asking

dezso

11:56

@Philᵀᴹ techcrunch.com/2017/12/06/nicehash-hack

hot2use

@Philᵀᴹ sure is. 0.146 lakh USD and still going strong

ConcernedOfTunbridgeWells

There we go ...

Lakh Lamak

McNets

morning

ConcernedOfTunbridgeWells

Not even in GMT.

gbn

@Philᵀᴹ is bananas that the new exchange rate coz it's meaningless against EUR or USD any more

ConcernedOfTunbridgeWells

12:05

@gbn You mean it needs a banana for scale?

gbn

@ConcernedOfTunbridgeWells guess so. And when the arse falls out of bitcoin we can turn it 90 degrees

James L

makes me wish i hadn't sold in april

gbn

@JamesL I had a stop limit at what I thought was a silly price.

ConcernedOfTunbridgeWells

@gbn Yes. The ultimate bubble market - speculation in something completely artificial.

James L

i saw that steam dropped bitcoin support because it's impractical for payments right now

ConcernedOfTunbridgeWells

12:08

I'd be tempted to short it, but the market can stay irrational longer than you can stay solvent.

James L

@gbn i'm tempted to buy the next crash

gbn

like many folk, I punted a few 100 eur. I've done OK, could have done better....

James L

i checked my accounts on all the exchanges last night and found i had some bitcoin gold credits and small numbers of satoshis that were once near worthless but now add up to like $250

gbn

I bought a mere 100 EUR at about 9600 EUR vs BTC last week. Up 35%

I read this guy mustachianpost.com/2017/12/04/…

> Don't wait for Bitcoin or Ether or Litecoin to come down again. Or that they go below a certain threshold. Tomorrow the bitcoin may be at CHF 1'000, or at CHF 35'000. Nobody has any clue

he's richer than me it seems, so his idea seems legit

James L

yeah i dunno

gbn

12:12

can I afford to lose 100 EUR if it bombs to 1000? Yes. Then I can punt another 100

if it hits 35k, I've made 250 euros

James L

i kind of want to get one of the digital cats

gbn

For comparison: we spent around 155 EUR (174 CHF) on a lovely meal last night. (Switzerland is expensive).

@JamesL Does it shit bitcoins in the neighbours' gardens?

James L

@gbn i think you can breed and sell them

gbn

Cryptokitties

Just googled it

"Ethereum for girls"

James L

it's like a parody of beanie babies but i'm not sure it's supposed to be

Tom V

12:18

9

@ConcernedOfTunbridgeWells FTFY

Tom V

12:52

Thanks for the improvement @AndriyM

Andriy M

@TomV No worries. I didn't want to change much at first (pretty much only the "axis" bits) but ultimately couldn't move past other things. I trust you will always let me know if I cross the line

dezso

13:14

First and most important: get the name of the product right ;) (see my edits to the question) Otherwise, this is not a good fit for the site. You might want to try it in chat — dezso 15 secs ago

Ouch. No. Don't do this. — dezso 7 secs ago

hot2use

13:30

@dezso Going, going, going, and .....

Tom V

@dezso I'm waiting for the rolback :D

dezso

@bluefeet do DBAs@SE close-hammer questions often? ;)

bluefeet

@dezso all the time

sp_BlitzErik

14:17

@TomV queries can get memory grants up to 25% of max server memory. that could be a lot.

(by default)

(unless you monkey with resource governor)

Tom V

@sp_BlitzErik but is that what he's looking for?

sp_BlitzErik

i have no idea, your comment just sounded like queries can't use a lot of memory

Tom V

@sp_BlitzErik you're probably right that I was a bit brief but I don't think that's the problem he's investigating or else his question would have included more details I think

sp_BlitzErik

your optimism is appreciated ;)

did you hit the "just do a procedure with a for loop" answer in the review queue yet?

Tom V

14:33

hmm, I'm not sure how to respond to that :)

none of the delete comments fit, but it has no value either

sp_BlitzErik

it is very low quality

Joe Obbish

🚨 red dot alert 🚨

sp_BlitzErik

that sounds like you're making fun of the offshore team

don't be terrible, joe

Joe Obbish

don't know where you're getting that from

this unicode stuff is great

that's the point I'm making

ypercubeᵀᴹ

@TomV I voted delete, without comments

sp_BlitzErik

14:48

i can see the emergency

Joe Obbish

@sp_BlitzErik will send an email when I get a chance

sp_BlitzErik

about what?

Joe Obbish

about the thing that I responded to

hmph

sp_BlitzErik

i look forward to your correspondence.

ypercubeᵀᴹ

This is an answer to a question that pretends to be an answer. — dezso 14 mins ago

sp_BlitzErik

14:52

regardless of how it's spelled.

Zane

yo

sp_BlitzErik

@Zane i thought you were dead

Zane

Yeah. Just stopped going to the office for a while. I always forget to fire this up with I'm WFH

Also holiday season so I've been slacking off quite a bit.

lol

I'm showing @JoeObbish as being Joe Joe Obbish on my screen for some odd reason.

gbn

@Zane His rapper name? Ice ice baby...

Andriy M

@ypercubeᵀᴹ or is disguised as an answer

Zane

15:07

Oh... It's doing that for everyone it can't render the photo for.

@gbn has a similar problem.

Tom V

Hey @Zane

Zane

Yo

Tom V

You hurt your face again?

Zane

nah. not yet.

Tom V

:p

Hydraulics don't work on my friends trunk and I managed to bash myself in the face with her bike rack.

Tweeted by Zanebrunette on November 30, 2017 at 11:45 PM

Zane

15:15

Oh that one.

Yeah.

Was a pretty good one I suppose.

I should have taken a picture. Not sure why I didn't in hindsight. Would have made it much funnier.

sp_BlitzErik

is your last name really brunette?

Zane

Yeah.

ConcernedOfTunbridgeWells

@Zane What colour is your hair?

Tom V

Maybe I should make a new action figure photoshop for "Zane Brunette"

ConcernedOfTunbridgeWells

@TomV Get it 3D printed on Hero Forge

Zane

15:20

@ConcernedOfTunbridgeWells an incredibly dirty blonde.

2

ConcernedOfTunbridgeWells

@Zane /r/nocontext, or Ooo er. Sounds a bit rude.

Zane

lol

Taken out of context most would assumed we are talking about something much more exciting than my hair.

ConcernedOfTunbridgeWells

@Zane Well done. Explained at great length per the room policy.

Zane

Indeed.

Tom V

@ConcernedOfTunbridgeWells I want my 10 minutes back

There really is a /r/ for everything

gbn

15:39

Bitcoin is mad. 14.3k EUR. Dunno what that is over there

@JamesL: could have made a few quid in the last few hours

Max Vernon

@gbn a ton.

dezso

@gbn I am waiting to see how spectacularly it will crash eventually

Tom V

It's impossible to manage risk at this point, it's an all or nothing bet

which is ok if you treat it like that, but a lot of folks are going to get hurt at some point (I didn't say "soon")

Zane

Right. Everyone seems to think bitcoin is just some magic way to make money.

gbn

@Zane As long as I make something

James L

15:47

@gbn yeah, tbh i had just had a transfer from last week go through and bought more

only 400 EUR

i put a limit order to buy for the current price minus a few percent. it's volatile enough that it will get filled without having to buy at the current all-time high

it's just gambling though, no idea what will happen

gbn

indeed

make a few euros to buy the missus some shiny stuff for xmas

James L

it probably makes more sense to buy with credit cards and pay the credit card fee, since it's going up by more than the credit card fees every day...

i was too young for the dotcom bubble but older people in the office tell me this reminds them of it

one guy went from having $300k in the bank to owing $80k

gbn

I'm too young old for the South sea bubble and Tulip mania. Same principle

Borrow to "invest" classic bubble...

James L

also hearing stories about people buying with credit cards at all-time highs, then freaking out when there's a dip and selling at a big loss

sorry don't mean to turn this place into bitcoin chat

dezso

@JamesL is it offtopic or what?

James L

15:54

@dezso no idea, just concerned that it might be becoming tiresome for some people

gbn

@JamesL Could be worse, could be mysql

ConcernedOfTunbridgeWells

@gbn Or MongoDB

gbn

he he

ypercubeᵀᴹ

16:24

-1

A: How do fill table with values for 5 years?

You can do a Procedure with a For inside of it to fullfil the table.

sp_BlitzErik

aw, you found it

ypercubeᵀᴹ

fullfil the table...

sp_BlitzErik

better call dr. phil about that

Zane

lololol

Well gee thank you kind sir what a lovely answer.

Philᵀᴹ

LOLs Bitcoin

Nearly $19k now

Zane

16:26

So this is the day bitcoin crashes then? Or maybe tomorrow

ypercubeᵀᴹ

@sp_BlitzErik I had voted, long time ago. Just noticed the typo and wrong use now

sp_BlitzErik

that reminds me of when my boss would ask for a report

"just do a join"

"to what?"

"the data"

"OH OKAY"

ypercubeᵀᴹ

join all the data

Philᵀᴹ

$19120

W

T

F

Zane

@sp_BlitzErik My favorite was back when I was working at Wand. I had a boss who would always say "Well google could do it"

Yeah I bet they could. I as an individual am not much competition for google it turns out.

sp_BlitzErik

16:31

"fly to the moon, nasa could do it"

2

Andy K

cya

James L

16:47

@Philᵀᴹ looks like it's only a couple exchanges where people are seeing that price but still wth

no idea what's going to happen next week when the futures products launch and bears can enter the market

Evan Carroll

blog.2ndquadrant.com/…

sp_BlitzErik

@EvanCarroll now you'll have to learn about parameter sniffing

sucks to be you

dezso

17:23

@sp_BlitzErik sniffing is still better than snorting, for example. Or snoring.

I can't stand when parameters are making all those horrendous sounds around me.

sp_BlitzErik

i prefer parameter ennui

ConcernedOfTunbridgeWells

@dezso Something to do with code smells, I imagine.

dezso

Lucky for you, sp_blitz people are lurking around every corner here! — Anthony Genovese 53 mins ago

and they are sniffing, too @sp_BlitzErik

sp_BlitzErik

lol

Joe Obbish

17:52

should those tags be deprecated or something?

sp_BlitzErik

eventually. for now it's helpful for us to direct folks to github.

James L

is that why you guys started using github

i remember brent used to be pretty militant about no one modifying the code

sp_BlitzErik

yeah, now we can be militant and still accept good contributions

heh

i hope someday to make one

3

James L

the new sql prompt has code analysis built in

sp_BlitzErik

the new sql prompt pegs my cpus to 100% and crashes ssms when i work on a large script

so uh

turn that mirror

James L

17:56

yeah

i have a database that has 30k tables

it makes sqlprompt run out of memory

sp_BlitzErik

lol

Joe Obbish

@sp_BlitzErik surprised you approved of my idea then

sp_BlitzErik

@JoeObbish i can always not merge it

Joe Obbish

one day I hope to have the honor of being the author of the least used script of the bunch

I will do my best to get through code review

if I have to test on azure I'll need to "borrow" some DTUs

sp_BlitzErik

you have some good competition

most of our scripts collect dust, i think

i finally got blitztrace and blitzrs deprecated earlier this year

James L

18:01

what was wrong with blitztrace?

sp_BlitzErik

nothing was wrong with it, there was just no more development being done on it

Joe Obbish

too many race conditions

sp_BlitzErik

good enough plan found

ypercubeᵀᴹ

19:07

@JoeObbish I saw you wrote a stab as I was posting.

Feel free to post an answer and I'll delete mine.

I'm not entirely sure about the details - regarding isolation level or locks needed - to accomplish what the OP wants. I mean no raws sneaking in in the 2nd table that shouldn't.

sp_BlitzErik

sounds like a bunk question

ypercubeᵀᴹ

Iit's not very clear. But I don't see any close votes.

Joe Obbish

19:24

@ypercubeᵀᴹ no worries

your answer is fine

I'm doing what Tom did yesterday

I think I might have a way to accomplish his stated requirement

and figured the question might get closed before that

Zane

@sp_BlitzErik ha!

sp_BlitzErik

19:49

Joe Obbish

@sp_BlitzErik fixed it for you

sp_BlitzErik

weird, all i see is the same unproductive site activity

i'll check back in a few years

docs.microsoft.com/en-us/sql/ssms/…

Joe Obbish

@sp_BlitzErik through the eyes of a snitch that's all you'll see

sp_BlitzErik

Showplan:
Updated links to point to correct documentation.
Allow single plan analysis directly from actual plan produced.
New set of icons.
Added support for recognize "Apply logical operators" like GbApply, InnerApply.

Joe Obbish

new... icons

I have a bad feeling about this

I bet they're flat and ugly

sp_BlitzErik

19:59

your mom

Interjection: your mom

(pejorative, US, Britain, slang) A general purpose insult, often used to comedic effect due to becoming stale.
Conrad: I am not sure if this phrase is commonly used...
Dominic: Your mom is commonly used.
2004, Napoleon Dynamite
Deb: Well, isn't anyone else here trying to earn money for college?
Kip: Your mom goes to college.

there we go

Joe Obbish

thanks for the notify

that was needed

sp_BlitzErik

just being thorough

sp_BlitzErik

20:14

oh my god

this is butt ugly

Tom V

OP accepted without an up vote 🤨

sp_BlitzErik

context is everything

Tom V

The mdx thing

sp_BlitzErik

speaking of dmx, he did a christmas song

Tom V

For his dawgs

Joe Obbish

20:27

@sp_BlitzErik I TOLD YOU

sp_BlitzErik

i know, and i put up such an argument

i defended microsoft's aesthetic choices

Joe Obbish

I'm an industry veteran

you should listen to me

sp_BlitzErik

there's not even a consistence color palette

top is black and yellow

other stuff is blue and sort of purple

Tom V

@ypercubeᵀᴹ do I remember correctly you liked Sci fi?

Or reading in general

sp_BlitzErik

you have a father

he has a chin

it's probably on his face

ypercube.blogspot.com

Tom V

20:34

I so enjoyed echoes by Laura tisdall

ypercubeᵀᴹ

@TomV yes to both

Tom V

@ypercubeᵀᴹ fairly sure you're going to enjoy that book

ypercubeᵀᴹ

@sp_BlitzErik ha, thnx! I had forgotten I had done that. Long time ago

sp_BlitzErik

top web dev

ypercubeᵀᴹ

@TomV Interesting thnx. I'll get it for Christmas

ypercubeᵀᴹ

21:01

0

Q: Average of averages fron joining two tables

Looking for another ways to write a query that finds for each student the average of averages in each subject.my query is working fine, I'm looking for another approaches For example: the grades of me(aka Error404) are: Algebra: first exam: 99, second exam: 97, third exam: 96 ---> Averag...

I'm getting bored form these "my query is working fine, I'm looking for another approaches"

sp_BlitzErik

i can't imagine it's working fine, "fron" isn't valid syntax.

James L

21:18

@gbn yes, it is a database-related site after all

ypercubeᵀᴹ

We have an influx of "serious" questions

0

Q: Do my relational algebra operations produce the desired results?

I had tried to do a problem with the following tables, of finding which sailors, sname and rating, had reserved both a red and a green boat. I had tried this: and was told it was wrong but not given an explanation as to why. Can someone explain what the problem is?

relational-theory relational-algebra

After a previous question with screen copies, they felt the could improve, with photos ...

sp_BlitzErik

serious

and then

0

Q: what permission should an application login have on sql server

what permission should an application login have on sql server. Should I assign database reader and writer role only or database owner ? I will be using a sql server authentication as the application will be using asp.net.

sql permissions authentication logins role

seriously bad

MDCCL

22:04

@PaulWhite Nice profile picture, very monetary

ypercubeᵀᴹ

22:51

There, hope that's good. — windy401 7 mins ago

Evan Carroll

Iran has easily the best PR team of any nation state. I feel like they're playing the cards right in a new game of survival, and Russia and America are lagging behind at least 50 years.

I'd give it to Trudeau too. These are the new faces of neoliberal populism.

sp_BlitzErik

23:25

nothing says neoliberal populism like militarized morality squads and beheading people you disagree with

then again, given the people you cheer on, perhaps it is

youth, huh?

Evan Carroll

> nothing says neoliberal populism like militarized morality squads and beheading people you disagree with

I so agree with that statement, fully.

You got Trudeau arming the Saudis, and getting cozy with Israel. And, as you've indicated, Iran beheading people they disagree with, and American drone bombing them.

Point here is, the only people that try to dress that up for modern first-world Millennials is unironically Iran, and Canada. And, they're leagues ahead of the rest of the rest of the world getting public approval for their violence.

James L

23:53

i'm not sure iran's PR is working, at least not in north america outside of the fringes of the right and left

that said, i think they did the world a considerable service by backing the PMU and hezbollah against isis and various al qaeda offshoots in syria and iraq

Evan Carroll

How do you read those numbers? Their unavailability rating has dropped ~10% in 10 years, and their favorability rating is up almost that much in the same time.

Transcript for

The Heap™ – Consultancy ©®