The Heap™ – Consultancy ©® - 2020-02-18 (page 1 of 2)

Master Database

02:00

-1

Moderators, are you going to let this one https://dba.meta.stackexchange.com/users/5555/phil%e1%b5%80%e1%b4%b9 loose? Persistently went after me and called me trolling at Complain on moderator Paul White's violating privacy and suffocating speech. Posted a cartoon youtube video to mock and ...

support

Evan Carroll

what does that title even mean?

Jesus Christ this padawan needs work.

soo unrefined

swasheck

03:03

@McNets is rum off-topic for dba? i think not. i've done some of my best on-call work blitzed on scotch

@PaulWhite9 TIPE TO ME

Paul White 9

@swasheck No fun now I'm on a real keyboard

swasheck

@EvanCarroll i think you mean, "RONALD REAGAN"

@PaulWhite9 son of a nutcracker

what's the 9 for?

Paul White 9

Shog

swasheck

chat in stackexchange kinda feels like abandonware

Lamak

03:30

@PaulWhite9 how was sonic?

swasheck

the hedgehog?

or the burger drive-in?

Lamak

@swasheck I assume he was going to watch the sonic the hedgehog movie

Paul White 9

@Lamak About what I expected

Lamak

at least they changed the initial abomination that it was

Paul White 9

@Lamak The rendering of Sonic himself you mean?

It was entertaining enough and a nice diversion on a damp Tuesday afternoon.

Plus we had popcorn.

Lamak

03:45

@PaulWhite9 yes

Paul White 9

Jim Carrey was Jim Carrey

Lamak

@PaulWhite9 yes...in a role that mostly fits jim carrey

swasheck

such a method actor

Paul White 9

he is very flexible

Memor-X

i'm glad they are calling him Robotnik and not Eggman

dam millennials and their dumb Dr Eggman. it's an insult not his name

Paul White 9

03:55

doughtnut lord

and of course they left an opening for a sequel

with the female character whatever she was called

foxy something or other

Lamak

tails?

Paul White 9

Oh yes. Tails.

swasheck

i thought that was dora

Lamak

the explorer?

Paul White 9

Tails (Sonic the Hedgehog)

Miles "Tails" Prower (Japanese: テイルス, Hepburn: Teirusu) is a fictional character in Sega's Sonic the Hedgehog series, and the title character's best friend, sidekick, and most recurring ally. Tails also appears in his own spin-off series, comic books, cartoons, and films. He is the second character to consistently appear by Sonic's side in the series. The name "Miles Prower" is a pun on "miles per hour", a reference to the famed speed of Sonic the Hedgehog. He is a two-tailed fox hence the nickname. A mechanical genius and skilled pilot, he is able to fly due to his two tails being able to rotate...

swasheck

04:04

how many other doras do you know?

i stand corrected

Paul White 9

Lamak

@swasheck I don't know any doras

swasheck

that's ridiculous. who names the female lead "tails"?

Lamak

is tails female?

Paul White 9

I assumed it was female, turns out Tails is male and has two tails

I only saw them briefly at the end of the movie

Lamak

04:08

assuming gender, how SE of you

Paul White 9

ikr

swasheck

ouch

too soon?

Lamak

seems like ages ago

swasheck

good point. now get off my lawn

Lamak

NEVER!

swasheck

04:11

SHUT UP

Lamak

you demon

Paul White 9

deemon please

swasheck

i love daemons.

billinkc

04:27

So dreamy

Lamak

a real deemon came to chat

Paul White 9

catch him if you can

Lamak

wasn't that DiCaprio?

swasheck

i think that's ben affleck

oh. nevermind. whoosh!

A J 9

04:44

The name's Damon, Matt Damon.

Paul White 9

A J 9 Nice 9

A J 9

;)

Memor-X

05:11

Sonic - Introduce Sonic and Robotnik
Sonic 2 - Introduce Tails
Sonic 3 - Introduce Knuckles
Sonic 4 - Introduce the rest

Sonic 4 will end up being like Sonic Avengers Endgame

Tom V - try topanswers.xyz

06:30

@MasterDatabase Surely that will help lift the system imposed question ban :D

gbn

Good morning all. Did I miss anything?

Tom V - try topanswers.xyz

Good morning @gbn

gbn

Who's the current village idiot then? Me, because I have to ask...?

Andriy M

The latest local drama is still in progress

Tom V - try topanswers.xyz

Weren't you the previous village idiot? Hard to keep track these days

gbn

06:32

@TomV-trytopanswers.xyz I'm claiming the crown back

Tom V - try topanswers.xyz

The competition is fierce the last couple of days

Memor-X

@TomV-trytopanswers.xyz isn't Meta separate from a main site system ban?

Andriy M

@Memor-X I think it's more about his behaviour and credibility in general, not about technical connection

Tom V - try topanswers.xyz

Peter got an honorable mention this time as well

Memor-X

> Claimed that I am going to say the earth is flat.

didn't they just do that?

self for fulling prophecy

i do like how the 2 extra characters in Phil's name translate to %e1%b5%80%e1%b4%b9 in the url

Andriy M

06:39

People don't wear those characters in their nicknames for nothing

Tom V - try topanswers.xyz

@Memor-X That claim is a bit of a stretch imo:

18 hours ago, by Philᵀᴹ

I'm half expecting him to drop the "The Earth is flat" bombshell soon

Peter Vandivier

@TomV-trytopanswers.xyz lil’ ol’ me? 🥺

McNets

07:00

Morning

Andriy M

@PeterVandivier Don't underestimate yourself. You are top of the community and you've got elite friends

McNets

@swasheck never!!

Peter Vandivier

@AndriyM the top 1% of users control 99% of the silliness

Andriy M

07:15

@PeterVandivier Ah, so that's what that suppression must be

Peter Vandivier

Mystery solved, comrade. We must begin redistribution of the Jokes

Andriy M

Could I at least keep those I've explained at great length?

Peter Vandivier

The explanations are common property now

McNets

08:00

humm, I thought I posted a comment on the meta question...

Peter Vandivier

Go home @McNets, you’re drunk 😉

McNets

@PeterVandivier 😂 I lied, it was a disclaimer just in case...

Peter Vandivier

I never lie about being drunk

But that’s easy because I usually am

Philᵀᴹ

Morning! Oh, I have mentions. Scrolls back

McNets

@Philᵀᴹ STrolls back

Peter Vandivier

08:05

Eyyyyyy

Tom V - try topanswers.xyz

@PeterVandivier That explains a lot

Philᵀᴹ

"mocking me with the youtube catoon character" -- Oh, it wasn't me that did that. It was Beavis

@A_V I used to use it. Then we stopped offering it as a porting option & everyone shifted to Oracle. It used to get very grumpy with lock escalation, but that was 20 years ago when memory wasn't as easy to come by and I was playing with TB of data

Oh, no, I'm in trouble now

Paul White 9

@McNets You did. It was flagged as "unfriendly or unkind", which it was.

Philᵀᴹ

@EvanCarroll this new AI of yours needs some refinement

McNets

@PaulWhite9 no more than his messages here, but it's ok

Attacked my posts on the main site, by deleting my post and very likely downvoting my posts including very early ones.

Paul White 9

08:17

Two wrongs don't make a right...

McNets

I don't think anybody here downvoted his early post

Paul White 9

No way to know

Philᵀᴹ

I think someone else said further up - bit worried about this dude now. Probably needs some IRL help

Tom V - try topanswers.xyz

I'm pretty sure it's going to escalate

Peter Vandivier

08:41

@Philᵀᴹ yea, that was me. like - rehashing what has happened isn't productive, but there's a concerning fixation demonstrated in the way he keeps coming back to fight with people who really aren't fighting back with him. or at least certainly not to the level he thinks we are

i'm not gonna let him nuke the silly back and forth i enjoy about chat, but i do get a little meta-think when i start to wonder if he's actually okay or not

@TomV-trytopanswers.xyz i really hope it doesn't... :/

Andriy M

He might actually not be an adult. If he is, his behaviour and reactions are bizarrely immature. So it looks concerning either way.

McNets

@AndriyM I never told you but I'm seventeen right now...

Philᵀᴹ

I'm not actually bothered about him singling me out for a meta post

Peter Vandivier

the dude's been on SO/SE for a decade. he's not a child. and that whole "_they accused me of being a child_" thing was never a thing. it was [a joke during the rice exchange](https://chat.stackexchange.com/transcript/message/53544814#53544814)
> You can put rice on salad
> You’re an adult
> I assume
> (Are you a child)

i feel like that's a fairly obvious joke setup, but i'm happy to EAGL it if need be

tbh i don't think explaining anything to this guy is helpful though, cause he's so clearly looking to be offended

Andriy M

Ah yes, even his DBA account, where he isn't very active, is very old. That's a good point.

Andriy M

09:05

-40

Q: Are "too broad" and "needs more focus" abolishable?

Q&A can be conducted at different levels of details. If a question asks about the big picture, an answer should just answer the big picture. The sun is giagantic, but when you see from the Earth, it is "focused". If you use a microscope to look at an ant, the ant is not "focused". Which level of ...

discussion close-reasons too-broad focus

That settles it. He knows what 'Too broad' means very well.

As a curious self-learner, his position on that subject is understandable, but as a veteran SE user, he should still know better than being ~~stubborn~~ insistent on submitting such broad questions.

Paul White 9

09:18

wow

Andriy M

Also, I think that meta question shows that he's not a flat Earth believer.

Peter Vandivier

Reading the remaining comments on that post seems to imply there may have been some of the familiar inflammatory statements made there as well

Philᵀᴹ

The "'Abuses', 'power users' blah.." comment certainly raised an eyebrow

Andriy M

09:34

All of his accounts are hidden. And some of them are still in cooldown. That in itself doesn't have to be telling much, but it isn't nothing either.

Philᵀᴹ

09:56

@AndriyM nice graphs stackexchange.com/users/52354/tim?tab=reputation

McNets

10:31

@Philᵀᴹ It seems that majority his rep comes from questions rather than answers

Philᵀᴹ

11:05

@PeterVandivier Peter "completely gone out of control from the beginning" Vandivier

Peter Vandivier

fake news

i was out of control well before then

Philᵀᴹ

Builds a wall

Peter Vandivier

i am opposed to walls as they reduce the free flow of both rice and chicken

Andriy M

11:23

Not to mention salad

Peter Vandivier

only for the grown ups

McNets

Are you eating? lunch?

Andriy M

I'm not eating lunch, but I will be, soon (hopefully)

McNets

11:43

@AndriyM I'm hungry, and you talking about rice, chicken and salad!!! ;)

Philᵀᴹ

Hmm, dunno what to have for lunch

Cooked a nice curry last night

A J 9

@Philᵀᴹ what were the ingredients?

Philᵀᴹ

@AJ9 It was this: jamieoliver.com/recipes/seafood-recipes/…

A J 9

@Philᵀᴹ Ah. Nice. Same as what we use except prawns.

Max Vernon

12:16

@Philᵀᴹ since I consider this kind of messaging counterproductive and unhelpful, I've edited the content of the question out, and have voted to delete the message. If Tim has a problem tell him not to @ me.

Tom V - try topanswers.xyz

12:32

Edit war!

A J 9

@Philᵀᴹ Did you remove your post?

Philᵀᴹ

Yes

Seeing as the question has been nuked

Max Vernon

I didn't mean your answer should go, but at the end of the day I suppose it won't really matter.

Philᵀᴹ

Indeedy, makes no difference

Andriy M

@McNets I was hungry too! But hey, then I went to have lunch and that helped :)

Max Vernon

12:34

A third person needs to hit delete on that

A J 9

@MaxVernon As a moderator, I'd advise not to engage in rollback war. Raise a flag instead.

Peter Vandivier

just to put my 2 cents in, i would encourage people not to engage in the edit war, or indeed engage on those posts anymore than you feel absolutely compelled to. but also i'm really hoping the friendly neighborhood spider mods will step in and properly nuke them

Max Vernon

I did

Tom V - try topanswers.xyz

@AndriyM I hate the word lunch, I can't afford lunch

Peter Vandivier

@AJ9 ah, well, you beat me to the sentiment then :p

A J 9

12:35

@PeterVandivier I didn't get you.

Andriy M

@TomV-trytopanswers.xyz I'm so sorry. I'll try to avoid mentioning the word 'lunch' going forward. I mean, going to lunch. And coming back from lunch too.

A J 9

@TomV-trytopanswers.xyz How about mid-day meal?

Peter Vandivier

@AJ9 ? just meant that i was too slow typing this and you scooped the sentiment with the additional authority of a mod (didn't actually realize you were one)

Tom V - try topanswers.xyz

I only had salad

Peter Vandivier

@TomV-trytopanswers.xyz with rice?

Tom V - try topanswers.xyz

12:37

With goat cheese

which was nice

A J 9

@PeterVandivier You can recognize easily. Mods have names in blue color.

Peter Vandivier

tbh i never noticed the color difference until just now, it's very subtle IMO

Tom V - try topanswers.xyz

Undercover policing

Philᵀᴹ

A spy

Tom V - try topanswers.xyz

Signs of oppression

Philᵀᴹ

12:39

Damn these elite, they're everywhere with their privs

A J 9

Take a break, @MaxVernon

Tom V - try topanswers.xyz

@Philᵀᴹ Last week I would have supported a revolution, but now I'm part of the elite, so screw those proles

Andriy M

@MaxVernon FWIW, I don't think we should edit out the contents the way you did or delete the Q altogether. It may be a rant but it's a complaint. The OP doesn't have access to chat at the moment (as far as I'm aware) so meta is the only place for that kind of complaint for him.

Max Vernon

@AJ9 lock the question, please

Philᵀᴹ

Sod it, I'm moving to North Korea. Way more liberal

A J 9

12:44

@MaxVernon I am not a moderator on Database Administrators

Max Vernon

Then what purpose are you serving by asking me to cool off? This Tim needs to stop with the calling out of respected members of the community.

we've all been trying to help this person far too long.

A J 9

I am just saying if there is a rollback war, don't engage in it. Just raise a custom moderator flag.

Philᵀᴹ

To be fair, we need to leave him alone and ignore him

Tom V - try topanswers.xyz

@MaxVernon Relax Max. No need to get all worked up over some internet troll

Max Vernon

I'm not wotked up lol

Tom V - try topanswers.xyz

12:47

yet :)

Max Vernon

Some people just need to be stood up to occasionally

Peter Vandivier

um... i already raised the most helpful custom flag of all

yesterday, by Peter Vandivier

Troll in the Dungeon!

►

yw

Philᵀᴹ

Not really much point if they're really confused, though

Peter Vandivier

Chat is confused! It hurt itself in its confusion...

Max Vernon

It makes one wonder what one needs to do to get a account-banned

Philᵀᴹ

12:54

Ask @EvanCarroll :D

Max Vernon

Lol

Tom V - try topanswers.xyz

Peter Vandivier

☝️this guy gets it

Tom V - try topanswers.xyz

I think the guy is entertaining

He's a quick learner, his trolling is quickly becoming more subtle. At times the rough edges still show but he's improving a lot. Evan is teaching him well

Taryn

hey y'all stop feeding the troll. Just flag and move on.

Max Vernon

13:06

Thanks Taryn

Andriy M

Thanks @Taryn, saves me the trouble of thinking up of a response. I'm still not convinced he's a troll to be honest, but you seem to have no doubt about that. Is he really a troll? Do you know him (or of him)?

Philᵀᴹ

@AndriyM I think we need to just take her advice and leave it be?

Andriy M

I agree, that seems like the best course of action. I guess I just want to know for the future.

Evan Carroll

@MaxVernon You have to start by being indisputably right. That's the first qualifier. If you're wrong you're just laughing stock. No idea on how to get banned if you go down that route. But if you're right it's usually enough to just politely make your case. That's how I do it.

Taryn

@AndriyM No, I don't know them, but it's just easier to flag and move on. I totally understand the desire to engage, but it doesn't do anyone any good

Evan Carroll

13:16

Like take the case and point when that corrupted moderator suggested that the company he work for get DBA.SE's free sponsorship for his proprietary production that works on only one proprietary database, and he sold that as a being a "service" to the community. I'm not being a jerk. Any objective bystander would want to know how that mod wasn't removed and banned. So what did they do? They banned me.

That's the easy way to get removed. Or you could be vulgar which is petty kid shit and eventually in 100 million years when people are done being entertained, they may ask you to stop.

If he wants to rival my record, he's doing a lot of work. At least we know he's not lazy.

Philᵀᴹ

Defo fighting your cause, whatever that might be

A J 9

@Taryn Thanks

Peter Vandivier

do mods need a non-mod flag to take action on posts like that?

esp. when they're so visible

Paul White 9

@PeterVandivier No not need but they're helpful in gauging opinion.

Peter Vandivier

i kind of assume flags in these situations are just redundant, but happy to raise still if helpful 🤷‍♂️

okay then

Mathematics

14:05

I have a 10,000 character json column, which I want to do a include aka like operation on...
maybe 1000 rows or more...
I am thinking about creating a checksum column instead, are there any better ideas ?

Philᵀᴹ

What do you mean? Store a checksum and keep the .json file external to the DB? How will the file itself be used?

Mathematics

at the present file is stored in table as well

querying it would be expensive operation

so maybe storing a hash would be faster and quick way ?

only got an hour to fix the issue though lol

Philᵀᴹ

if it's on the FS, just store the full path

seeing as filenames are unique

Mathematics

its not in fs, its stored in database

McNets

@Mathematics what about two tables?

Philᵀᴹ

14:12

but it all depends on your design etc

Mathematics

@McNets one with data and other with hash ?

McNets

@Mathematics yes

Mathematics

I will have to change references at few places then, but it was a consideration

Philᵀᴹ

how does the app "know" which file it needs currently?

Evan Carroll

@Mathematics so what you have a 10k character json column, store it as json in a real database. this isn't 1992. it get stored out of line.

Mathematics

14:14

A clients gets a view of 1000 rows with X,Y,Z columns where as Z column is json with 10,000 characters

Now they do something with 1 row, in backend I need to figure out if some string exists in rest of json values in all rows

@EvanCarroll I would but I only have an hour lol

Evan Carroll

what happened to tim, is he unbanned yet or is the system still oppressing him.

James

@Mathematics you're unpacking the json string first, right? no need to store it as text.

Mathematics

@James yes the guy who developed it, made it nvarchar (max)

James

lol, what an ass hole

Philᵀᴹ

@EvanCarroll have you ever thought about joining a cult?

Mathematics

14:20

would creating a md5 be anyone helpful in this situation

McNets

He's taking a break

Mathematics

as a temp fix

Evan Carroll

and day one, "I know everyone here is following David Coresh, but really he's a cuck that molests children and I'm more of a God anyway... Just saying, if it's on merits ya'll would follow me."

It would be a glorious death.

Philᵀᴹ

I think you'd have liked Heaven’s Gate

James

idk what an md5 is. I'd suggest using python's pandas library to read the json and port it into sql server. you can do pd.read_json() and pd.to_sql() and be done

Philᵀᴹ

14:25

It's a checksum

Evan Carroll

@James you should take some time to read about checksums, knowing what they are is a pretty big deal.

a useful tool you'll want to reach for very often.

Peter Vandivier

@Mathematics you know the rule : "repro is best-pro". I know you're crunched for time, but you're not gonna get any exact syntax help unless folks have something to work against dbfiddle.uk

otherwise it's all gonna be "yea you probably can/can't do that" but it won't get you what you need before your meeting (i assume)

type like the wind, comrade!

in this metaphor the wind is a direct relative of Mavis Beacon

Evan Carroll

lenovo needs to hurry up and release the new x1's

Philᵀᴹ

14:44

This is a good SO story: twitter.com/Foone/status/1229641258370355200

4

billinkc

Hashing can be effective but can only answer are these equal/unequal

Paul White 9

@Philᵀᴹ oops!

Peter Vandivier

yesterday, by Peter Vandivier

without stupidity, there would be no StackOverflow :p

Carmen Twillie, Lebo M. - Circle Of Life (Official Video from "The Lion King")

►

Paul White 9

15:10

This seems important:

36

A: What data about meta has eluded Stack Exchange until recently?

Original Data Analysis In April 2019 there was a investigation performed that looked at the number of users who regularly post and vote on Meta Stack Overflow, and how Stack Overflow answering predicted that participation. The results were that posting and voting on Meta is done by 200-300 use...

Max Vernon

@EvanCarroll no one is ever indisputably right. Take this comment, for example.

Taryn

@PaulWhite9 I'll say that when that was asked internally, there were a lot of people that were surprised by the results. Not necessarily those who work with the community day in and day out.

Paul White 9

@Taryn I bet. I see Shog9 wasn't surprised.

Tom V - try topanswers.xyz

@Taryn I would have expected that it was pretty obvious that most of the grunt work is performed by people who spend a lot of time around here, and there is a large overlap between people that spend a lot of time here and people who visit meta.

Paul White 9

15:25

Not least because meta holds and maintains most of the rules and guidelines for curation and mod-like activity.

Taryn

it was to those who interact with the community every day i.e. the CMs

Tom V - try topanswers.xyz

Management is known to miss the obvious from time to time

That's true outside of SE as well

Paul White 9

Also important for anyone running SQL Server 2019 CU2 and using function inlining:

twitter.com/tarynpivots/status/1229752409053745152

Peter Vandivier

@Taryn would you be at all interested in giving the reader's digest version of how you did the drop/create release? unless it was just "i guess some of these queries are gonna explode for a few milliseconds for each database #yolo"

Taryn

@PeterVandivier literally, drop function, and create function :|

per the suggestion of Joe Sack

Evan Carroll

15:35

not sure what that data shows.

someone break it down.

Peter Vandivier

well if you've got a problem with a nail, it's probably okay to use a hammer i guess

Evan Carroll

BTW look at this post... dba.stackexchange.com/questions/187090/…

Lamak

Tl; Dr: the town council meetings are boring and poorly-attended, but turns out the entire Chamber of Commerce membership reads the minutes. — Shog9 21 hours ago

3

Evan Carroll

I remember when that was controversial (dba.stackexchange.com/questions/187090/…) 8 downvotes immediately for pointing out that SQL Server lacked SOMETHING.. 2.5 years later after ignoring everyone it's +17. That's the problem with this network.

What if I wasn't so awesomely persistent and I left when it was -8 because the SQL Server borg rejected it.... We should go back and perma-ban everyone who downvoted it. They're the problem.

swasheck

@PeterVandivier re-drunk is a thing

Peter Vandivier

15:42

can't be re-drunk if you never sobered up

swasheck

@Taryn what's that guy know

@PeterVandivier fair point

Peter Vandivier

@Taryn sorry, just so i'm understanding it correctly - based on this tweet ALTER doesn't fix the inlining issue currently where DROP/CREATE does. ALTER fix is coming, but hopefully better post-ALTER fix is coming after that?

Paul White 9

@EvanCarroll It's a useful Q & A (especially the answers, as usual). It's a shame you were on such a crusade at the time. If someone else had asked it, it would likely have received no, or very few, downvotes. Something to ponder.

2

Philᵀᴹ

We've accepted him now though

Taryn

@PeterVandivier you can use ALTER, they added details to the KB - support.microsoft.com/en-us/help/4538581/… - I used drop/create during testing with Joe

Peter Vandivier

15:51

ahhhh, gotcha

someone's gotta be the first one to do it in prod, eh?

Paul White 9

@Philᵀᴹ Accepted is such a strong word 😀

There may be better ones.

Evan Carroll

@PaulWhite9... Do we know that my Padawan is a lost cause? Just think about how we'll think about him 2.5 years...

he's a flowering sith in the making.

Taryn

@PeterVandivier we're not 2019 in prod...yet, so it was all done in dev

hoping to be in 2019 by end of March

Peter Vandivier

💪

Philᵀᴹ

On linux? :D

Paul White 9

15:54

@EvanCarroll Each person on their merits. Not going to discuss that further though.

Peter Vandivier

@JL2210 We like to play games on the servers on the weekends and we couldn't get the video or sound drivers to work under Linux. — Nick Craver ♦ Sep 5 '19 at 20:30

Master Database

0

Q: Time vindicates those that are right and righteous, like me

I just wanted to share a store, my narrative on this network. In Sep 27 '17, I asked a question about how SQL Server implemented GREATEST and LEAST. This question was largely rejected by the network. I most likely had to argue to keep it open. The problem, presumably, was because I mentioned how...

discussion

WhatsThePoint

anyone able to give me a hand with some query optimisation? if i give them the query and the plan?

Philᵀᴹ

@EvanCarroll chat.stackexchange.com/transcript/message/40242416#40242416

@WhatsThePoint best to ask a question on the site

Evan Carroll

16:09

I have to say, going back and reading my own chat logs. Fucking hell I am awesome.

I'm not sure how anyone here could do anything less than love me.

Philᵀᴹ

Erasure - Love To Hate You (Official HD Video)

►

Evan Carroll

I can't play that video. YouTube just returned "HTTP 90210: You won't understand this cultural reference, you're not even close to old enough."

Cade Roux

When SQL Server recommends a missing index and puts the clustered index key in the INCLUDE isn't that redundant?

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[Study] ([StudyDateTime])
INCLUDE ([tag],[FacilityTag])

tag is the clustered index key.

It's harmless if it is there in the INCLUDE and doesn't cause duplication of that data, but is also redundant since it will be included regardless, right?

Max Vernon

@CadeRoux [tag] would be included in the index already, so yes, it's redundant. However, having it in the definition won't make any difference to the index, and it somewhat nicely documents the intent.

WhatsThePoint

@Philᵀᴹ ill do that tomorrow if i cant get anywhere then

Philᵀᴹ

16:15

@EvanCarroll You can't be far off 40, so that's LIES

Cade Roux

@MaxVernon I guess it covers the query and if the clustered index were to change, in some case you'd want it to stay but in this case if the clustered index were to change, the entire query would likely change since tag is this client's surrogate key so it's always a clustered index.

McNets

a store or a story?

Paul White 9

@MaxVernon @CadeRoux and protects you if the clustering key ever changes.

Max Vernon

@CadeRoux exactly.

Paul White 9

Oh you said that already lol

Missing index suggestions always need professional review. They're just suggestions or clues.

Max Vernon

16:21

I for one welcome our new robot index suggesting overlords.

Paul White 9

Then again, most databases need professional review and have precious little hope of ever encountering such a thing.

Surprised myself. Didn't think I was in the mood for Evan but it turns out I sort of am.

2

That doesn't need pinning though.

Cade Roux

@PaulWhite9 Yeah, I am writing a recommendation for the client, it popped up in SSMS trying to improve performance of our product inside their product and it will definitely help to some extent on many of our SSRS reports, but wanted to make sure I gave them the complete scoop. Does SQL Server downgrade a column to INCLUDE if it sees that preceding columns are already highly selective (DateTime before FacilityID because at that point FacilityID is just there to make the index covering)?

In any case, it's not really the bottleneck in this report - it's the giant XMLs that we are trying to peek into... So I'm just putting this in their hopper for their devs to think about.

Paul White 9

It's not a very smart process at all. Equality comparisons than can be indexed go in keys, everything else to make it covering for the query goes in the includes.

I should add that it is not meant to be smart, just potentially helpful.

swasheck

@PaulWhite9 just drop the CI altogether and pray for pushdown, amirite?

Paul White 9

So good to have you back @swasheck

swasheck

16:34

like herpes ... i never go away ... just go dormant for a bit

3

Paul White 9

What a lovely image

billinkc

Happy to google some up if you need better images

swasheck

surprised you didnt have them on standby

Cade Roux

So what probably downgraded to just INCLUDE it was the usual filter clause in the report?:

(@facility = @facilityAll OR @facility = ues.OEMFacilityID)

Paul White 9

Did someone just wind the clock back 3 years?

@CadeRoux The OR would do it yes.

swasheck

16:36

we were just talking about this a few hours ago, right @PaulWhite9? nice to have community back.

Paul White 9

right

Cade Roux

@PaulWhite9 Good, that's what I was thinking.

swasheck

i took that out because i'm not sure he'd see it as the term of endearment that i intended it to be

Paul White 9

I suppose I should downvote Evan's question for comedy value

Philᵀᴹ

@PaulWhite9 better the devil you know

swasheck

16:38

some men just want to watch the world burn

Paul White 9

@swasheck I can never remember if he prefers communist or socialist

Peter Vandivier

pretty sure anarchist

swasheck

social communist? communal socialist?

Paul White 9

Nov 12 '19 at 17:20, by Evan Carroll

In the world I will build, we will all live in a post-binary communist utopia. I will establish PostgreSQL as the supreme database of the land, and banish SQL Server to the dustbin of history.

swasheck

competition is what has made posgres so good in the first place.

Peter Vandivier

16:41

that sounds like capitalist talk over thar

swasheck

nah

Paul White 9

Apr 29 '14 at 13:08, by Kermit

this is a communist chat room

While we're winding back the clock

swasheck

oh wow. what happened to that one?

"they" were interesting

(am i doing this correctly?)

Paul White 9

Passed away from Vertica poisoning I think

swasheck

HP skidmarks

Paul White 9

16:43

He'll always be the Fresh Prince to me

5

swasheck

is that their documented pronoun?

Paul White 9

Not sure we had those way back when

Philᵀᴹ

@swasheck I think it was frog/frog

swasheck

Madonna - This Used To Be My Playground (Official Music Video)

►

Andriy M

17:24

@PaulWhite9 We've grown accustomed to his face?

swasheck

paul needs to use the homophone "excepted" and not "accepted"

Andriy M

@McNets I noticed that one as well. A store full of stories maybe

McNets

@AndriyM a wonderstruck store

jcolebrand

@ypercubeᵀᴹ Now you're thinking like a VC

billinkc

usa.streetsblog.org/2019/05/29/…

NZ protected bike lanes probably have kangaroos tied to poles and they just kick diverging cars out of the way

swasheck

17:38

sheep

jcolebrand

@billinkc Why would NZ have kanga?

billinkc

@jcolebrand National mascot, innit?

jcolebrand

I was under the impression that was Australia

billinkc

Inferior edumacational system there in Texas

jcolebrand

It looks like there are some wallaby transplants in NZ but nothing "native"

billinkc

17:48

JEAGL

Aug 13 '15 at 14:30, by Paul White

Bill will ask where the kangaroo design is, of course.

swasheck

forgive cole. he's a bit rusty

billinkc

Trolling never rusts

Transcript for

The Heap™ – Consultancy ©®