SPAM random annoying things

[caLLous]

Yeah I've said as much to them but they've all fucked off for a long weekend now so it will have to wait. I'm usually pretty lenient because I do live in the middle of rural France and there's so much more space between the towns and cities over here so I can see that, when the main distribution hubs of the likes of UPS are in Narbonne (100km away), they just don't get around to everyone when they say they're going to. It's just annoying that they didn't send it until 10 hours after I ordered it. If someone pays 3 times the value of an item for urgent shipping you'd hope that they would get pushed to the top of the queue.

 

[BloodOmen]

Yeah I've said as much to them but they've all fucked off for a long weekend now so it will have to wait.

Aye its a cunt, had a few like that myself where I've had to wait out the weekend/bank holidays.

 

[Raven]

Oh, the old French work ethic, as little as possible.

 

[CorNokZ]

About to fall asleep. Phone on 4%. I now realise my charger is in the living room. I cannot get up

 

[Raven]

Writing SQL queries.

 

[Zarjazz]

Writing SQL queries.

People writing bad SQL queries.

"Index, what's an Index?"

 

[TdC]

Hah, in an amazing coincidence I had this book in my hands while cleaning my office earlier today : thinking in sets - Google Search

 

[Raven]

People writing bad SQL queries.

"Index, what's an Index?"

The SQL bit isn't really that troublesome, its the report writer I am using where I have to add various lines of code to get search functions and whatnot for the user, code that isn't SQL so I have to remember to remove it when I drop it into management studio to test. Getting so bored of "Incorrect syntax near "whatever"

 

[old.user4556]

People writing bad SQL queries.

"Index, what's an Index?"

Or when Oracle decides to not use an index by using a different execution plan, killing the DB performance and knocking over thousands of users.

 

[Zarjazz]

Or when Oracle decides to not use an index by using a different execution plan, killing the DB performance and knocking over thousands of users.

Oracle isn't alone in that. I've been hit by the M$ & MySQL query optimizers having a brain fart many times. Though last time I checked Oracle seems to be the only major DB vendor where you can't reliably force the choice of index to use, it only accepts hints that it can still decide to ignore.

 

[TdC]

woo that sounds a bit odd G-Dizzle. generally a database engine won't do something silly like that.

edit: ah, so it's a known thing? wow. my old lecturer would have a fit; he was forever banging on about how much smarter the engines were than the average student

 

[old.user4556]

woo that sounds a bit odd G-Dizzle. generally a database engine won't do something silly like that.

Worse still, the DBAs finger-point with "shite application code" and the application guys say "shite Oracle profiler". Rinse and repeat when it inevitably does it again.

 

[Zarjazz]

woo that sounds a bit odd G-Dizzle. generally a database engine won't do something silly like that.

It's actually a common problem on large or very busy tables. Either the index statistics get out of date so the engine can't accurately pick the correct one or a table with multiple indexes grows to a critical cardinality threshold and suddenly a different index is picked killing performance.

 

[old.user4556]

Ah the good old days when the coders sat beside the DBAs who sat beside the unix guys who sat beside the "tin and wire" server / network guys. A nice tight little unit working in harmony to make good applications. Now it's all fucking silo'd up with the DBAs in Chennai and the application guys in Bangalore blaming each other through broken English. Breaks my fucking heart guys.

 

[georgie]

Holy fuck balls, you fucking geeks!

 

[old.user4556]

That's me !

 

[TdC]

lol well I wish you guys well. after normalization theory and some TSQL at l'école I promised myself I would never touch a database in anger.

 

[CorNokZ]

I just started SQL and I have no real idea where to start

 

[old.user4556]

I just started SQL and I have no real idea where to start

Well you'll be right at home with our Indian 'experts' then.

 

[Moriath]

I just work for Oracle i dont code their databases

 

[Raven]

I just started SQL and I have no real idea where to start

"SELECT"

 

[Moriath]

Select * from emp

 

[TdC]

It's actually a common problem on large or very busy tables. Either the index statistics get out of date so the engine can't accurately pick the correct one or a table with multiple indexes grows to a critical cardinality threshold and suddenly a different index is picked killing performance.

Hehe my DB design lecturer had answers for everything, and the app design guy was even worse (or better, I guess it's perspective). Usually along the lines of "redesign the application" or "your DSL does not translate into tables properly, do it again". Totes correct ofc. After a year of listening to them I formed the notion they'd never been exposed to a working companies IT environment, ever

 

[dysfunction]

I just work for Oracle i dont code their databases

I've been waiting for two years so far for two issues to be resolved by oracle service desk.

 

[Shagrat]

PETA, seriously what a bunch of annoying self righteous pricks.......

Monkey selfie: Photographer criticises Peta court appeal - BBC News

 

[Shagrat]

and I'm not getting into any SQL discussions, I'm still recovering from a "what do you mean you forgot to remove the DELETE * bit" breakdown I had a while ago with some dumbass running some code he'd "found"..

 

[Raven]

Silverstone weekend traffic.

 

[Scouse]

PETA, seriously what a bunch of annoying self righteous pricks.......

Monkey selfie: Photographer criticises Peta court appeal - BBC News

I agree completely. But at the same time I'm glad those pricks are around doing their ham-fisted things.

 

[Raven]

Coming home to find rabbit intestines and a leg on the middle of the living room rug.

 

[old.user4556]

rabbit intestines and a leg on the middle of the living room rug.

*unzip*