During the nomination phase, members of the community can comment on the nomination statements for each candidate. This can provide valuable information about how the community regards these candidates, as well as specific positive and negative points that go beyond the metrics displayed. There i...
It would also be interesting, IMHO, to highlight meta questions asked by candidates during this phase, as that, too, can provide valuable information to voters. :-) — Aaron Bertrand6 secs ago
But the lack of an answer to the questionnaire could definitely be considered a preview of what kind of effort he will give to the job. He probably figures he doesn't have to answer the questionnaire because his votes will carry him. I think the questionnaire should be mandatory.
As far as I'm concerned, instead of a nomination summary, the candidate's nomination should be strictly based on the responses to a questionnaire. — FreshPrinceOfSO26 secs ago
@AndriyM INTERSECT is the complement of EXCEPT, and there are cases where you might want to use the opposite one by flipping your EXISTS clause to NOT EXISTS (or vice versa).
I still think the nomination summary allows the asker to say anything about themselves, and why they are running, that the questionnaire may not cover and that voters may not ask directly.
Whether you, specifically, don't find any value in that? shrug
It turns out if you add columns to a table referenced in a view that uses SELECT * and run an sp_refreshview OUTSIDE a transaction the view definition does not get replicated to include the new columns
I told him my solution was not to use SELECT * in a frigging view
@AndriyM You're right: inside an EXISTS clause, the ALL versions are meaningless. I wasn't thinking. :) However, you can still use INTERSECT in its own clause with an EXCEPT outside it (for example). (A) EXCEPT (B INTERSECT C)
@ErikE I upvoted your suggestion, for completeness of the language if nothing else. There's no real reason to require users to write row-number queries when they need the ALL versions.
@PaulWhite @ErikE I tried to find it through the chat, through Google, and directly on Connect, but could not find it. It's possible I've already up-voted, but in case it's not, could you share the URL or Connect #?