The Heap™ – Consultancy ©® - 2014-10-23

« first day (1388 days earlier) ← previous day next day → last day (3473 days later) »

12:54 AM

@Zane thanks mang

And I've been busy. Family is in town.

6 hours later…

7:09 AM

possible duplicate of SQL: OPENROWSET, can't build for the request string? — Andriy M 30 secs ago

3 hours later…

ConcernedOfTunbridgeWells

9:54 AM

@Zane You could try a stint on the contract market over this side

ConcernedOfTunbridgeWells

10:14 AM

Morning all - from Sunny Canary Wharf now.

10:32 AM

Morning all from my couch, while on pain pills

10:55 AM

@bluefeet CouchBase today, ah?

@ypercube the next few days

Περαστικά.

11:09 AM

Is SO and DBA down?

ConcernedOfTunbridgeWells

@bluefeet What's wrong?

I had shoulder surgery yesterday.

ConcernedOfTunbridgeWells

11:55 AM

@bluefeet Doing what?

1 hour later…

1:07 PM

Hello

hi

@ConcernedOfTunbridgeWells I think she had explained in a previous discussion. Chronic problem, deteriorated by intense workouts ;)

1:26 PM

@ypercube Exactly. I had more damage then I was expecting. They took pics and it's interesting

Postgres is most popular: databasefriends.co/2014/03/…

@bluefeet May I ask what type of workouts wore it out? I'm having a bout of early onset midlife crisis exercise obsession and have been warned by a few people that I'm going to wreck myself

1:56 PM

@James Years of working out and usage of my shoulder really did it. But over the past year I started crossfit which uses a lot of the shoulder. It just got irritated. Basically my collarbone was too close to my shoulder and destroyed my rotator cuff.

2:19 PM

@AaronBertrand yeah that's what I thought

ConcernedOfTunbridgeWells

3:11 PM

@billinkc PostgreSQL has a nearest neighbour feature in its GiST subsystem. If the fingerprint guy could express his stars as vectors he might get some joy from that. Don't know how well it supports long vectors though.

I so respect your knowledge

Not that everyone in here isn't a super smartie, but you have the chops I aspire to have

He's also a good goal for scathing wit

ConcernedOfTunbridgeWells

3:35 PM

@billinkc I just read it in the docs. However, I really, really can't be arsed trying to prototype it and produce a meaningful answer to the question.

Right now I'm just trying to figure out why 15,000 subscribers to the Ec****ist don't have expiry dates on their subscription.

Currently this consists of grepping through about 40gb of flat file extracts from their circulation agent to find the source records for the subscriptions. I'm just a data monkey ...

@Phil It's on the internet, it must be true.

ConcernedOfTunbridgeWells

@MikeFal It did specify favourite DBMS platform. It's entirely possible that a large fraction of MySQL users don't actually consider it to be their favourite platform. Also, the sample is voluntary responses, so there may be some self-selection bias in the survey.

@ConcernedOfTunbridgeWells Sign me up and then add me to the non-expiry roles

ConcernedOfTunbridgeWells

@billinkc I had a subscription once. They come every week and end up cluttering every flat surface in your house. Be careful what you ask for. I think they start reproducing independently if you leave them long enough. I never had the nerve to try feeding them after midnight ...

@ConcernedOfTunbridgeWells Yeah, strikes me as a bit echo chambery

3:53 PM

The next request was for lazy evenings where I sit around reading for pleasure

ConcernedOfTunbridgeWells

@billinkc Sorry, can't help you with that.

You're off the list

4:06 PM

Is "open kimono" something that people in California are more likely to say?

This seems to be how it's used: urbandictionary.com/define.php?term=open%20the%20kimono

@ypercube well, it doesn't loads to me

ConcernedOfTunbridgeWells

@James I've heard it used metaphorically as 'opening the kimono' used to mean revealing some inside information.

Most people tend to consider the thought of me opening my kimono to be slightly horrifying.

@ConcernedOfTunbridgeWells Yes, I think that's what it means. "I'm going to tell you a secret, but I don't really want to, so first I'm going to say something that makes you picture me naked."

Hadn't heard it until a couple days ago but this dude I've been talking to in CA seems to use it every few sentences

ConcernedOfTunbridgeWells

@James It's a fairly widely used metaphor and joined the lexicon of corporate wanker-speak sometime in the '80s or '90s. Maybe it's just flavour of the month where he works.

@ConcernedOfTunbridgeWells Thanks. I find it a bit more annoying than even "WHAT ARE WE SOLVING FOR?"

ConcernedOfTunbridgeWells

4:13 PM

@James Maybe you should compile a buzzword bingo sheet and play it in meetings. Make sure it gets leaked to him at some point.

Buzzword bingo is part of our organisational DNA

ConcernedOfTunbridgeWells

@James I think you got to tick at least one box there.

I've never heard the phrase open kimono and I'd like to take this opportunity to invest in a Slap Over IP kickstarter so that you may appropriately convey my regards to them

ConcernedOfTunbridgeWells

@billinkc I'd pledge $10,000 contingent on you actually delivering the tool.

Unfortunately someone has slapoverip.com and has parked it on a server owned by google. I wonder if someone there is using his free time to develop the app?

4:30 PM

Perhaps that's what the drones are for

pneumatically launched rubber hand that glances across their face

ConcernedOfTunbridgeWells

@billinkc I'd pledge to a kick starter that made quadcopters with a robot arm that I could slap people with.

4:42 PM

The long stuff is confusing. My short example works, except when it doesn't.

my first solution which adds date is very short but i don't understand why it does not work with timestamp instead of date. what else do need to change? these other solution are long and confusing for me.. thanks — moe 9 mins ago

5:07 PM

I've been working with SQL Datebases all my life and I am now trying to get into No-SQL world.

What would the appropriate dba reactions be?

Someone loading a semiautomatic in anticipation of Russian Roulette

@ypercube something like this might be appropriate

or this :-)

user image

This question appears to be off-topic because it is about "gimme teh codez". Please show us your try first. Before requesting anyone's help you need to show you've done your bit. — Marian 1 min ago

The person in question must be utterly hopeless at SQL if starting from scratch with NoSQL represents a step forward.

5:15 PM

not too mean, what do you say?

Gimme teh codez should be closed as too broad

Sep 19 at 18:57, by bluefeet

see @billinkc gimme da codez = too broad -- http://stackoverflow.com/questions/25940661/keep-only-one-duplicate-value-in-sql‌-database

Two close votes but no down votes?

@PaulWhite they did call it a datebase

I would't trust a pilot that misspelled "airplane" either

@JNK Ha! True! I had missed that. Crikey.

Maybe they work at OKCupid

5:19 PM

@billinkc or they make calendars?

most likely just sloppy which is why they wanna go NoSQL

Much easier to hide the skeletons in unstructured data

there is a genuine impression from some folks that schemaless means you don't need to plan or design

@billinkc that message is only for you :P.

@PaulWhite fixed :).

Cool.

@PaulWhite This Q: dba.stackexchange.com/questions/80954/… They are only 19.

"all my life" has a new meaning now.

ConcernedOfTunbridgeWells

5:26 PM

Time for tubby bye-bye.

@ypercube Yikes.

@ypercube I was just about to comment on the age

@ypercube Wow.....I don't know what to say to that.

@PaulWhite need your help to remove my answer. — aasim.abdullah 2 mins ago

^ Eh? Is this is a limitation of the answer currently being accepted?

@JNK

@PaulWhite Yes.

You can't delete an accepted answer.

5:39 PM

@ypercube Thanks! So what's the owner of an inferior accepted answer to do? Flag it for a moderator?

Yes, Either flag or improve it.

Ha. He edited it.

-3

A: Does sql server backup process use buffer cache?

As found incorrect, answer removed by user.

Meta is so full of sh*t. meta.stackoverflow.com/questions/275166/…

Haven't seen @swasheck in a while. Wonder if the proxy at work is blocking SE now?

@PaulWhite yeah sorry I missed it

5:53 PM

Thanks @AaronBertrand

@ypercube is correct

No worries. I just pinged you as the most recent mod in the room.

@JNK Are marshals superior to sheriffs in the US?

@ypercube what's wrong now?

@ypercube Marshals are normally a state level office

or federal

So there's US Marshals

sherriffs are county or city level

i.e. LA County Sherrifs office

5:56 PM

@bluefeet See the last edit (rant) by the OP.

What a d-bag

@ypercube nice

He keeps posting comments how everyone else does not understand the issue.

Even Jon Skeet, apparently.

That Skeet guys a one trick pony as it is

6:06 PM

@JNK Thnx.

1 hour later…

7:10 PM

@AaronBertrand what was the heater you purchased for your daughter's room?

7:34 PM

Approximate link to the heater discussion

Nov 4 '13 at 18:38, by bluefeet

@AaronBertrand My folks used to have a space heater but these are much better. You can touch the heater and you will not be burned because the mechanics are much different. My two little great-nieces are walking around and there is no concerns about these heaters

@Kermit I was looking at one of these but never did buy one (couldn't convince the wife it was safe)

eheat.com

@billinkc is your name @AaronBertrand

@Kermit That's what the tattoo over my heart says

nice

Wife didn't think so but she never understands my devotion

7:43 PM

would she feel differently if it had been a Nebraska tattoo? :-P

It's like they say, the N stands for nowledge

8:10 PM

@James wasn't he preparing for a trip or something?

8:23 PM

@mmarie Nebraska tattoo would be worse. Silly corn.

8:52 PM

@MikeFal Not worse to Hilary

-3

Q: Whats the point of GROUP BY statement?

I've actually been programming in SQL for about a decade now. Mostly PL/SQL and recently I've begun getting into some T-SQL, but the whole idea of a GROUP BY clause has really bugged me. Please, let me explain before you immediately write me off as an idiot. Let's say you have a SQL like the fol...

sql database relational-database

9:04 PM

Are you eluding that in PL/SQL you don't need GROUP BY for that type of statement? — Kermit 10 secs ago

9:32 PM

Am I misreading the smartass on this comment?

Hmm I dont think i used the word job agent. But.. yes. — Rabin 8 mins ago

9:43 PM

@billinkc Nah, he apologized.

rusanu.com/2011/10/20/sql-server-table-columns-under-the-hood

I was unaware of the impact that adding/removing columns can leave without the rebuild

9:57 PM

@PaulWhite is this guy right? (i.e. is my comment wrong?)

It may happen but there is no guarantee that a CTE will be evaluated as many times as it is referenced. — ypercube 1 min ago

« first day (1388 days earlier) ← previous day next day → last day (3473 days later) »

Transcript for

Oct '1423

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