Any question answered...

In Greece we had rather large red hornets (called Babura I think- spelling bound to be wrong), they had such a fearsome rep that people tended to leave them to it.

Babura would be a correct pronunciation, it's actually spelt mpampoura or μπάμπουρα. That however, would be a bumblebee.

The hornets you are referring to are indeed the ones Oliver mentioned:

Could be the Oriental Hornet?

http://en.wikipedia.org/wiki/Oriental_hornet

We call them σφήκα or sfika (which is the same word for your common wasp).

The hornet is actually called μεγάλη σφήκα (big wasp). :)

Yeah CRC are fine with refunds and use Collect+ or whatever they call it so you don't even pay.

The rolls and turbo saddles look quite similar, would they also feel similar or is one slightly wider?

Rolls is wider. I hated the turbo, felt like a knife up ya cracker.

Heh, well it was my ex-girlfriend who got it wrong, and she was/is Greek.

She's a mental though, so I am willing to believe that she got the name wrong.

Cheers, I reckon I'll try a rolls then.

Greece. Full of bees, wasps, hornets, and mentals.

I'm never going back. I know too much.

which is the best thread to ask SQL questions?

<<<<<<<< AQA thread >>>>>>>>>

ok....anyone got any tips on improving speed of reports? asked google, tried some things, still cant figure it out.

Does when a join is created in the order of statements make a difference (provided it works) to speed?

Sram Apex BB squeak!

It's on the drive-side.
I've re-fitted (re-greased and re-torqued).
It vanishes for about 50km if I squirt GT85 between the crankarm and spindle – so I guess it's the rubber seals making the sound?

Spray the seals with aerosol degreaser, squirt in 'wet' spec chain lube. Leave the bike on it's side over night and bingo. 300km of no noise.

Any question answer-it-yourself thread >>>>>

Regal - if the reinstall doesn't fix it sounds like a library issue.

• Delete Audacity App and its related files found in your ~/Library
  
• Run Disk utility and repair permissions
  
• then reinstall Audacity
  
• Run Disk utility and repair permissions Again
  
  

Should work. If not your codecs need to be reinstalled which is probably unlikely but you may have to. this will be at the root level of your Mac under your /Library and system/Library.

ok....anyone got any tips on improving speed of reports? asked google, tried some things, still cant figure it out.

Does when a join is created in the order of statements make a difference (provided it works) to speed?

1. Which DBMS?
   1A. If MS SQL, they have tools which can both predict the execution plan and tools which monitor active servers.
   1B. If MySQL/MariaDB, InnoDB or MyISAM?
   
2. Are you joining on indexes/PKs?
   

My brother is looking to get a bike from Ribble using their bike builder, but can't work out whether to spend more on a frame or the groupset, and is looking for advice, so if you had a choice between;

Carbon frame with 105 on
or
Alu frame with Athena\Ultegra

Which would you go for and why?

This will be used for all weather relatively short (50 miles) rides

Frame.

The components can be upgraded any time, the frame is the most important bit.

^This

Anyone having trouble with Ebay UK? It wouldn't load earlier and when I did get on, a couple of bikes I was watching have completely disappeared, not "ended".

It's not local to me: I sent links to a friend and she can't see them either.

Now I can't get it to load again.

http://www.isitdownrightnow.com/ebay.co.uk.html

Curious! I can find the ads if I search, but can't access them: it just takes you to a "items similar to xxx" page.

Easy to use, there's not many buttons to mess with.
Plugging it into your computer, it just detects it as a drive.

Quality is ok, you can make out plates and faces.
I used it for snowboarding and watched it vs. a go pro and got sad as it's (obviously) not as good.
The problem is mounting the thing and getting the angles right. I got the sports pack but broke the mount too easily. Haven't fiddled around with it much, I forgot about it to be honest. Might take it out tomorrow...

Maybe this might help ?

They're ok. Not amazing. But you'd probably get a number plate off it. This is representative:

It pretty much only has one button. You just have to remember which colour LED means it's on/ready and which colour means it's recording.

Edit: I am being very old and slow today.

Thanks both

Anyone having trouble with Ebay UK? It wouldn't load earlier and when I did get on, a couple of bikes I was watching have completely disappeared, not "ended".

It's not local to me: I sent links to a friend and she can't see them either.

Now I can't get it to load again.

Yes - had trouble getting to a page linked in the watch thread about 30mins ago - would either time out or take me to the ebay.co.uk homepage

I'm listening to my ipod, which is on shuffle by song. It's started not shuffling properly - just now it played 9 Liars songs in a row. I haven't changed any settings or anything, what the heck is going on? I don't like this weirdly sentient machine.

well if all you have on there is the Liars discography, that isn't strange.

I have 4 Liars albums on this ipod but have lots of other music too. Smartarse :)

Depends on settings / age of iTunes/iPod. It's entirely possible that random selection gives you 9 Liars tracks in a row, but because users sometimes found this 'un-random', they implemented a control that adjusted how likely it is that it will choose a track from the same artist or album after the current one. Then they removed that option in a later update. Sorry. :)

https://discussions.apple.com/thread/2521700?start=0&tstart=0

Basically: it is random, it's your brain that sees a pattern.