The Heap™ – Consultancy ©®

12:58 AM

Funny stats from Euro 2016, 1st round:
no team won all 3 games
most cost-effective team: Poland 2 goals, 0 against, 7 points
the only that didn't score: Unkraine

If the country name starts from A or R (Austria, Albania, Russia, Romania), team is packing for home.

If the flag has blue and yellow (Sweden, Romania, Ukraine), team is packing, too.

Teams with green in their flag had no such issues. All (7) passed to the next round.

Paul White

3:10 AM

Starting to look like the UK is leaving the EU

Andriy M

5:07 AM

@ypercubeᵀᴹ Indeed it was. There are many things I've never heard about, of course, and this one was among the more curious ones.

@ypercubeᵀᴹ Correction for the last one: "the only one that didn't score anything (neither a goal, nor a point)". Quite an achievement, in a way.

Andriy M

5:39 AM

Have we gone multi-language?

1

Q: Get Users Ranking based on points from DataBase ( MYSQL)

bonsoir tt le monde , j'ai cree un site web ou les membres collectent des points pour gagne un cadeau a la fin du tournoi et je veut faire une page du TOP 10 membres dans laquelle cette derniere presente les 10 meilleur membre qui ont les plus haut Points . j'ai essayer plusieur code ms sans au...

0

A: Get Users Ranking based on points from DataBase ( MYSQL)

essaye ça SELECT id, username, points FROM users ORDER BY points DESC LIMIT 10 Pour obtenir tous les utilisateurs quand il y a égalité; Par exemple, si les dix premiers résultats sont: 2 * 150, 3 * 140, 7 * 130, 1 * 120, 2 * 100, 2 * 110, 4 * 90, 2 * 80, 1 * 70, 2 * 60 utilise ces ...

or just French

Tom V

5:55 AM

@PaulWhite Yes, leave it is

Paul White

7:25 AM

Crikey Cameron's stepping down!

Phil

7:36 AM

Well, that's the country broken

ypercubeᵀᴹ

@PaulWhite It's amazing how he managed to turn his last year's victory to a disaster (for his party and himself, not the country).

I hope you don't split the country in two. Whoever wants to stay in EU, move to Scotland, North Ireland or London. The others to the rest of England and Wales.
Like India divided when they got independence.

Andriy M

At least there's no reason to fear UK will want to join Russia following Brexit.

Paul White

7:56 AM

I have to say I think the UK has done the right thing.

Cameron too.

Phil

It'll be alright. Boris Johnson will be our supreme overlord. Boris and Trump ruling the world in harmony. HAHAHAHA. Politics is becoming The Onion more & more every day

Paul White

I am intrigued by the prospect of PM Boris though!

Ha ha yes Boris and Trump goodness me.

I followed the two campaigns reasonably closely (from a distance!) and it always seemed to me that the Remain campaign overstated the risks to the point of parody.

GBPUSD has recovered 600 points from the bottom, and 200 from when Cameron announced he would be stepping down.

Interesting times.

Mark Sinkinson

@PaulWhite Over-exaggeration on both sides unfortunately. And the only person not over-exaggerating was campaigning for Remain when he probably wanted to Leave...

Tom V

I think it will be a hard time short-term, especially since the Euro leaders will do their best to make it that way and scare the other countries thinking about leaving, but in the long run the UK will be better off

Paul White

@TomV I agree, though I suspect (and hope) the short-term will be less painful than expected by some.

In NZ, we've been trying to talk the currency down for years. We'd love a 10% drop overnight.

Phil

8:08 AM

petition.parliament.uk/petitions/131215

The site's struggling under load :/

Tom V

@PaulWhite With rates still at around 2%, talking isn't going to work

Too much positive carry

Paul White

@TomV Yes. Other countries need to get some inflation.

@Phil Struggling to load. What's the petition for?

Phil

@PaulWhite A 2nd referendum

Paul White

@Phil Oh ha ha ha yes keep going until the result is 'right'.

Phil

@PaulWhite Looks like it's an old one though

ypercubeᵀᴹ

8:11 AM

@PaulWhite I added one more answer in this old question: dba.stackexchange.com/questions/42837/…

If it's wrong, let me know and I'll remove it. Or if it needs major correction, it might be better incorporated in yours (and mine deleted)

dezso

@PaulWhite then just leave the EU

(OK, you shoud join first, but that 10% is importnant, isn't it?)

SQLPRODDBA

Chaos in stock market due to this. :)

dezso

@PaulWhite We the undersigned call upon HM Government to implement a rule that if the remain or leave vote is less than 60% based a turnout less than 75% there should be another referendum.

Paul White

@ypercubeᵀᴹ No it's fine, and a good replacement for the comment you left along the same lines.

@dezso I'll suggest that!

dezso

It will be interesting to see how things develop, but Britain will blow up if staying and working for EU citizens will be impossible (or significantly harder)

ypercubeᵀᴹ

8:18 AM

@PaulWhite Yeah. Weird thing is I noticed the comment after writing the answer!

Mark Sinkinson

@dezso We'll be having never-ending referendums on that basis!

Paul White

@dezso My guess is it'll work out. Non-EU countries manage to have a sensible immigration policy just fine.

@MarkSinkinson Yeah a referendum should be like Highlander.

deostroll

10

A: Execute shell command from within MySQL client?

You can use the system command. system command, \! command Executes the given command using your default command interpreter. The system command works only in Unix. Example: system ls -l

^ I've tried that on a windows command-line client...

doesn't work...does anyone know the alternative...?

dezso

I've found a user with exactly one badge, and it is Peer Pressure: dba.stackexchange.com/users/81939/luiscoba88

Paul White

@deostroll @ypercubeᵀᴹ might know, but otherwise, you could ask a question on the main site. Not many of the MySQL experts hang out in here often.

dezso

8:28 AM

OHd: UKIP: This one weird trick can help you lose Pounds overnight

2

Paul White

:) Hey what's the point of UKIP now?

ypercubeᵀᴹ

@deostroll No, unfortunately have no idea.

dezso

@deostroll depends on what you want to achieve

@PaulWhite to keep Farage afloat

Paul White

@dezso I've lost track of him, is he still their only MP?

ypercubeᵀᴹ

A bit aggressive this is:

@Shanky Then maybe you have to learn english? You say take a backup IN a date range - not FOR a date range. If you ask how you would backup data FOR A specific range of dates that would be a different question. If I make a backup on a (like today) that is in a range of dates (this week) then I have done that. — TomTom 53 mins ago

Paul White

8:38 AM

@ypercubeᵀᴹ Agreed. The answer doesn't seem very constructive to me either.

ypercubeᵀᴹ

and the question is not clear at all

dezso

@PaulWhite he possibly wants a new ban?

Paul White

The ice is certainly thin.

Andriy M

@deostroll And "doesn't work" never requires an elaboration ;)

Paul White

pivot

ypercubeᵀᴹ

8:49 AM

Pivot mentioned, @bluefeet, when you find some spare time, check this q: dba.stackexchange.com/questions/142101/…

and advise which of your answers is more appropriate as a target so this be closed.

Paul White

She must be dead :(

Marian

@PaulWhite why was that the right thing? I always thought we're stronger together in a union, but I'm probably biased.

ypercubeᵀᴹ

and Donald Trump is visiting uk today ;)

dezso

just sent a half troll message to my bank

Paul White

@Marian Well not being in the EU doesn't mean they can't be friends, cooperate and trade. For mine, the EU took it too far when they started talking about monetary and political union.

Free movement of people was probably the last straw.

The EU would have done well as a forum to cooperate on big issues like terrorism, climate change etc, not how straight a banana should be, or who can work where.

It costs them a lot, and the main return seems to be red tape and having local laws overridden.

Marian

8:58 AM

@PaulWhite they weren't in the Euro movement, so they kept their monetary independence.

But they benefited from the free money movement even outside the Euro zone.

Paul White

@Marian Yes I was talking generally about where the EU took things too far. Indeed the UK opted out on many things. So one could argue how far they were ever truly 'in'.

dezso

@PaulWhite Last seen 6 hours ago - so this is something really new

/me ducks

Marian

@PaulWhite yep, indeed not a really "all in" member

Paul White

I should hold my hand up at this stage and say I only know what I occasionally read in the papers, and what my (English) wife tells me.

Marian

@PaulWhite this one was really a false alarm for them, as they're not really one of the main immigration targets.. The numbers were appalling afaik.

Paul White

9:01 AM

@Marian I'm told the local perception is different.

Marian

@PaulWhite it may well be, I only saw as you the big picture from the papers.

Paul White

My sample size is also rather small, being the wife's family and facebook friends :)

James Lupolt

9:36 AM

Farage conceding defeat at 10 PM was a nice touch. Only reason I got much sleep last night.

ypercubeᵀᴹ

@JamesLupolt Did he? I only opened TV at 01:00

James Lupolt

@ypercubeᵀᴹ Yes, that's how it was reported anyhow.

Random Google News result: dailyrecord.co.uk/news/politics/…

GBPUSD is currently at mid-April levels when I think Remain was ahead in the polls. The currency moves aren't quite as extreme as some people are implying.

@PaulWhite I think what you'd see in the UK is Leave propaganda everywhere north of Greater London and the Home Counties, and relatively modest amounts of Remain propaganda around London.

Mark Sinkinson

@JamesLupolt Conceded, unconceded, conceded, then Newcastle and Sunderland results came in

Leave was 10/1 at 11pm

James Lupolt

9:52 AM

4

Paul White

@JamesLupolt That seems about right.

BBC still reporting that GBPUSD reached levels not seen since Margaret Thatcher was in power.

wBob

@JamesLupolt this is funny, the drop in the pound less so : )

Paul White

Despite the fact it has now recovered to levels not seen since ... er ... March.

wBob

someone's making some money somewhere lol

Paul White

@wBob And someone else losing it.

Also interesting that the DAX and CAC are down twice as much as the FTSE

wBob

10:03 AM

it won't be pension schemes [making money], it won't be your man-on-the-street

James Lupolt

@PaulWhite You're right. I misspoke. March, not April.

Paul White

@JamesLupolt Oh sorry I hadn't seen your message.

@ConcernedOfTunbridgeWells ^

dezso

@PaulWhite Tunbridge Wells is an island on an island

wBob

Divisive far-right organisations love him: how to shred two economically stable unions in one parliamentary prime minister-ship with this one weird trick.

Paul White

10:18 AM

Boris' speech was good I thought.

wBob

@PaulWhite which one? bbc are showing he was "...booed by an angry crowd as he left his north London home" this morning. Bearing in mind London was overwhelmingly Remain, maybe he should move to Sunderland : )

Paul White

@wBob BBC World, he and Michael Gove press conference at Vote Leave HQ

wBob

Four Horsemen of the Apocalypse: Boris Johnson, Farage, Gove and [insert Leave politician here]

One jests, slightly : )

Paul White

...Trump?

But that's way overstated for me. Time will tell I guess.

wBob

hehe could be - he probably won't get in though. (Or will he?) These self-serving clowns have done their deed.

Darth_Wardy

10:25 AM

@wBob Apocalypse ... bit strong don't you think?

Paul White

@wBob Well Leave was a surprise ... so

Darth_Wardy

this could be a good move for the whole of europe, not good for the EU, but good for europe at least

Paul White

I think it's good as well, but I've been wrong before. Depends a lot on how the EU chooses to react.

Darth_Wardy

they will react with pomp and circumstance as always

wBob

@Darth_Wardy Yes I'm exaggerating slightly for fun. Still, some market turmoil - genuine financial implications for ordinary people. Still, early days ...

Darth_Wardy

10:26 AM

then more member states will leave

interesting that the UK is basically now worth £128 billion less overnight

I wonder how long it'll take us to fix that little problem

wBob

@Darth_Wardy that is the other implication, far-right in France now calling for same.

Paul White

@wBob I think that's overstated as well. The markets got it wrong and are adjusting. Moves in stocks and sterling are large for a single day, but not significant over time.

wBob

@PaulWhite let's hope so!

Darth_Wardy

@wBob gut feeling here ... poland will be next

Paul White

Again, time will tell.

One hopes for the best.

wBob

10:28 AM

Now, back to the serious topic of SQL Server!

Paul White

Time for some sleep.

ypercubeᵀᴹ

@Darth_Wardy that's impossible.

Darth_Wardy

@ypercubeᵀᴹ it happened ... last night

ypercubeᵀᴹ

@Darth_Wardy It may be worth 128 billion dollars less. It's still worth the same in pounds ;)

wBob

I listened to that "Tiger Team performance improvements that will make your SQL Server roar" the other day but was so annoyed. It focused largely on config changes - you're trying to tell me making tempdb config and 1117-8 automatic is a performance improvement? Hmm.

Darth_Wardy

10:32 AM

@ypercubeᵀᴹ lol basically what i meant (badly worded I guess)

relatively speaking the net value of UK companies dropped by £128 billion

because of the shift in the value of the pound

ypercubeᵀᴹ

Ah, you meant the stock market. Ok then, I probably was wrong.

Darth_Wardy

there we go ... same page achieved!

Darth_Wardy

11:29 AM

git -unfuck: EU

bluefeet

@PaulWhite does sleeping == dead?

oh and

ypercubeᵀᴹ

@bluefeet Perhaps a reference to another Paul, Erdős

He used to have a peculiar glossary

> People who stopped doing mathematics had "died".

You rarely appear here and you haven't posted an answer since February ;)

dezso

11:51 AM

@Darth_Wardy don't know, their government seems to lack sanity

at the same time they are on the receiving end of that money pipe

(or giving from the pipe's POV, now that I am thinking about it)

Darth_Wardy

Poland has a lot to gain from its close ties to the UK, I think it see's us as a big brother to learn from

I could be wrong ... that's just how poland appears to me

Max Vernon

1:23 PM

@PaulWhite if the EU wants to shoot themselves in the foot, that will be ok... they will simply prove the Leave campaign was right.

Marian

We're living interesting times indeed.

Marian

1:57 PM

Related to another very current and interesting theme - gun laws in Aussie land seem to work really well.

JzInqXc9Dg

4:36 PM

so im trying to convert a varchar to an int. i cannot change the varchar datatype in the table - but they only thing the column holds is indeed number values like "5" "66" etc

But I get this: Conversion failed when converting the varchar value '5' to data type int.

When trying to do this: ,CAST([i].[Bottle Conditioning Time] AS INT)

seems liek it should work. I've also tried CONVERT()

this is sql 2008

anyone have any ideas? googling just seemed to suggest it should work

Andriy M

@JzInqXc9Dg That particular string is not just a 5, there's also a character with the code of 0x02 after the 5.

JzInqXc9Dg

interesting

Andriy M

Well, at least that was what I got after copying and pasting that bit into an editor.

JzInqXc9Dg

huh

Andriy M

Not sure if it will work: value '5' to data

JzInqXc9Dg

4:46 PM

i believe i just typed that into the chat ;)

value '5' to data ?

oh wait

looks like this will work CAST(CONVERT(CHAR(1),[Time to Tasting]) AS INT)

Andriy M

Yes, that's what I copied. When I pasted it, a "rogue" character appeared after the 5, and there was nothing else untoward.

JzInqXc9Dg

but... not all numbers are one digit of course...

Andriy M

Of course.

@JzInqXc9Dg That proves that there was something else beside the digit in the string.

JzInqXc9Dg

tho when i do that using Char(1) i dont see the two digit numbers getting stripped of their second digit...

sure

oh i lied. yes, doing char(1) basically chops of the second digit...

not sure how i will solve this..

Andriy M

If they all are supposed to be numbers, then one way to describe the problem would be "remove all characters from a string other than digits 0..9". I think there was a question similar to that not too long ago.

JzInqXc9Dg

4:52 PM

so maybe a regex thing

Andriy M

Well, finding strings containing rubbish is easy: WHERE yourcolumn LIKE '%[^0-9]%'. Problem is only how to remove the junk.

Here's a question about stripping non-alphabetic characters. Seems easy to adapt to stripping non-numeric ones:

93

Q: How to strip all non-alphabetic characters from string in SQL Server?

How could you remove all characters that are not alphabetic from a string? What about non-alphanumeric? Does this have to be a custom function or are there also more generalizable solutions?

sql-server parsing user-defined-functions alphanumeric alphabetic

Not what I had in mind, though, but I think it doesn't matter much. You only need to cleanup your data once (hopefully)

JzInqXc9Dg

yea im only two months into a new job

i am pulling a column from our ERP

and whoever setup the column used varchar instead of int

:(

Paul White

6:13 PM

@bluefeet To a first approximation, yeah I guess 😂

Paul White

6:48 PM

@wBob Oh dear. It happened at a time when I was around, so I missed it. Sounds underwhelming, but then I have no idea how many people out there aren't running 1117/8 or have a single tempdb file. There must have been more in the talk though as well?

billinkc

7:15 PM

Yeah, who'd ever have a sql server instance running with no tfs and a single file for tempdb...

physical_name	size	growth	is_percent_growth
D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\tempdb.mdf	3775384	32768	0
D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Transactional Logs\templog.ldf	4160	32768	0

the only reason it is no longer growing at 10% is because I know guy who had prod access...

wBob

@PaulWhite You know I wish I could say there was, but that's what they led off with. There was some bits about the improved logwriter and more irrelevance (XEvents reader is quicker now, great!?). I asked a question about actual performance improvements to columnstore, in-memory OLTP and optimizer. Still, I expect there will be more sessions and I could always go to PASS, which would be good.

billinkc

I I mean he, felt that adding multiple files would be a bigger risk than just being less dumb with growth

Tom V

4th time is a charm :)

billinkc

JFC

Paul White

@wBob Was this an interactive meeting session type thing or a twitter chat?

ypercubeᵀᴹ

7:27 PM

5

Q: Who is "focker" and why does he own my schema?

I have a Postgres DB deployment in Compose.io, and I am using the standard "compose" db for my app. I would like to wipe out the current DB contents so that I can recreate the DB with a new schema. I have read that the best way to do this is with "drop schema public cascade", but when I try to ...