The Heap™ – Consultancy ©®

7:31 AM

I'm voting to close this question as off-topic because it violates testing rules (see microsoft.com/en-us/learning/certification-exam-policies.aspx) — Julien Vavasseur 3 mins ago

should probably be deleted

Q: Should moderators enforce NDAs for software vendors?

7:59 AM

@TomV The general policy is that this is not for StackExchange to enforce.

A rash of questions was recently flagged because they were in violation of some "Non-Disclosure Agreement.". Is it the job of Stack Exchange moderators to enforce these agreements, and delete these posts? Return to FAQ index

But probably could go for "not clear what you are asking" as a close reason because the question isnt that clear and doesn't contain info such as heap of CI.

8:59 AM

Ah, nice. I guess this is a rare example where "table" seems proper in a table name! — ypercubeᵀᴹ 6 secs ago

9:29 AM

@MartinSmith Thanks

1 hour later…

10:39 AM

Anyone got Oracle 12 to test this on?
select nvl(foo, 0), foo
from( select 1 foo from dual )
group by rollup(foo);

@TomV done

@MartinSmith …and undone!

@JackDouglas what does it do?

@JackDouglas yes I saw it was deleted and undeleted in quick succession. Difficult one as even if SE decided to police this policy we don't actually know the provenance of that question in any event and whether it was actually obtained from an exam by someone. Maybe there should just be a blanket policy against all certification questions?

@MartinSmith I initially deleted it with the thought that it's not worth annoying MS or the test provider or whoever — but I don't want to get in the messy situation of mods being expected to judge every case like this!

I think the question would be OK if it described the exam question rather than cutting and pasting screen shots

I get:
1 1
1 (null)
on 11.2

which is wrong of course!

SQLFiddle seems to be down for Oracle otherwise I'd post a link

11:08 AM

@TomV @MartinSmith @JackDouglas That close reason makes no sense to me. Also, there are two upvotes on the question, and no downvotes. Confusing signals.

The question might still be deleted by 10k/20k users eventually, but that's probably even less likely than usual when the question and answers have nothing but upvotes.

I didn't vote for the custom close reason, I voted "unclear what you're asking" on the grounds that we would need to know if the table had a clustered index or not and this isn't clear in the question.

@MartinSmith apart from that there doesn't seem to be any valid reason to close. Still a case for delete I think but not close, which is pretty rare :)

@MartinSmith Your (correct) answer covers both possibilities. I personally don't think the lack of that fact makes the question close-worthy.

@JackDouglas What's the case for deleting? Given that the criteria for deleting a question is, "For questions, a post that no longer adds anything to the site should be deleted."

11:24 AM

@PaulWhite @MartinSmith me too. Exam questions (either form actual tests or examples) are often vague.

@ypercubeᵀᴹ Yes, and sometimes that will make them unanswerable, but that's obviously not the case here.

@PaulWhite just that while we don't want to police copyright and NDA stuff, we might not want to encourage antagonising others who might object to their material being pasted here

hardly conclusive though

@JackDouglas Bit of a dodgy precedent that :) Not touching it with a 10 foot pole. And it'd be a brave mod that goes against the meta.SE consensus and deletes a Q & A with 17 unopposed upvotes!

@PaulWhite ha, don't worry they trust us :)

Not to mention depriving Rafael of his Socratic gold badge.

11:32 AM

well we wouldn't want that

Ha ha ha indeed.

If the OP has been using unauthorised material

I guess there's a good chance they will request deletion anyway.

In which case I'm not bothered if my answer gets removed as collateral damage.

ConcernedOfTunbridgeWells

They might, that's true. Gets tricky because the answerers don't deserve the delete. Not everyone feels as you do on that point. There are things that can be done, but it's tedious.

4 hours later…

3:06 PM

Oranges and Lemons

"Oranges and Lemons" is a traditional English nursery rhyme and singing game which refers to the bells of several churches, all within or close to the City of London. It is listed in the Roud Folk Song Index as No 13190. == Lyrics == == As a game == The song is used in a children's singing game with the same name, in which the players file, in pairs, through an arch made by two of the players (made by having the players face each other, raise their arms over their head, and clasp their partners' hands). The challenge comes during the final lines: Here comes a candle to light you to bed...

Turns out I'm working just around the corner from St. Clement's.

ConcernedOfTunbridgeWells

> NOLAND, Mary Anne Alfriend. Faced with the prospect of voting for either Donald Trump or Hillary Clinton, Mary Anne Noland of Richmond chose, instead, to pass into the eternal love of God on Sunday, May 15, 2016, at the age of 68.

Elizabeth Goose strikes again.

ConcernedOfTunbridgeWells

3:20 PM

QOTD: Software and cathedrals are much the same — first we build them, then we pray. (Sam Redwine)

1 hour later…

4:49 PM

@ConcernedOfTunbridgeWells the similarities dont end there

what with worshippers and all

Zane

5:42 PM

Yikes this is an execution plan that I can neither understand nor approve of.

most of them are like that here

Zane

Methinks the constant use of Scalar functions is messing things up.

but ... code reuse

Zane

6:04 PM

lol

How else will developers find business days?!

Or show datetime but set the time to zero?!

6:24 PM

@swasheck Set based is hard when you're used to procedural

ORM will solve all of that, someday, maybe

6:40 PM

then gtfo of my database

Q: Get the Text of the currently running SQL?

something like that

Andriy M

7:03 PM

Is this

This is something I am just interested in knowing if it is possible. Could I write an SQL query that could return the text of it's self as a variable? Where I might use this would be on things like reports that I might want to return a variable that saves the actual query that ran to generate t...

sql-server sql dynamic-sql debugging

a duplicate of this

Q: Capture the Query Text of a DML Change

It may not be possible, but without doing a JOIN from the inserted/updated from the records coming in and adding them to an audit table column-by-column, is it possible to just capture the full DML query text, similar to using the below logic when a DML transaction is run against a table: IF ((@...

sql-server t-sql trigger dml

Or is it perhaps the other way round?

Of course, there's also this

Q: How to see text of the query which triggers the trigger inside trigger?

I have very small database with a bit complex triggers which works very slow. Those triggers are written to extend business logic (becase we can not manage the code of the application we are using). To find the problem I need to trace what happens during different SQL requests. I will log differe...

sql-server sql-server-2012 trigger

7:21 PM

@swasheck what a goal

@TomV goals are for those who have no internal motivation

@swasheck I meant UEFA final :)

Andriy M

@TomV The reply may still stand. Someone might not have had enough internal motivation – the goal was for them :)

Although it would probably be more correct to say, "to them"

@TomV i didnt see it. liverpudlians are presumably ecstatic. klopp's been great for them, no?

I get the feeling he is "one of them" instead of "the manager" when it comes to the players sometimes and it looks as if it delivers reasonable results

But first pot is worth watching the summary on the news is what I meant

7:28 PM

ah. fair enough.

@AndriyM that question has not enough votes ;)