The Heap™ – Consultancy ©® - 2018-03-16 (page 1 of 2)

12:57 AM

@Taryn C'mon Taryn, you can be honest with us. It's St. Patrick's Day. Y'all are off to the pub and you're shutting down the servers to guarantee no pager alerts.

Paul White

2:42 AM

@sp_BlitzErik Ok, I'll bite. What's the point of an AMI? Sort of halfway between Azure SQL DB and real SQL Server on a VM in Azure?

Or a bit more than halfway?

I could read about it I guess, but the posts are usually marketing nonsense.

Michael Green

3:14 AM

It's a step on the migration path from on-prem to fully cloudy. Pretty much a VM with SQL Server installed, and an MS employee doing the sysadmin for it.

Kinda "none of the restrictions, all of the benefits"

Or gateway drug, depending on your point of view.

Paul White

Cool thanks

Andriy M

6:37 AM

The OP has clarified here that by AAS Development they mean AAS Development edition. I can find no mention of Development Edition with regard to AAS in official sources but I've found this page about AAS pricing and it seems to me that the correct term would be AAS Developer pricing tier.

I've edited the question to that effect but I'm still unsure if that makes enough sense.

I mean, originally it said, "I'm trying to do this on AAS Development [edition]". Now I've replaced the "Development" with "Developer pricing tier" and it seems somewhat awkward. Does that wording makes sense?

hot2use

7:05 AM

morning

Anybody have the possibility to safely check the google links in this post:

0

Q: I can't open my Pharmacy management software"based on sybase database"

I am stuck with my pharmacy management software running on windows XP with a dongle as a security system. The database is Sybase. I tried many backup copies but failed to open the program. Two windows appear as shown in Picture 1 and Picture 2. I am trying to find an online opener for DB fil...

hot2use

7:17 AM

I'm not allowed access to drive.google.com links form "my current location".

Paul White

7:42 AM

Done

hot2use

@PaulWhite Thanks.

Paul White

The very best questions always include photos of a computer screen.

hot2use

Absolutely

It gives you the impression of being at the desk of the DBA trying to solve the issue

I think I'll write a meta question to persuade the use of semi-interactive screen shots

@Philᵀᴹ Starten Abwarten Panik (Start Wait Panic)

@Philᵀᴹ Sanduhr Anzeige Programm (sandglass display program)

McNets

Morning

hot2use

8:01 AM

Evans post has vanished

Andy K

morning and evening

Paul White

You don't like single letter aliases and you like this? pg_constraint AS "pg_constraint"? ... — ypercubeᵀᴹ 37 mins ago

Andriy M

@hot2use In less than 4 minutes after being posted

Paul White

Where was that? meta.SO?

Andriy M

Yes

Can't imagine why it was deleted. There was no "in your face" kind of attitude about that suggestion.</sarcasm>

Tom V

8:21 AM

Pharma software on a windows XP box

and he posts his database publicly online

I'm tempted to check if there isn't any PII from his patients or anything in it

hot2use

@AndriyM Is the user Юлий Щербак possibly a fellow Ukrainian?

He is seeking help on an issue and I am having a hard time understanding what he wants:

dba.stackexchange.com/review/first-posts/108248

@TomV Never thought of that. Should we remove the link?

Andriy M

@hot2use Written in Russian, though the surname is of Ukrainian origin. He could also be a Belarusian. I'm reading the post to see what it's about.

Tom V

At least there aren't any viruses in it

hot2use

@AndriyM Thanks. Sometimes speaking the same language as the person asking the question gives you an idea of what the intention was.

Andriy M

8:38 AM

I think he wants a query.

One sentence is rather confusing but it also seems unnecessary, as it adds nothing however I'm spinning it.

dezso

@PaulWhite rant removed

Paul White

@dezso acknowledged

dezso

@PaulWhite don't you think that question should be eradicated? I have no desire to open those DB files, but some might have

Paul White

@TomV Only important databases get absolute beginner DBAs it seems.

How often is it medical as well.

Or finance.

Or air traffic control.

@dezso That angle hadn't occurred to me before.

Andy K

8:57 AM

morning and evening

hot2use

@AndriyM Did you VtC as unclear?

34 mins ago, by hot2use

@TomV Never thought of that. Should we remove the link?

Andriy M

@hot2use No. Maybe I should. I'm keeping an eye so far, will probably vote if he takes too long to respond

hot2use

I skipped the vote in favour of the question being updated by him soon. (Thanks)

Tom V

9:40 AM

Time to slack off

dezso

'Are you stealing those LCDs?' 'Yeah, but I'm doing it while my code compiles.'

(I know you know)

Paul White

@TomV As if AX weren't miserable enough, you get to wait for it to compile as well?

Tom V

@PaulWhite twice!

First to some proprietary binary stuff and then you have to compile it into CIL too

Paul White

you're a better man than I am

Tom V

To be fair, it runs without compiling after every change, but you need a full compile and full CIL compile before releasing to prod (and preferably UAT)

Paul White

9:55 AM

is there some way we can send you money or a consolation bunch of flowers or something?

Oh I suppose you already get paid to do it

Tom V

@PaulWhite Not enough

Andriy M

@TomV To be completely fair, you probably do need to get a break from it now and then too.

Tom V

How else would I find the time to troll the heap

Max Vernon

10:52 AM

I must be grumpy this morning.

You'll get more suitable answers by providing all requirements in your question from the start. Instead of generalizing, you should be very specific about your exact scenario, including indicating which DBMS you're using and the ORM requirements. If I would have known you were using an ORM, I never would have provided an answer at all. — Max Vernon 1 min ago

The guy's self-answer is $%%^66. If you were going to just go with three tables why not just skip asking the question in the first place.

ypercubeᵀᴹ

Don't be grumpy, you got 5 upvotes ;)

Unless your happiness threshold is at 6

Max Vernon

I see ORM and I lose it.

ypercubeᵀᴹ

@MaxVernon don't say anything more. One of my long-term tasks in my work is titled "kill the ORM" ;)

4

Tom V

one of our product teams decided to switch to EF for one of our products

My life is about to get even worse

Paul White

Doom and gloom in here this morning

Tom V

11:05 AM

TGIF

gbn

In other news, it's Friday and the sun is out here

Paul White

Mate it's Saturday :)

gbn

so why are you here then?

Paul White

Well it's only 8 minutes past Saturday

Also someone has to cheer you lot up

2

dezso

@PaulWhite by making everyone envious?

Paul White

11:15 AM

I didn't say anything about being good at it :)

Also, I do get to encounter Monday earlier, so it's not all kittens and rainbows

dezso

@PaulWhite sure, but not that many are celebrating Sunday afternoon in here

(well, that might be wrong, as I am not here at that time usually)

Paul White

That's because they need cheering up!

ypercubeᵀᴹ

3 people didn't mind the change in terms ;)

It would better if you hadn't changed names between the question (Parent -> Child -> Grandchild) and the answer (Grandparent -> Parent -> Child) — ypercubeᵀᴹ 4 mins ago

Paul White

ALTER dbo.Comments REBUILD WITH (DATA_COMPRESSION = PAGE);

3

ypercubeᵀᴹ

typo removed !

Paul White

11:23 AM

Does the ERD not answer those questions? If we read it literally?

Otherwise the question becomes something like how to model a generic graph/hierarchy/relationship, which is a teensy bit broad.

It may be psychological, but the more I read @ypercubeᵀᴹ, the more typing errors I make

Andriy M

DELETE FROM "The Heap" WHERE message IS NOT DISTINCT FROM trash;

Paul White

Fancy

Tom V

@PaulWhite Monkey see, monkey do

Paul White

Ook

ypercubeᵀᴹ

@PaulWhite It does answer some of them. Yet the OP replied "great" to both 2 other answers that did not comply with the ERD. Also one of the questions (which I repeated in the OP's answer) is answered by the ERD (and his answer complies) but from the question description I'd guess they want the opposite.

Paul White

11:29 AM

Sure. I was just wondering to what extent we should answer the actual question, or the one we might think is actually meant.

ypercubeᵀᴹ

@PaulWhite also the tiny marks in the ERD that define these details always confuse me ;)

Paul White

Count me in on that.

Not that it's shocking how few database people can actually read an ERD or anything :)

Andriy M

Even one with just three entities in it

Paul White

True!

Paul White

11:43 AM

Of course it would help if there weren't so many ERD notations.

Not to mention the idea of actually writing an ERD before starting physical implementation.

Or keeping the ERD up to date.

It's amazing anything works at all tbh

ypercubeᵀᴹ

It's the age of the ORMs. ERD is replaced by the orm "model". ;)

Paul White

json is replacing the lot I hear

ypercubeᵀᴹ

Fighting orms, fighting orks

ConcernedOfTunbridgeWells

11:59 AM

@PaulWhite Schemaless

Unstructured data

Infinite flexibility. You can interpret it however you want in the application.

Tom V

12:35 PM

I guess it's true what they say about oracle admins and their wads of cash

Ahmed S. Elsenbawy

1

oracle oracle-forms plsql sql

Asks basic questions, drives a maserati in his profile pic :D

Max Vernon

12:52 PM

damn, drive-by-questions annoy me. I guess I'm still grumpy.

If you're going to take the time to ask the question, at least you could check to see if anyone asks for clarification, and if they do, respond to it.

Tom V

@MaxVernon To be fair, asking that question shouldn't have taken much time

Max Vernon

lol. true.

Andriy M

1:21 PM

@TomV The picture's been removed. He must have eavesdropped on you somehow.

Max Vernon

I still see the pic, @AndriyM

interestingly, it's probably not a stock photo... tineye.com/search/8a622624273b94df24cd4eb061aeedc0afc79f5b/…

Tom V

@AndriyM is facebook blocked where you are?

It's linked from facebook

Andriy M

Odd. I can see the picture if I open it using its link from the onebox, but opening his profile shows empty space where the picture should go.

Same when viewing his question, no picture beside the nickname

Ah, no, it only behaves like that in the Private mode. The picture is there if I open it in a normal mode tab

Still somewhat strange but I will live :)

Paul White

2:03 PM

@MaxVernon Not grumpy enough to vote?

Max Vernon

apparently not. Actually, I was hoping they'd provide some details but, natch.

Paul White

Jul 14 '17 at 10:02, by Paul White

Please remember question votes are free (up and down) and are among the strongest quality signals you can send to the system.

Max Vernon

ok you convinced me

Paul White

Quality signals feed into automatic question/answer blocks

So if you don't want more low-quality questions...

VOTE!

Andriy M

It's official then: Paul White says it's OK to downvote when you are grumpy.

5

Paul White

2:07 PM

That's not entirely the message :)

Andriy M

"...when you are grumpy enough", sorry

Tom V

I'm not sure if this should have been a new question or an edit to the original

dba.stackexchange.com/review/close/108254

Paul White

I feel I am fighting a losing battle, but I don't care!

Tom V

but @PaulWhite asked him to ask a new question in the comments to his NAA

Paul White

@TomV Is that the right review link above?

Tom V

2:16 PM

ah no

0

Q: SSAS Design question or may be MDX

My question is related to this one Currently for generating a report through SQL, we are using following query SELECT PersonID,SUM(Value1) , SUM(Value2) FROM (SELECT PersonID, CustomerId,Value1,Value2 ,ROW_NUMBER() OVER (PARTITION BY SurrID, PersonID, PartID ORDER BY NID asc) AS Seq FROM Tab...

database-design ssas mdx

that's the question

But I have trouble following his reasoning with his original response

Was it a reply to me saying "we tried MDX (but something else) and it was too slow)" or to greg

it looks like the OP of the original question to me

Paul White

@TomV It can't be an edit because the authors are different

Tom V

2 different authors with the exact same t-SQL requirement?

Paul White

@TomV Sigh. Same person most likely, on checking the account details, but two separate registered accounts with different names and emall addresses, possibly work/home.

Tom V

@PaulWhite seems like a nice situation for a Saturday morning

Paul White

I can't be sure he still has access to the original registered account to edit the first question.

Max Vernon

2:23 PM

Does anything need to happen to this question? I'm torn between VtC as "Too Localized", and letting it stay. I don't know how it would ever get any conclusive answer though.

1

Q: How do I change a processor count on a stopped SQL Server instance?

I have restored an image of a production SQL Server 2008 R2 to a Virtual Machine to test out some changes. When I try to start SQL Server to recreate tempdb (in partition that was not restored), it throws the following error: Your SQL Server installation is either corrupt or has been tamper...

sql-server sql-server-2008-r2 errors virtualisation

Paul White

@TomV As one of the answerers, what would you prefer to happen? Sort out the situation with the OP on the new question, or close/delete it and ask them to edit the first one using the original account?

Andriy M

I asked if they are the author of the linked question. Maybe they will confirm. Does it make sense to give them time to reply to that or should I just delete my comment?

Paul White

@AndriyM It's a stuff up already, and not of our making, so let's give him time to reply.

Andriy M

OK

Paul White

It feels awkward, but really the only downside is the speed with which he will get his question answered.

Tom V

2:30 PM

@PaulWhite If only his feedback which he first posted as an answer and then as a new question was clear to me

We'll see if he responds

> Would you like to continue the discussion in chat?

3 hours ago, by Tom V

TGIF

Paul White

@TomV Heh

@MaxVernon An expert or someone with experience of a similar event might come along. One would think there would be a way around this. I added comment info to the question. We will see if the OP responds to your comment.

@TomV That would no doubt help.

sp_BlitzErik

@PaulWhite atlasobscura.com/articles/what-does-dagnabbit-mean

Max Vernon

@PaulWhite cool

Paul White

@MaxVernon All that tempdb stuff is a bit of a distraction, but I was loathe to make wholesale changes.

Max Vernon

agreed

Paul White

2:39 PM

@sp_BlitzErik Truly expert in the ways of dag

> But the way the word evolved is not really funny. It is dark and ominous and paved with fear. “Dagnabbit,” along with the English words “bear” and “wolf,” are creations of a terrified populace, scared of beings visible and not.

Philᵀᴹ

I’ve got it into my head that I want to write an ERP/CRM system from scratch. They’re all shit and very expensive.

Paul White

Don't ask me, I just wrote a cursor.

sp_BlitzErik

i hear it's a breeze with powershell

Max Vernon

@PaulWhite yah, but it was probably READ_ONLY LOCAL FORWARD_ONLY STATIC, so we forgive you.

@PaulWhite nice edit

Paul White

> There are all kinds of things that we as humans are too scared of to use its real name. God, sure, always smiting people, very scary. Bears, same thing, although “smiting” may not be correct word for a bear attack.

@MaxVernon LOCAL FORWARD_ONLY STATIC READ_ONLY

sp_BlitzErik

2:42 PM

in canada it only matters if there's penetration

3

Paul White

So yeah!

Some stars work best without context

Max Vernon

for sure

Tom V

/r/nocontext

sp_BlitzErik

#nevercontext

@PaulWhite happy saturday

Paul White

Now that I'm aware of it, I shall forever read dagnabbit as goddammit.

@sp_BlitzErik thanks!

Saturday is 15.625% complete.

sp_BlitzErik

2:46 PM

so we're 8% of the way to another tracking update

Paul White

I think the next update will be in my physical letterbox, probably Monday.

Max Vernon

@PaulWhite I'm thinking of adding a non-cursor based answer. Seems like a fun challenge.

Andriy M

READ_ONLY + FORWARD_ONLY = FAST_FORWARD, the manual tells me.

Paul White

@MaxVernon I tried for half an hour or so but dynamic SQL got the better of me at 16 consecutive quotation marks.

Max Vernon

lol

Paul White

2:49 PM

@AndriyM The manual is wrong. Or maybe misleading.

Max Vernon

> "with performance optimizations enabled"

^^^ that's a gotcha

A_V

Hello there

Andriy M

It's actually putting it the other way around: "FAST_FORWARD – Specifies a FORWARD_ONLY, READ_ONLY cursor with performance optimizations enabled."

Paul White

I always loved the very idea of "performance optimizations" for a T-SQL cursor.

@A_V Hey

@MaxVernon Also it's tricky to check for an online, but not yet fully recovered database in a set-based manner.

Max Vernon

@PaulWhite ahhh, thanks for that pointer. I would have neglected that.

sp_BlitzErik

2:54 PM

jtds.sourceforge.net/faq.html

> sp_prepare and sp_cursorprepare are used in conjunction with sp_execute and sp_cursorexecute (faster, SQL Server only)

Paul White

I'm sure it's possible, I'm just not good at writing deeply nested dynamic SQL.

All that red text and quote marks, ug.

A_V

One of my co-workers insists on using ORMs for everything, states raw queries/views/SP are un-maintainable and difficult to version

I don't know why developpers like ORMs so much..

Paul White

@sp_BlitzErik Rocket cursors!

Andriy M

@A_V Because raw queries/views/SP are un-maintainable and difficult to version, perhaps? :)

2

Paul White

@A_V I guess it's easier and more familiar.

Max Vernon

2:56 PM

@PaulWhite it's fun in the same way self-flagellation is fun

Paul White

Not clicking. Too close to bedtime :)

Max Vernon

@A_V devs love hundreds of layers of indirection if it makes it faster to code.

@PaulWhite chicken!

A_V

Is it a normal thing, after a while of working with databases, to become obsessed with performance and exec plans

Paul White

I think they prefer to write code in the language they know, rather than venture into database land.

Like database people don't like to write .NET code.

Even when it's the optimal solution.

Max Vernon

@PaulWhite when all you have is a hammer, everything is a nail.

Andriy M

2:58 PM

@PaulWhite Definitely less funny than rickrolling.

Paul White

@MaxVernon They would say the same thing in reverse actually.

@AndriyM Thank you for checking.

A_V

maybe they make a database vaccine for devs

Paul White

@MaxVernon Before things like ORMs came along (and I do not love ORMs!) pretty much every installation had a huge, brittle, and hard to change Data Access Layer written in code on the dev side.

sp_BlitzErik

@PaulWhite don't/can't/don't even know it would be optmial

Paul White

@sp_BlitzErik Yes

Max Vernon

3:01 PM

@PaulWhite yah, I know. I wrote a bunch of them. Then I self flagellated. Now I've repented.

Paul White

I had this radical idea to aim for a healthy working relationship between code devs and database devs where each played to their strengths, and spent as little time as possible doing unproductive stuff they hated and weren't very good at.

Max Vernon

I'm a developer when there are no DBAs in the room. When there are no devs in the room, I'm all like "damn devs".

@PaulWhite utopia, I say!

sp_BlitzErik

> it was all a dream

A_V

ahahaha make that a shirt, I'll buy it

Paul White

So I would sit down with the code dev and agree interfaces that we could both work to, to get the job done quickly and robustly.

It worked quite well, and AFAIK that code is still in production today.

But it is easier to play "us and them" I guess and assume others are stupid or ignorant.

</mini-rant>

ConcernedOfTunbridgeWells

3:04 PM

@PaulWhite Funny enough I found myself doing that quite recently.

Paul White

To be fair, there are stupid and ignorant people on both sides :)

ConcernedOfTunbridgeWells

And the devs liked the database design.

Paul White

@ConcernedOfTunbridgeWells It really is easier to try to get along in the long run.

ConcernedOfTunbridgeWells

Bugger me.

sp_BlitzErik

as a consultant <ahem> political issues at companies are much harder to deal with than technical problems (or deficiencies), but political issues make technical compromises more difficult, and technical deficiencies heighten political issues.

i gotta go lay down after that one

Paul White

3:05 PM

@ConcernedOfTunbridgeWells Yes I found that too. They were more interested when talked to as an equal.

ConcernedOfTunbridgeWells

@sp_BlitzErik Most issues in I.T. are fundamentally political in nature. There are very few purely technical problems left in I.T.

Paul White

@sp_BlitzErik That may be the wiser thing you've ever said.

Better?

@ConcernedOfTunbridgeWells Does "political" encompass "inter-personal"?

sp_BlitzErik

well i like the banter

this is too cuddly

Paul White

You'll find it in the Trash :)

ConcernedOfTunbridgeWells

@PaulWhite Certainly. Most of the politics in my current workplace originate from one person.

And I've never seen such a concentration of experts in data warehouse architecture in one place.

Paul White

3:14 PM

I'll never really understand why people think life isn't difficult and painful enough without actively looking to not get on with others in the same miserable situation.

dezso

@PaulWhite in which case they actually are

Paul White

So educate them. Or do something to reduce the pain and misery by some small fraction.

ConcernedOfTunbridgeWells

One or more of several major reasons:
* Desire for power
* Desire not to be held responsible
* Desire to get out of having to do work
* Lack of confidence in their own abilities
* Desire to make themselves look better

Paul White

Failing that, start a sandwich shop.

@ConcernedOfTunbridgeWells Right, but ultimately all those are negative and make life worse for all concerned.

Bonus points for a bullet list though, that looks nice

ConcernedOfTunbridgeWells

@PaulWhite It's never about looking at the big picture, just what gets them off the hook in the here and now.

Paul White

3:18 PM

Quite sad really

A_V

That bullet list makes so much sense though, never really looked at it that way

I guess I take workplace politics too personal

Paul White

That does not make you unusual at all :)

Tom V

1

A: Help to understand data abstraction levels

Although the definitions of the schemas or levels of representation of the ANSI/SPARC architecture did not reach the desired precision, they are only three, and they are named external, conceptual and internal, respectively. As far as I know, there is no fourth level, because the physical struct...

Paul White

It's funny, and ironic, that the things most people expect would make them happy, don't. Often the reverse.

Max Vernon

@PaulWhite humans are a crazy bunch.

sp_BlitzErik

3:25 PM

yeah yeah alright plato white take it to philosophy.se

Paul White

@sp_BlitzErik I can kick you further than that boyo.

@TomV A typically low-quality answer.

sp_BlitzErik

i thought we were balancing?

Paul White

@sp_BlitzErik That's the funny thing about balance.

I might suddenly be really nice to Joe.

sp_BlitzErik

no one (with an accent) has ever called me boyo before

Paul White

15 mins ago, by sp_BlitzErik

this is too cuddly

Max Vernon

3:28 PM

@PaulWhite even his footnotes are interesting

Paul White

ikr

And here we were discussing how we couldn't even read a three-entity ERD :(

Max Vernon

I feel so dumb now.

sp_BlitzErik

i created a table once

Paul White

Yep

sp_BlitzErik

didn't like it

Paul White

3:30 PM

I think you can fix that with views and CTEs

Except in Postgres

ConcernedOfTunbridgeWells

Shots fired!

Max Vernon

@PaulWhite yes, but how on earth do you right-join them

Taryn

Did someone say shots?

Max Vernon

TEQUILA!

Paul White

There's only one right type of join. Clue's in the name.

Max Vernon

3:32 PM

The number of times I've actually needed to write a right join is not very many.

actually, not true. All my joins from now on will be right joins.

I mean, why not?

could make for a great job security plan.

Paul White

@ConcernedOfTunbridgeWells context from yesterday: dba.stackexchange.com/a/194965

Max Vernon

'cuz no-one else will be able to understand that mess

Paul White

@MaxVernon How humbling is it to discover all previous joins were just not right?!

Max Vernon

@PaulWhite I know, right!

Taryn

@MaxVernon I don't think I've ever written one

Paul White

3:34 PM

Well that seals it

Max Vernon

Aye, you 'aven't lived until you've written a right join and enjoyed it.

sp_BlitzErik

Department S - Going Left Right

►

Lamak

@Taryn I've never used one either

Paul White

Erik's on fire today

Taryn

@MaxVernon that'll be tomorrow

Max Vernon

3:35 PM

@Taryn at 9:35 am

Paul White

Amateur join artists in here. Where's the professionals' room?

Taryn

@MaxVernon if I'm lucky

Max Vernon

I feel you're going to be lucky

@Philᵀᴹ - ROT13

Taryn

@MaxVernon sure hope so

Paul White

Kylie Minogue - I Should Be So Lucky - Official Video

►

balance

Lamak

3:38 PM

@Taryn I hope so too

....what happens tomorrow?

Paul White

Isn't it the upgrade to 2017?

Taryn

102

Q: Planned maintenance scheduled for March 17, 2018 at 13:00 UTC (9AM US/Eastern)

tl;dr; Planned service interruption that will impact all Stack Overflow/Stack Exchange sites. All sites will be read-only for up to an hour on March 17, 2018. Short Version: There will be a service degradation for up to an hour at 13:00 UTC (9AM US/Eastern) on March 17th, 2018. During that tim...

discussion featured announcements

starting with some secondaries today

Max Vernon

~~St. Patty's~~ St. Paddy's Day

Paul White

Doesn't read the transcript, doesn't read featured meta posts

Lamak

@Taryn I see....good luck then

@PaulWhite you could have just said "doesn't read"

Taryn

3:39 PM

@PaulWhite It's Lamak what do you expect?

Paul White

dot matrix print outs

Lamak

@Taryn he's expecting me?

Paul White

no one expects the Chilean Inquisition!

2

Lamak

nice

Max Vernon

No one expects the Spanish Inquisition

►

Paul White

3:43 PM

Great so you'll star the Monty Python references, but not the deep philosophical insights

Max Vernon

Monty Python is deep philosophy.

Paul White

renames room

Max Vernon

It seems there hasn't been all that much jeagling going on lately.

Lamak

that's unacceptable

Max Vernon

I thought you were going to ask me to explain that.

Lamak

3:47 PM

but it wasn't a joke

Paul White

@MaxVernon Renaming the room, "Monty Python is deep philosophy" would tell visitors everything they need to know about the people, topics, and level of humour they could expect to encounter in here.

Max Vernon

@PaulWhite ahhhh... it's all about balance. JEAGLing complete.

I want to work for the Ministry of Silly Walks.

2

Lamak

don't you do that already?

Max Vernon

Or is it that I do work for the Ministry of Silly Walks. Sometimes, I just don't know.

@Lamak :-D

Paul White

night all

Zane

4:21 PM

@PaulWhitehave a good one

ConcernedOfTunbridgeWells

Seen on the interwebs today ...

Zane

That's a pretty good bit.

Max Vernon

@ConcernedOfTunbridgeWells so we just have to hack into one piece of kit and convince it to jump.

ConcernedOfTunbridgeWells

33 mins ago, by Paul White

night all

First evidence of Paul White sleeping seen in the wild. You saw it here first folks.

2

Paul White

Might not be fully reliable

ConcernedOfTunbridgeWells

4:26 PM

Trying to fool us I see . . . Very cunning!

Paul White

No I had a last minute interesting email.

Really going this time!

ConcernedOfTunbridgeWells

I'll believe that when I see it.

Max Vernon

5:54 PM

I'm thinking of rolling back to this, and throwing away all the work I did on the answer as it stands.

forget it. The OP should just choose his self-answer as correct.

Tom V

@MaxVernon yeah shit like that sucks

Max Vernon

@TomV I wish people would stop using hypothetical examples, and just use their own real-world junk in the question.

that would avoid all sorts of confusion, I think.

Tom V

The mdx question too. Just delete both and ban the user for wasting our time

Max Vernon

yep

I'm not deleting my code since I think it might help someone else who is looking for an answer to a suitable grandparent, parent, child relationship question.

→ 1 message moved to Trash

Tom V

6:11 PM

I just hate it when you think you understand a question, put time in answering and then have comments and edits invalidating the answer

It doesn't happen often any more but it has the effect on me that I just leave questions behind where I might have had useful input. Then you get someone guessing right posting a crap answer

And being accepted

We should run in the next election and introduce wasting other people's time as a ban reason

2

ypercubeᵀᴹ

6:28 PM

SELECT * FROM dual;

Soon, in your Postgres databases ;)

@MaxVernon the answer is fine.

Max Vernon

thanks, @ypercubeᵀᴹ

I'm surprised I was able to fake my way through a PostgreSQL RETURNING clause.

ypercubeᵀᴹ