The Heap™ – Consultancy ©®

jadarnel27

12:13 AM

Have you tried not asking poorly received questions?

Evan Carroll

They weren't poorly received...

George.Palacios

8:08 AM

Morning

McNets

8:33 AM

Morning

Peter Vandivier

8:56 AM

Morning

hot2use

Morning

@McNets Do you still think it's a duplicate?

0

Q: SQL SELECT Parent-Child with SORT

I have a simple, one level parent child relation table, with following columns: ID_Asset| Parent_ID_Asset | ProductTitle I need output grouped by Parent followed by children, and also sorted by Parent and Children Name. My attempts in the fiddle. The parent must be first. See here for details...

McNets

@hot2use No, I retracted my vote to close

Andriy M

Morning

Philᵀᴹ

@EvanCarroll Banned where?

McNets

9:33 AM

Hi McNets, thank you for your time. I have already tested using COALESCE, the problem is the ProductTitle column needs to be sorted alphabetically as well, the ADONIS group needs to be on top. — Petr Šimůnek 4 mins ago

@hot2use not clear enough ^^^^

ConcernedOfTunbridgeWells

9:44 AM

Morning all

Andriy M

@McNets The link in your answer is the same as in the question. Rextester doesn't generate a new link automatically, so you may have tested your solution but ended up copying the same link and thus your answer is referencing the OP's fiddle. That could be what confused the OP, although I'm not entirely sure.

ypercubeᵀᴹ

@McNets I think they want this: rextester.com/edit/PPCHG20007

McNets

10:05 AM

@AndriyM Sorry, I haven't used rextester for a long time

@ypercubeᵀᴹ will you post an answer?

Andriy M

@ypercubeᵀᴹ It doesn't show the right sorting order for the fragment the OP specified in their question.

I think McNets's solution should work. Only there's no need to do COALESCE(Parent_ID_Asset, '') in the ORDER BY, simply Parent_ID_Asset can do just as well. Also the CASE can be replaced with the equivalent COALESCE expression for conciseness

SELECT
    ID_Asset,
    Parent_ID_Asset,
    ProductTitle
FROM
    Test
ORDER BY
    COALESCE(Parent_ID_Asset, ID_Asset),
    Parent_ID_Asset,
    ProductTitle;

I'm not posting it because it's the same solution, just two expressions slightly modified without changing the result.

McNets

dbfiddle.uk/…

But I think OP expects to be ordered by Parent's title

Andriy M

10:22 AM

They shouldn't have limited their example output to just "the relevant part". The actual relevant part is apparently the entire output.

MAX(CASE WHEN Parent_ID_Asset IS NULL THEN ProductTitle END) OVER (PARTITION BY COALESCE(Parent_ID_Asset, ID_Asset)) as the first sorting term, keeping all the others too.

McNets

@AndriyM dbfiddle.uk/…

Andriy M

10:42 AM

@McNets dbfiddle.uk/…

or this, to avoid the warning: dbfiddle.uk/…

McNets

@AndriyM which better?

hot2use

@McNets Yeah. Looks like it might take a lot of grooming until it works. Question is: Is it worth it?

McNets

@hot2use that's true

Andriy M

@McNets You are doing an extra table scan to get the parent titles. My understanding is that using window aggregation you can avoid that.

McNets

@AndriyM Ok, would you mind if I post your solution?

Andriy M

10:51 AM

@McNets If I felt a little bit more authoritative, I would actually insist that you do :)

McNets

@AndriyM ;-)

hot2use

1:04 PM

@MaxVernon still happy with pi-hole?

Andriy M

Thank you Paul, that was really nice.

Max Vernon

1:52 PM

@hot2use let's just say I'm glad I know how to turn wi-fi off on my phone. But, overall, it works really well, and is super easy to setup. We've noticed some issues with certain sites not working as expected, presumably due to some scripts being DNS blackholed by Pi-Hole - it can be a little difficult to determine which urls need to be whitelisted to fix those issues. Overall, it feels like being behind a somewhat restrictive proxy.

Paul White

@AndriyM no worries 🙂

McNets

3:50 PM

kill it ^^^^

George.Palacios

Oh Gav.

Zane

4:03 PM

Gonna have to start using some Oracle. Excited to expand my knowledge into that pool

Evan Carroll

4:29 PM

@Philᵀᴹ SuperUser.

Philᵀᴹ

"This account is temporarily suspended because of low-quality contributions. The suspension period ends in 6 days.". Oh dear

-5

Q: How can I render a Clippy with text using Radare?

From the Radare.Org Facebook page Clippy is now available in r2! But the link to radare.tv is broke. I was talking to someone else at the Walmart checkout aisle and they were telling me about this too. How can I use Clippy in Radare?

radare

Max Vernon

"Walmart checkout aisle" - nice.

George.Palacios

HAhahahaha the walmart checkout isle

that's just the best post

@EvanCarroll Is posting the code once not good enough for you Evan?

Sometimes when I'm feeling naughty I like to post the code 3 times

Evan Carroll

5:00 PM

That guy just likes to attack me.

do you see something different between both executions?

Clearly there is!

perhaps there was something else I was demonstrating... hrm...?

you can edit that, I unfortuantely can't yet, because I'm banned.

But to answer the question, Radare's Clippy has emotions, and you can't control them. So if you get the wrong emotion, you just gottra reroll and do it again

And, yes, I use this. My MOTD is set with Radare.

Also, is "In addition, you should provide a link to back up your answer." even fair. I provided actual code, what is my link supposed to be to?

I don't know how the SU mods make it. SU and AU has the biggest jerks on the network moderating those sites.

I need an to create a site www.letmediffthatforyou.com =) like lmgtfy

Paul White

17

Q: Time for some more swag!

On occasion of our anniversary celebrations, we offered some cheese boards a while back. If you were late for that, though, no sweat! You’re just in time for another limited edition super special swag contest! This is the bit where you go “It’s about time, isn’t it?” To which I’ll reply with “we...

discussion featured fun 10th-anniversary

Evan Carroll

@PaulWhite meta.stackexchange.com/a/318642/157251

Paul White

@EvanCarroll ha!

amazing that didn't get widespread support

Evan Carroll

I know. Haters gunna hate.

Evan Carroll

5:35 PM

@PaulWhite meta.stackexchange.com/a/318927/157251

hot2use

Hi Evan. I just wanted to wish you a Happy Christmas before you are left. :-)

Evan Carroll

hahahah merry happy Christmas to you too.

Zane

6:52 PM

yikes first problem here is this hosed availability group.

Forrest

sounds fun

Zane

Something has messed up the cluster service on one of the boxes and someone has just tried to shut down the AG and blow away the clustering in general. This is making the AG throw a major fit since it doesn't know where it stands due to the server never returning.

Tom V

23 hours ago, by Zane

I'm even going to get to solve an AG problem on day 1

Famous last words

3

jadarnel27

Classic availability groups.

JzInqXc9Dg

7:17 PM

@billinkc can you elaborate any on the "nightmare" that was caused by that server that was renamed?

I'm going to do the fix tonight and both I and my Euro colleague believe there should be little to no other systems effected. hoping that is actually true :)

billinkc

@JzInqXc9Dg Nothing specific. It was a decade and 7(?) employers ago. All I remember was there was how things worked on every other box in the organization and then there was that box. Which was, of course, production

JzInqXc9Dg

hahah

ok cool

good ole "that box"

Master Database

0

Q: Huge number of visits

In the first 24 hours after posting Identity column re-seed: when it is necessary? , garnered about 700 Visits. Was it real? Was it some form of hacking? (I'm not complaining; my Answer got a lot of upvotes at the same time.)

discussion moderation up-votes

jadarnel27

@JzInqXc9Dg I can't remember all the details about your situation, but I had a client that renamed their Windows Server that was hosting a SQL Server instance, and they had lots of problems with it until they followed the steps in this MS Docs article.

Max Vernon

in DROP QUESTION queue;, 3 hours ago, by Max Vernon

anyone have an opinion on this - decent number of views, and probably an answer could be added to show how to use DBCC PAGE with the page number, but what help is that likely to be for a future visitor? I mean, other than sending them down the path of looking at something they ostensibly have no idea about.

jadarnel27

7:30 PM

In particular, running the sp_dropserver / sp_addserver commands and then restarting the instance.

JzInqXc9Dg

^ yes that is precisely what I'm going to do

Zane

@TomV bwahahaha. I got it. Just hadn't worked with AG's before. Both sides needed to know it was over in order for the DB's to move on.

@billinkc what's up homie!

jadarnel27

@JzInqXc9Dg Okay, awesome. The only issues they had during that process were with remote logins / replication - and the solutions were covered in that same article.

billinkc

@Zane Nada. Congrats on the new gig, I hope it's more enjoyable than the last

jadarnel27

To be more specific about "lots of problems," they had linked servers and were using "four part names" to refer to objects in different instances / databases. And resolution was failing because of the mismatch.

JzInqXc9Dg

7:37 PM

got it, that makes sense

that is generally what i'm expecting..

Max Vernon

@jadarnel27 DNS CNAME entries might help alleviate that pain.

JzInqXc9Dg

im just not physically there to remedy anything and ill be doing it at about 4am their time - but they have been tipped off and will be ready to firefight if need be! :)

Zane

@billinkc well I'm able to use the internet effectively enough that I can come here again.

billinkc

I'll talk to your supervisor, see if we can't clear up that glitch

Zane

Ha! lol from what I've noticed the culture here isn't as evil as the one at well.s

However it is only my second day.

jadarnel27

7:50 PM

@MaxVernon Heh, that's what they did for the first server rename a year or so prior! When they needed to do another rename (god knows why), they didn't want to support multiple CNAME entries all going to the new (third) name.

Andriy M

23 hours ago, by Zane
> However it is only my second day.

Zane

lol

Andriy M

inb4 :)

Tom V

@JzInqXc9Dg I'm physically close enough but 4 am our time... Nah thanks

jadarnel27

Slacker.

Tom V

7:58 PM

Sounds like it's Brussels which is an hour extra commute

I could recommend people though not in a public chat

jadarnel27

@Zane in case you haven't seen this, since you're supporting AGs now, this is a pretty neat sounding new tool offered by Microsoft support: Failover Detection Utility – Availability Group Failover Analysis Made Easy

JzInqXc9Dg

@TomV all good Tom. they are able to handle anything that happens on site

and yes, near brussels

Max Vernon

8:13 PM

any chance of a re-open ?

there is an answer

Andriy M

On a different note:

Not only is this link-only, it's also irrelevant, because the question is about SQL Server, not MySQL. Are you here to just promote your site? — Andriy M 1 min ago

The user is sort of active on SO but their latest SO answer is very similar

-1

A: sql server trigger

You can check triggers in mysql

Tom V

8:33 PM

@MaxVernon the op comment doesn't encourage me

JzInqXc9Dg

" any connections that used the old computer name must connect by using the new name." -> well, as far as I can tell the original renaming of the server must have been done before anything else was connected. everything seems to already be using the "new name"

that seems really weird compared to all the documentation I've read - but maybe also indicates this should be a smooth operation???

maybe all the docs are assuming you are renaming a server in which connections have already been made to what will become the old name

Andriy M

8:47 PM

@MaxVernon Re-opened

It's curious how it took only four votes to delete the SO answer I linked above. Even curiouser is that only one of them (mine) was a Delete vote, the other three were Recommend Deletion.

Something to do with the answer score at the time of voting, perhaps

Max Vernon

9:08 PM

@TomV yah, I flagged that comment. It's not very friendly. ;-)

@AndriyM cheers

McNets

It seems the test has started

McNets

10:06 PM

0

Q: What are the origins of the Identity Column?

Who were the first creators of the Identity column? What problem were those creators originally trying to solve? Is there a story behind it?

database-design identity

And another one, all new contributors

@PaulWhite are you there?

billinkc

Are you there Paul? It's me, McNets

3

Are You There God? It's Me, Margaret.

Are You There God? It's Me, Margaret is a 1970 book by Judy Blume, typically categorized as a young adult novel, about a sixth-grade girl who has grown up without a religious affiliation, due to her parents' interfaith marriage. The novel explores her quest for a single religion. Margaret also confronts typical issues faced by early adolescent girls going through puberty, such as buying her first bra, having her first period, and feeling attracted to certain boys. The novel has been frequently challenged since the 1980s due to its frank discussions of sexual and religious topics. == Background... ==

Transcript for

The Heap™ – Consultancy ©®