The Heap™ – Consultancy ©®

7:11 AM

Fantastic answer that.

Good morning

McNets

7:51 AM

Good morning

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

8:27 AM

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 que...

Andy K

8:38 AM

morning and evening

ConcernedOfTunbridgeWells

8:48 AM

Data science: Just because you can ...

@Mast Rollback plan is don't screw up. — Taryn ♦ 2 days ago

I hope that is a joke :)

9:19 AM

Are you sure pushing data into JSONB is a good idea? While the type has nice support from operators and functions, it sounds in reality you want at least a few fields normalized to their own columns. In the end, PostgreSQL is a relational DBMS. — dezso 8 secs ago

and we are going to have more and more of this

Elegant answer
https://stackoverflow.com/a/49231104/27535

Does it rely on some internals that may change though? I can't see a flaw in it so far

Borked it rextester.com/XWEG25562

Wrong links broke rextester.com/ENMZ33069 and fixed rextester.com/HNI47633

Q: Support for OpenID ends on July 1, 2018

9:59 AM

@JackDouglas Worth pinning for the community?

181

Stack Overflow was an early and strong supporter of OpenID. We built our sign up/log in flow around it. We were idealistic and had high hopes, but these hopes weren't realized. Over the years people have wondered if OpenID is dead. We've had to remove support as OpenID providers pulled support or...

feature-request featured user-accounts stackexchange-openid

Watching live query statistics while waiting for a query to finish has a surprisingly soothing effect

@hot2use It's in the Featured on Meta sidebar already

10:24 AM

@gbn a bit mysql-ish ;)

@dezso I just refuse to answer any questions that involves json/xml columns ;)

@PaulWhite True

:-)

extending home pages in browser

Your first query is only fast because you select only twelve rows. Remove the limit 12 from both, and see which one returns first. Functions in a where clause can kill any server. — Gerard H. Pille 11 mins ago

exactly, it's nothing to do with json

10:40 AM

@JackDouglas yeah, the problem is the ORDER BY some_function()

@ypercubeᵀᴹ or any ORDER BY which forces a look at the whole table

dbfiddle.uk/…

Yes. In the 1st query, they are just lucky that it uses an index - and get lucky to find 12 rows that match the conditions (which need 3 functions per row)

1 hour later…

12:08 PM

SQL Saturday next weekend, looking forward to see dbafromthecold present again

12:25 PM

@JackDouglas we'll see

2 hours later…

2:13 PM

@gbn I don't get it. The code is exactly the same in both, why are the results different?

@AndriyM rextester.com/VMYLU29172

It's not intuitive that tool

In other news, a wonderful 3rd party tool is processing 2.3 million rows with a TOP 1000.

Each iteration is 3-4 hours.

25k done so far in 4 days, only 2.275 million to go...

No, I understand that the CROSS APPLY method works reliably, my question is only why the UPDATE @var=... method works differently in those two rextester fiddles.

@gbn You're not going to wait until that's done are you?

@TomV To amuse myself and annoy the business, it's tempting. This is in a test system for now. I set maxdop to limit it in case anyone thought I'd started mining bitcoin

Waiting for the vendor

@AndriyM It relies on implicit ordering.

original, uses implied order: http://rextester.com/XWEG25562
with descending index, breaks it because implied order is "wrong": http://rextester.com/ENMZ33069
With ORDER BY to force order: http://rextester.com/VMYLU29172

@gbn It's always more fun if the vendor finds out close to the deadline

2:28 PM

But rextester.com/HNI47633 has exactly the same code as rextester.com/ENMZ33069 – and yet the result is different!

@AndriyM I see the same result

I consistently see different results. I'll try to show what I see

@gbn I get different results too

The sorting is different

oh and the sequence id's too

@AndriyM yes that's what I get

2:40 PM

Something to do with statistics perhaps.

I remember reading a blog post of Paul White's where I think he's talking about statistics of a dropped temporary table being preserved, even after the table is recreated (and possibly even after it's populated with new data).

For those 2 links I see the same code and resultsl even in incognito mode

Yes, the code is the same, but so far I'm getting different results between the two links each time I open them

Let's blame the tool

Just opened them in normal (not Incognito/Private) windows – still different results.

@gbn Works for me

@AndriyM I clicked run a few times and now I get the results from your second screenshot in both cases

Q: Brighter Yellow for CSS Style Element .question-status

3:25 PM

Tried opening both multiple times, no change, and I don't care.

Master Database

4:17 PM

I was recently reading a question that was put on hold due to ..... and realised that authors may not be aware that their question is actually in a non-open state. The information box is displayed in a light off-yellow-orange colour as can be seen below: Wouldn't it be better to have this inf...

discussion feature-request

1 hour later…

5:18 PM

@ypercubeᵀᴹ estimate: 1627352, actual: 12 — very lucky!

ha, hadn't noticed those numbers!

Joe Obbish

EAGL

:43357135 sorry that had to go...headache triggering

6:18 PM

@gbn Ugh I see the Quirky Update still refuses to die // @AndriyM

7:02 PM

@Taryn uBlock, right-click, block element — my threshold for gifs is low but that was a particularly nasty one!

Deletion was too good for it

@JackDouglas I couldn't look at it any longer

I think I can still see it if I close my eyes

I wonder if there's a feature request to add a rep penalty for flashing gifs

7:21 PM

oooo, what did I misss?

@hot2use This: thumbs.gfycat.com/AnguishedBruisedCurlew-size_restricted.gif

As a suggestion for the CSS Style Element

@PaulWhite :-P

Blame @dezso not me :)

@PaulWhite looks like my post achieved the desired effect, very good

Well you've a friend for life in @Taryn for sure

7:31 PM

at least I didn't kick

Very restrained :)

7:43 PM

@PaulWhite I'll have to look behind myself often to check if someone wants to hit me with a huge pivot table

I could post some more bright yellow if anybody wants some?

@hot2use at least a shimmering one, please, please!

this is terrible

Yellow but a flower instead.

I hope that suits @Taryn more?

Sorry @dezso, I'm not suicidal :-)

I fixed that for you

@Taryn would you have prefered blue?

7:55 PM

I'd prefer nothing moving

Got it.

8:23 PM

Mod elections at SO started 23 minutes ago. Already 1 candidate

stackoverflow.com/election

@ypercubeᵀᴹ is it Evan?

@hot2use dokimos.org/ajff (@Taryn you don't dare to click this - I've warned you)

@dezso my eyes! What have you done?

@dezso Looks like a 1986 web page

8:42 PM

@hot2use found in a collection of those (well, 90s)

but still alive

McNets

CROSS-POST: You have added same question on SO: stackoverflow.com/questions/49244057/… Please delete one of them. — McNets 34 secs ago

> deleted by user580950 just now