The Heap™ – Consultancy ©® - 2011-11-14 (page 3 of 3)

« first day (314 days earlier) ← previous day next day → last day (4555 days later) »

Ben Brocka

7:15 PM

@gbn Thanks! Good to at least see the term used in official docs.

gbn

@BenBrocka it^s mixed and inconsistent

and you're welcome.

Ben Brocka

Yeah, as for my error message it seems like "distributed query" would be the more logical term to use

Querying linked servers definitely says "distributed" to me, "heterogeneous" is certainly a less common term and requires a bit more thinking to tease out the connection

gbn

homogeneous is the opposite of course

Oracle docs use heterogeneous too in places

and distributed

the error message is correct: a non SQL Server linked server

Ben Brocka

@JackDouglas Certainly appears to be how they're used. "tuning" is too vague for a tag imo.

gbn

for SS to SS, it is less important. For SS to non-SS then SSL expects ANSI compliance

Dunno why though

Ben Brocka

7:20 PM

@gbn Those servers should all be linked actually, that error means the query was hitting a non-linked server?

I didn't think you could even query a different server with that syntax unless it was linked

Oh, wait, do you mean a linked server that isn't SS?

gbn

@BenBrocka yes

Ben Brocka

Ah. All our servers are SS too (...I think, old system used pervasive, I don't think we left any of them). Does it just enforce ANSI compliance when reaching any linked server regardless then?

gbn

@BenBrocka to be honest, I've forgotten.

Ben Brocka

Not a big deal, doesn't break anything here anyway

Q: killing zombie children in parent processes

So I want to do the following: Set up a daemon that forks a bunch of processes. So the Daemon forks a bunch of processes then forks another bunch of processes the problem is the child processes might take a long time to exit. How do I prevent zombie children if the parent process has other work...

Is it wrong to giggle at this?

1 hour later…

jcolebrand

8:47 PM

Did everybody here go vote? stackoverflow.com/election

DTest

@jcolebrand does a downvote count?

@benbrocka absolutely not wrong. I laughed and shared :)

Ben Brocka

9:27 PM

@DTest I wish I could kill zombie children at my job

jcolebrand

@DTest sure why not?

DTest

@jcolebrand you're only saying that because you know you haven't gotten any downvotes..

incoming fulltext searches in innodb : drdobbs.com/database/231902587

jcolebrand

@DTest pfft, I've gotten at least 20+ downvotes on the election. I'm not skeered

DTest

@jcolebrand yeah i was talking out my arse :P

Ben Brocka

9:56 PM

Is there some way I can do a "WHERE EXISTS" style query when comparing more than one column? I need to copy records from a table but the PK is three columns

DTest

10:39 PM

for t hose that haven't, here's a good read: plus.google.com/112678702228711889851/posts/eVeouesvaVX

Ben Brocka

@DTest That's awesome, thanks for the link

jcolebrand

10:56 PM

Q: Best way to design tournament database **image**

I'm creating a webpage for placing bets on all matches of the upcoming Euro 2012 football tournament. Need som help deciding what approach to take for the knockout phase. I have created a mockup below, which i'm pretty satisfied with when it comes to storing the results of all "known" group stag...

mysql sql database-design

I asked for this one. It needs TLC but my PC is on the brink

grrrr

Ben Brocka

you picked the wrong time =p I'd fix more but I'm off to go home

night all

DTest

11:12 PM

same, i'm outta here to learn a new sound board