NoSQL - now with schema!

At first I was like, "How can someone like Aaron not remember that support for OVER (PARTITION BY) for aggregate functions was first introduced in 2005, then support for OVER (ORDER BY) was added in 2012?" I guess I must envy him the amount (and depth) of his knowledge that causes him to forget such things.

Not to mention the fact that in my day-to-day work I deal only with the (now sooooo old) 2008 R2 – that probably makes it easier for me to remember the time of introduction of certain features of T-SQL.

@mmarie Um. Faster?

@ConcernedOfTunbridgeWells (more) efficient?

@ErikE I guess you won with that

I often get the moniker Andreas instead of Andras (a practical simple form of the original András)

the last one was, after receiving an invitation that was aimed at someone else, 'ah, you are an other Andreas!' 'the trick is I am not an Andreas at all'

@dezso so that's how you knew about the pandy case

and this is only writing, pronunciation is a whole issue on its own

@TomV not the first time I get sensitive information this way ;)

seriously, it was a well known thing in Hungary at the time

@TomV "This edit deviates from the original intent of the post." It was rightfully rejected.

@dezso unfortunately I was too late to prevent this yesterday dba.stackexchange.com/review/suggested-edits/60083

@TomV check it now

@MichaelGreen I agree with your reject comment, adding that I know no Renaldo ;)

Ah I could have done that apparently

sure

we should warn @Colin'tHart, too

:)

I wonder why so many posters in SO and here comment with "design is poor but I can't change the design"

This case doesn't look poor design anyway.

But changing a column to not nullable doesn't sound like such a big change.

They are already adding Foreign Keys ...

@dezso I don't know... chattiness is discouraged, yet a high-profile user gets away with it? Not a good example.

@Colin'tHart it's a monument of historical significance

and, to be honest, removing those is not that useful. If it was a whole paragraph, then yes.

@dezso It's a fairly trivial edit, but I still think it improves the post

not that I'd like to see all of @RolandoMySQLDBA's posts edited on the same day mind.

but if a new user proposes an edit it's a shame to discourage them...

It's an interesting point. Personally, I wouldn't find "give it a try" at all problematic if it weren't for the formatting. Caps and large font turn it into a tagline, which is pretty explicitly discouraged.

For example, another user might write, "let me know what you think" at the end. It would have much the same meaning, but I doubt it would be edited out if formatted as regular text.

@PaulWhite yes, and recently (as far as I can see) Rolando also decreased the font size :)

An old, awful answer: