The Heap™ – Consultancy ©® - 2016-12-08

« first day (2165 days earlier) ← previous day next day → last day (2706 days later) »

12:00 AM

@TomV :P

Yawn

12:44 AM

You guys ROCK !! — Joe Blow 5 hours ago

6 hours later…

6:21 AM

@JamesLupolt Thanks for the link an the explanation. Sounds good except for the bit in the article which reads multiple NICs. I don't have multiple NICs, only multiple IPs assigned to one NIC. :-)

> Windows Vista and later are based on the strong host model. In the strong host model, the host can only send packets on an interface if the interface is assigned the source IP address of the packet being sent. Also the concept of a primary IP address does not exist.

Oh and I'm not sure I need both firewall rules, I'm just making sure it always works.

2 hours later…

8:02 AM

Morning, beautiful people!

@hot2use yep, the same rules get applied on a server with one NIC.

Morning

@hot2use you should be able to remove one of the rules.

@JamesLupolt I added an edit to my original question where I linked to the article you mentioned. Would you care to flesh out your answer a bit based on my question and post it as an official answer? I'd do some testing on my side to ensure it works and then gladly hand over the bounty. Thanks a bunch.

Good Morning @AndriyM and @JamesLupolt

Morning @Philᵀᴹ

8:27 AM

I feel left behind :( @hot2use

Morning :)

8:37 AM

@TomV Phil greeted beautiful people here, shouldn't that include you as well? :)

Morning

Ooops. And a wonderful good morning to @TomV too.

:-) Twas not my intention, to leave you out

Good Evening @PaulWhite

@hot2use Evening!

@PaulWhite are you situated in Aotearoa? Or is that just your name?

@hot2use Yep. Paraparaumu.

8:48 AM

Never took that road down south.

From Auckland?

Yep. The two times we travelled down south, was on HW 2.

Been to Wellington. And to Christchurch before the Big One.

I see. Yes SH2 is a very pretty way to explore the NI.

I have relatives in Snells Beach (North of Auckland), Matakana and near Omaha Beach.

@hot2use Lovely!

8:52 AM

@PaulWhite Just curious. Are you self-employed or do you work for a company?

@hot2use For myself.

@PaulWhite Cool. Nearing 10pm your side of the globe. I'd love to raise a stubby with you.

Speights, Lion Red, Monteith's, Mac's Gold

@hot2use Perhaps we will be in the same place at the same time one day. Your profile says you are in Switzerland now. Were you originally from NZ?

9:13 AM

1

A: How to generate all string's suffixes after split?

I think this is my favorite. create table t (id int,str varchar(100)); insert into t (id,str) values (1,'a.b.c.d.e'),(2,'xxx.yyy.zzz'); select id ,array_to_string((string_to_array(str,'.'))[i:],'.') from t,unnest(string_to_array(str,'.')) with ordinality u(token,i) ...

funny, two answers on the same question from the same person

@dezso Why not, they are different approaches, so the OP can accept what worked best for him and the community can upvote whichever they like best

@TomV well, in this case Erwin should have sometimes 4 or 5 different answers :D

@dezso I believe paul posted a meta thread in here once suggesting it is good practice, but I don't post multiple answers either

10

Q: Is it OK to post multiple answers to a question?

Possible Duplicate: What is the official etiquette on answering a question twice? Example scenarios: I answer a question on Monday, then on Wednesday I come up with better, but completely different answer. Should I delete my original answer before I post another? What if both answers...

discussion answers multiple-answers

@PaulWhite Not really. My relatives (brother, uncle, aunt, cousins) and myself are originally from England (West Yorkshire & Nottingham). Uncle, aunt and cousings emigrated to New Zealand in 1984 and we emigrated to Switzerland (1981). My brother then emigrated to N.Z. in 2002.

@TomV @dezso Local perspective:

17

Q: Are two answers by a single person on one question A Good Thing™?

I know there is an "official" StackExchange meta-post already concerning this question, however I think it would be suitable to have our own post that reflects our position. This really excellent question has provoked a number of excellent answers, one of which was self-deleted after the OP req...

9:32 AM

Ah that was the one yes, it's better

@PaulWhite I see, thanks

@hot2use you are next

-1

Q: Filter is applied after DISTINCT ON

There's a script at the end that will fully create the schema and populate it with sample data. Schema Consider these two tables: Table of polygons: CREATE TABLE my_polygon ( my_polygon_id SERIAL PRIMARY KEY, common_id INTEGER NOT NULL, value1 NUMERIC NOT NULL, value2 NUMERIC ...

postgresql query-performance

I don't understand why someone downvoted - maybe by mistake?

@dezso You never know. Been there 6 times. Love it. Went there for 15 days once, when my cousin got married. Had a blast in Auckland. Went through Ponsonby Rd. ....

It's funny how often UK/NZ/Switzerland comes up in the same conversation in here.

Nov 1 at 10:52, by ConcernedOfTunbridgeWells

Now, I've actually been to Lugano, Lugano is in Switzerland near the Italian border, on the eponymous Lago de Lugano.

COTW is a kiwi who has lived and worked in the UK for some years.

9:51 AM

@hot2use I'm from Nottingham originally

@Philᵀᴹ "it can call VBA .. functions from SQL". My life is now complete.

3

Well we lived in Sutton-in-Ashfield for a couple of months . So I know Gizzago and Ay-up

Went to School in Mansfield.

My gran lives in Ravenshead

@dezso They want a view with parameters?

@Philᵀᴹ @PaulWhite Could be that Switzerland, England and New Zealand are all cool places to live and work in. (Actually the Lago di Lugano is called Lago di Maggiore)

10:01 AM

When I first read it, I thought they meant they had found a bug. But seems like not a bug report.

More like "how to do it".

@Philᵀᴹ Can't remember Ravenshead. Is it on the way to Robin Hood's tree going down south from Mansfield?

When pushing down a filter changes the result, the output essentially becomes a function of that filter. Hence, a view cannot be used in your case. — Andriy M 6 mins ago

@AndriyM so we read the question the same way, ok.

(Nottinghamshire-) Joke of the Day: Vet; “Is it a tom?” Cat owner; “Nah, av gorrit wimee.”

@hot2use had to read it thrice

10:11 AM

@dezso hehe. I always smile when I read the Nottinghamshire dialect.

@hot2use reminds me the conversation between the English and the Australian soldier in the trenches

@dezso I've read it much more times but never got it, although I realise it must have to do with dialect/pronunciation.

@hot2use That would need an explanation AGL

Something like "No, I've got it with me"?

"It is a tom" [Is it a tomcat!] --> Nottinghamshire dialect: "Is it at om?" [Is is at home?] - Nah, av gorrit wimee [No, I've got it (the cat) with me]

10:15 AM

@hot2use too short for jeagl

Ah, there, the hard part was in the question, I guessed it might be.

@dezso go on

@AndriyM reading it out loud (or at least imagining doing so, to prevent strange looks from colleagues) helps

@hot2use no idea how to put it into in writing, but: English soldier: 'Have you come to die?' Australian soldier: 'No, I've come yesterday'

@dezso HAHAHAHA

yesterdie

10:18 AM

Here's another: "Innit code"

= Isn't it cold? (When talking about the weather)

I was waiting for the punchline :)

Developer in Nottingham: "What do you want to talk about?"

Employer in London: "Init Code."

@hot2use Nice.

Developer in Nottingham: "No, the sun is shining."

@hot2use Have you seen Mr Robot?

10:23 AM

@ypercubeᵀᴹ Nope.

It had an episode with Init1 or Init 5 (or both can't remember)

@ypercubeᵀᴹ Added to toodledo list

Mr Robot is bonkers realistic

wired.com/2016/07/real-hackers-behind-mr-robot-get-right

10:43 AM

Seems fun. Will have to watch

10:59 AM

5

Q: PostgreSQL DELETE FROM fails with `Error: attempted to delete invisible tuple`

The error Trying to delete tuples containing invalid timestamps with DELETE FROM comments WHERE date > '1 Jan 9999' OR date < '1 Jan 2000' OR date_found > '1 Jan 9999' OR date_found < '1 Jan 2000'; ends in ERROR: attempted to delete invisible tuple There is a mailing list from 2009 discus...

postgresql recovery corruption postgresql-9.5 disaster-recovery

You can't beat a nice message like that. "invisible tuples"

11:22 AM

@AndriyM @dezso so a function might be an appropriate solution?

@ypercubeᵀᴹ very well can be

12:25 PM

Postgres partitioning support: git.postgresql.org/gitweb/…

12:48 PM

> and it doesn't handle updates that cross partition boundaries.

Still some distance to go to become a proper database then ;)

@PaulWhite Not like SQl Server then? :P

@Philᵀᴹ That has much further to go as we all know.

Hm. I'm not very good at the trolling.

:D

Not necessary for a moderator. Being good at kick-muting should be enough. :)

1:21 PM

Good morning !

I'd like to ask a question and include a table definition, what is a clean way to do so ?

(I do not have much knowledge of stackexchange question formatting)

@A_V Have you read dba.blogoverflow.com/2012/06/help-us-help-you?

Or are you asking how to obtain the script? Or how to format it on site?

did not read this

@A_V If it's just formatting, select the script part and hit CTRL+K or the {} icon on the edit toolbar.

There's some slide-out help during question composure IIRC.

What's the nicest way to explain a table with column definition in a post ?

Also: How do I format my posts using Markdown or HTML?

@A_V Do you mean adding the EXPLAIN output for a query?

1:26 PM

I think I'll just use pictures, less hastle

@PaulWhite you rang?

@A_V Pictures for what?

Explaining a database table

column names, data types

@A_V What's wrong with just posting the CREATE TABLE statement?

I don't know, I guess that would do too

If it's a mile long it'd be annoying to read wouldn't it

1:30 PM

@A_V Most tables don't have a mile's worth of columns. The code box will auto-scroll. Are you talking about scripting multiple tables? How many lines are we talking about?

(also I can't imagine an image of that size would be very practical, or well-received)

@A_V Pictures may be less hassle for you, but a lot of hassle for the potential answerer trying to reproduce your issue

And will significantly lower the number of people willing to take the effort in looking to help you

Ah. Yes. Makes tons of sense, I'll use scripts

A picture of code is quite a good way to get a question downvoted and closed, in my experience.

and the mile long script was more just a scenario I thought of, not my actual case right now

Generally it's a simple as generating the script, hitting Paste in the code editor and then hitting CTRL+K or the {} icon as I noted before. Only for truly huge scripts (hundreds of lines) is it better to host off site e.g. github/pastebin and link to it in the question.

1:35 PM

The guy who installed this database thought it'd be a good idea to install it in french

little did he knew how much more complicated it makes error finding online lol

1:49 PM

@A_V I feel with you. My current employee likes German SQL Server installations. Try finding the performance monitor counters when you've been used to English installations from 1995 (SQL 6.5) till 2015 (SQL 2016).

I agree completely, a lot of our customers are in France, you can't google any error message, you can't import performance counter templates as XML etc

royal pain is an understatement

So Anglocentric... And I even agree...

It should be forbidden by Microsoft. And because the SQL Server installation is non-English the OS is bound to be non-English too. Double-Yuck

@hot2use That beats mixed-language context menus though

> Syntaxe incorrecte vers 'SELECT'.
> Falsche Syntax in der Nähe von 'SELECT'.

1:53 PM

@TomV Yes, it doesn't help.

Échec de la connexion de l'utilisateur 'NOM_DOMAINE\NOM_COMPTE'. (Code d'erreur : 18456).

Contactez votre administrateur système.

The worst thing I've seen is an entire programming language made of french statements

SI TwainVersJPEG("C:\Temp\MaPhoto.JPEG", 0, Faux, TwainNoirBlanc) = Vrai ALORS
Info("Le document a été enregistré")
SINON
Erreur("Le document n'a pas été scanné")
FIN

Excel VBA :D

It's like someone in the company doesn't have enought job so he chooses terrible infrastructure configurations to make debugging take long enough that he doesn't end up doing nothing

Never knew why Microsoft did that Office VBA multi-lingual = Mega Fail

1:59 PM

did it have an
´ALLEZVERS libellé´?

(instead of GOTO)

I don't know I really try to keep my distances with those languages, even though I live in quebec I force any configuration I make in english

I'm developing a head-ache. Anybody want to swap for an aneurism?

There's a law in quebec that tries to force everything to be in french

So some companies that get government subventions get audited and receive complaints if they don't work with french enough

Developing a headache is a perfectly normal reaction to chatting in The Heap™.

forcing some random business choices of forcibly installing french products

2:02 PM

@A_V Or choosing to not apply for subventions

@PaulWhite Ooooh. And I thought it was from the multi-lingual discussion.

@TomV Douleur royale dans le cul

Did I get it right?

YES

I would like to see the business case for that, "Obeying the rules costs X, subventions return Y, we would need Z subventions to make it worth while, if not screw the rules"

translate: Douleur royale dans le cul

(from French) Royal pain in the ass

Nice.

2:04 PM

Did anyone ever calculate the ROI or the Cost on hat?

:)

chapeau

@TomV sometimes it's not really a choice small businesses have, here the biggest expense is getting a building for your company. You can chose to rent in a building that has the rent half-paid by the government

Those building end up filled with tech companies so it's good for small towns to develop tech jobs, yet the french laws end up pushed everywhere as a result

@A_V There is a neat trick you can pull in the area I live, close to the flemish/walloon border

you buy land that crosses the border, put an office on one side, put another small office on the other side of the border

I once had SQL Server 2005 course with German MOC manuscripts. A "router" was a NETWERKVERKEKHRWEITERLEITUNGSKOMPONENTE or something like that.

you concentrate part of your business in one building, part of your business in another (depending on which region subsidizes that part best) and get money from both regions

3) Profit

or do that trick to get away with things that you can't do in the other region and stuff like that

2:11 PM

Wow, is that a common thing

yes very

that's so clever

For example in flanders you can't do X, oh but we don't do that in flanders you see, there is a garden shed at the end of our parking lot that happens to be walloon and that's where we do that"

and it's often literally a garden shed

@TomV like

laws are made to be circumvented aren't they

2:17 PM

And the 2 terrains don't necessarily have to connect, you could buy 2 plots of land but it makes logistics a bit harder

@A_V Not on this site :-D

I'll try to behave myself then

@hot2use you got it nearly right

otherwise in Germany the thing is called a 'router'

at least nowadays

@A_V finally someone

2:37 PM

Nowadays, yes, it's called a router. But not in the 2005 MOC. French for switch: commutateur réseau

As a non-native French speaker it's easy to make a fool out of yourself when presenting in French

I remember trying to explain end-user tasks but had a slide up that said Taches utilisateurs, instead of Tâches utilisateurs

couldn't figure out why everybody was laughing

found out later I wrote "end user stains" instead of "end user tasks"

heheheh

jeagl-fr

2:59 PM

My favorite one still remains "piechart" however

"Diagramme en camembert"

@hot2use the French are infamous for translating everything

on the other hand, speaking about tech topics in German is very confusing, sometimes half the sentence is in English, actually

like 'der Pull Request wurde gemergt'

@TomV never heard this one, is this something that you messed up translating or do they really use that ?

@A_V In France it's common

my god google translates say it's actually that

@A_V google.de/…

3:10 PM

That would cringe everyone in quebec may you use that only once :D

love it

I've only heard the very literal translation "graphique en point de tarte"

which is the exact same thing as in english

Not quite. A pie can be a tart, but a tart doesn't have to be a pie.

:-)

or is it the other way round

@dezso wollen sie die änderungen speichern?

@dezso Wir wollen die Stored Procedure modifzienren, damit die Loops im Cursor nicht mehr in ein Timeout laufen.

I always thought the tarts that the Knave of Hearts stole from the Queen of Hearts weren't pies. So "a tart doesn't have to be a pie" may be right.

Gotta run. Toodle-pip.

3:22 PM

The data source is pointing to a valid server name, which I know I have access to. I am trying to import an excel file into SQL using MDX from Excel and scripting it into my SQL code. — VS1SQL 19 mins ago

Who wants to point this guy to the toolkit @Philᵀᴹ linked yesterday :D

Mind blown

Or should I say buffled

3:40 PM

I don't want to encourage the afflicted

What does this toolkit do ? Translate excel documents into insert statements ?

hey guys

i'm wondering whether i can optimize a query or whether it has to take as long as it does

here it is: pastebin.com/HjSVnaxR

i think because of the cross join (which is needed; i need to generate a spreadsheet report taking into account every user against every record) it is just going to be a slow query

given that Record has 38397 entries and MaintenenceJobHistory has 73480

if i pivot the end result im guessing it won't make the query any quicker?

@Jez Seems like a question you could ask on the main site if you include table definitions, execution plans, time it takes now, number of records it returns and RDBMS you are working with

execution plans?

SSMS gives a graphical plan

3:55 PM

Right click it, view execution plan xml, go over to brentozar.com/pastetheplan and copy paste it there. Include a link in your question

@TomV and on the OK button: na klar

@dezso We used to work with a piece of software that you had to restart whenever something went wrong, restarting worked all the time, but took a long time, so they added a faster restart which only worked sometimes

they had 2 buttons "Neu starten" and "Neu starten (Schnell - Unsicher)"

@hot2use jawohl

@Jez The rec derived table, why does it use grouping and aggregation? You are grouping by innerRec.id and pulling data only from innerRec. The id name seems to imply that it's the PK, so grouping by the table's PK and aggregating only columns of the same table doesn't seem necessary.

I realise that joining to innerLnk may produce duplicates and hence the grouping, so the join thus works as a filter. But then you should probably replace it with a semi-join (EXISTS) and get rid of the grouping.

(
    SELECT
        innerRec.Id,
        innerRec.CreationDate,
        innerRec.LastModified,
        innerRec.AssetType,
        innerRec.MasterFilename,
        innerRec.GameName
    FROM
        [dbo].[Record] AS innerRec
    WHERE
        EXISTS
        (
            SELECT
                *
            FROM
                [dbo].[RecordClassificationLink] AS innerLnk
            WHERE
                innerRec.Id = innerLnk.RecordId
        )
) AS rec

Something like that

If Record.id is the PK, that is.

4:37 PM

will that improve performance much?

@Jez Yes, probably.

You could further improve it (making it simpler) by getting rid of all the subqueries and perhaps the GROUP BY

if the usr.OrganizationName is also the PK (or has UNIQUE constraint)

I suggest you post a question at the site (our site: dba.se)

that just links to a Telia page

thinking of submitting for sql saturday tehran, but not sure if my company will cover the travel expense

@Jez huh?

4:56 PM

dba.se

dba.se is a nickname for Database Administrators.

ConcernedOfTunbridgeWells

If you're coming to drinkies tonight and arrive before me then the booking is in the name 'Nigel Campbell'

Ah, Scintillating Talks Day.

ohh i see

@ConcernedOfTunbridgeWells Yep, Ill be there so see you in a few hours.

5:07 PM

@ConcernedOfTunbridgeWells @MartinSmith not sure what time I'll come but I won't stay very late.

Feel free to order food ans start eating. I'll probably have only a beer or two.

1 hour later…

6:22 PM

@PaulWhite did I misunderstand this question, I hadn't seen your edit

Okay thank you, quite a few people have edited the question, I can see where you are getting confused with where Excel is coming from as someone edited the title to include Excel. — VS1SQL 2 hours ago

@TomV You seem to have worked it out, thanks. The original wasn't very clear at all.

@PaulWhite Should I still flag the comments? :)

@TomV If everything useful is in the question, of course you should.

Thanks.

@TomV Have you given up on the IF EXISTS question now?

I was implying "you can go delete them all if you think it's been worked out, I'm not sure what is creating more work for you since you are already looking at the Q"

No, I'm in here for 5-10 minutes at a time, I've looked at it briefly yesterday

your suggestion with the local variable is useful too

@TomV Yes I know. Just making you do some work :) It's also quicker and easier for you since the context is current.

@TomV Shall we move the discussion there?

6:39 PM

good idea

→ 17 messages moved to Discussion between Tom V and TheGameiswar

7:09 PM

0

A: Update of FAQ question "How do I ask a good question"

This answer is community wiki please provide additional database-specific information at the bottom. Formatting When possible do not include pictures where text would otherwise do, and even better than text is the necessary SQL to build a test case. If you have the skills to provide test data i...

7:24 PM

Just for any constructive input you might all have on that question / answers.

I don't think Master Database feeds those in.

Good afternoon chaps.

@EvanCarroll Morning.

my question was closed -- it really was a duplicate, I've submitted an additional answer to this: meta.dba.stackexchange.com/a/2642/2639

@EvanCarroll Yeah it's one boxed just above.

Yea, I just wanted to see if anyone wants to collaborate on methods to dump a test data -- a table -- suitable for pasting into questions.

7:32 PM

@PaulWhite the pre-cog ;)

@ypercubeᵀᴹ UTC+12 has its advantages.

Minority Report (film)

Minority Report is a 2002 American cyberpunk action mystery-thriller film directed by Steven Spielberg and loosely based on the short story of the same name by Philip K. Dick. It is set primarily in Washington, D.C., and Northern Virginia in the year 2054, where "PreCrime", a specialized police department, apprehends criminals based on foreknowledge provided by three psychics called "precogs". The cast includes Tom Cruise as Chief of PreCrime John Anderton, Colin Farrell as Department of Justice agent Danny Witwer, Samantha Morton as the senior precog Agatha, and Max von Sydow as Anderton's superior...

@ypercubeᵀᴹ Yeah I got that reference. I do get the odd one you know. :-p

Just in case someone else didn't get it immediately. AGL and all that

I was kinda expecting a joke about prefetching pages tbh...

7:35 PM

@EvanCarroll Oh I see. Hm. Well would it be better if your answer was CW and had some small notes at the top about wanting collaboration? One of the issues is that toy databases don't support CTAS.

@Forrest That will be along earlier.

@EvanCarroll sqlfiddle has a text-to-DDL option

@EvanCarroll Or I suppose we could reopen the original, put your proposal in an answer, get the input then put the final result in the general proposal? What do you think?

@Forrest Yeah but it's hardly reliable enough.

Yes. good idea on community wiki. I know about the Residential Databases not supporting CTAS too. However, with MS you can order "Azure Data Warehouse" version which does have CTAS. It's $1,125/mo but each database that runs under it is $5/mo. I should probably provide upgrade information in my WIKI Answer.

Serious too, msdn.microsoft.com/en-us/library/mt204041.aspx

We're a community of professionals anyway, if we're going to allow Microsoft I think we should at least exclude their more tawdry offerings.

@EvanCarroll Yeah the new coolness. We're still reeling from DROP IF EXISTS and CREATE OR ALTER as well :)

@EvanCarroll LinkedIn is defo off topic.

CTAS will be in v.Next I'm sure. It might even be in CTP 1, I don't know.

LinkedIn is careers.stackexchange.com done right. If you want success, you need a method to share your kid's high school pictures.

7:49 PM

I'm going to need to think about the formatting thing a bit. Hopefully some others will chip in.

cool cool

Has the first post review algorithm changed, I'm seeing older posts in there

like this one

lol @ that answer. Totally forgot MS SQL doesn't support LIMIT.

8:18 PM

@EvanCarroll Yeah it supports the standard syntax instead dba.stackexchange.com/a/30455

2

8:33 PM

@TomV I believe a new (older) post became eligible for First Post review when a previous (newer!) one that was FP reviewed ended up being deleted.

9:08 PM

Duplicate of multiple row selection to a single row — ypercubeᵀᴹ 6 mins ago

Where does the it_approval_date and uat_approval_date or reg_approval_Date come from? What are the table definitions or the join conditions? — Tom V 1 hour ago

I see you edited it based on comments though

@TomV I edited based on comments and on the duplicate q ;)

@TomV They come from table2. The names (IT, UAT come from table2 , the values come from table1). Looks something like EAV

and I see we got an RDBMS now too

I may retract my VtC

@ypercubeᵀᴹ Yes but the OP could have explained at a little greater length what he meant at that time :)

@PaulWhite "getting attention for unanswered questions" has this:

> ... The question has long since become buried by newer questions, ...

@ypercubeᵀᴹ Yeah it's not perfect, but it's better than the local help page.

> Do not post your question a second time, as it will be closed as a duplicate of your first question.

9:19 PM

On the train towards the drinkies meeting. Stopped at Ascot.

(salvaged the typo)

Nicely done.

TypooCubeᵀᴹ

2

I think that settles my name for the Hat Season.

Does anyone think that question is unsuitable for migration to Stack Overflow?

@PaulWhite this one?

@bluefeet Yes indeed.

9:24 PM

I wouldn't. It will most likely be closed there

it's a pretty bad question

@bluefeet Due to?

@PaulWhite lack of any effort shown on how they tried to solve it

Oh I assumed ypercubeᵀᴹ and Tom had knocked it into shape given Tom's "I may retract my VtC".

@bluefeet I was mostly looking to start a bit of a discussion about basic questions.

Again.

> I'm a beginner...

I get that beginner questions have been discussed again lately :)

just not sure that's a great question to migrate to SO

@bluefeet Agreed. But really I was asking the room for opinions on the subject.

9:29 PM

@PaulWhite well I'll just shut up then

@bluefeet Well it's ruined now. I'm going to sit in the corner and have a cry.

we can use it to place bets. How many minutes after migration before someone answers at SO?
What are the odds that is closed?
Of Gordon posting the 1st answer?
... etc

@PaulWhite does this hat help?

user image

2

Ooo hats! :-D :-D :-D

gotta get you ready

9:42 PM

@ypercubeᵀᴹ A certainty isn't a fair bet though.

@PaulWhite It is if it pays notihng.

@ypercubeᵀᴹ I suppose that's true. Doesn't sound like much fun though.

We can bet on the number of answers it will get. After 10 minutes, after 1 hour, etc.

But if you are not into betting, ok.

@PaulWhite I just thought it might add some fun into the dull process of migrating a dull question.

@ypercubeᵀᴹ We hate fun

Besides bluefeet said not to.

any answers please — Kannappan Somu 5 mins ago

10:00 PM

@PaulWhite Don't think it's worth migrating.

@MDCCL Nah it's terrible and we're probably going to close it as ... oh I don't know, anything really :)

@PaulWhite Closed as unfortunate, perhaps :)

2

I like that.

> I'm voting to close this question because ... awkward

@PaulWhite Any adjectives to close as... please

10:35 PM

@bluefeet But it has tag pivot!

user image

1

A: multiple row selection to a single row

Typical PIVOT: select request_number, creation_date, it_approval_date, uat_approval_date, reg_approval_date, prod_approval_date, status from ( select request_number, creation_date, approval_date, approval_name, status from table1 natural join table2 ) pivot ( min(approval_da...

it's also oracle, so blergh

2

@bluefeet But you wrote our standard Oracle dupe target! You must love it.

I AM BACK.

10:44 PM

@PaulWhite I worked in it, but I didn't love it. My love affair is with SQL Server.

@bluefeet Yay :)

Do you get to SQL much as a CM?

I do still write SQL. I recently got access to using SSMS instead of SEDE which is great. But I also still write SQL in my work with R.

When I propose changes, etc to various things I have to write queries to see what would get impacted by it

I found a hard question on SO. I fixed it up. I hope the move it to dba.SE.

i want to see how it gets solved.

@bluefeet I find SEDE almost impossible. I'm so lazy these days being used to SSMS with SQLPrompt etc. I struggle when stuff doesn't auto-complete etc.

@EvanCarroll Link?

I really don't want it answered there, but here is the teaser. stackoverflow.com/questions/41045859/…

10:50 PM

@EvanCarroll Many of the regulars here have VtC on SO.

@PaulWhite SEDE has it's usefulness but when I'm trying to query thousands of rows it's difficult. We have an internal instance that we use but it's pretty much the same

@bluefeet No wonder everything takes 6-8 weeks ;)

It seems to involve CUBE, array_aggregates, can make use of 9.5's+ FILTER, and what it really needs is an ARRAY exception. I think I could do it with intarray as a module easily. It's a clusterfuck writing it in sql though. And, i have to wonder if I'm doing it right.

Probably can also make use of tablefunc/pivots. But, that would be out of my pay grade.

@PaulWhite excatly

I think it's the hardest postgresql-sql-specific query question I've ever seen.

10:51 PM

@EvanCarroll So you haven't voted to close -> off topic -? belongs on dba ?

No, because the SO guys are shitty a brick at me.

The keep refusing the flags, claiming that the question isn't off topic there.

@EvanCarroll Not talking about flags. Votes. Of the closey kind.

Which is strictly true, but I tried addressing this problem and it seemed there were far to many closed minded folks here to get a solution

yea, I do 50 a day

I'll do another one

@EvanCarroll Oh I see. I keep forgetting there are limits.

yea, so I've flagged probably 300 to move to DBA.se

I think maybe 2 got moved.

It's a gigantic waste of time.

Anyway just flagged it.

11:50 PM

@PaulWhite So it was not that unfortunate

@ypercubeᵀᴹ You might find the following Q & A's of interest:

2

Q: How to get minimum and maximum for grouped timestamps

I would love to know how to create a view that groups timestamps in 10 minute nearest 10 minute intervals and contains each minimum and maximum timestamp for each. So a table that looks like this: | Hero | timestamp | | Batman | 2016-12-08 12:00:00 | | Batman | 20...

postgresql group-by datetime postgresql-9.5 gaps-and-islands

« first day (2165 days earlier) ← previous day next day → last day (2706 days later) »

Transcript for

Dec '168

The Heap™ – Consultancy ©®

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile