Currently got enough Finish Line left for one SPD 🙁
Must admit I’ve used that for a while and had no issues, previously used “Black Gold” (way back in the 90’s, try getting that out of your white shell suit) and Pace luminous green stuff (like a stick and more visible “Smart Water”), and thought by now science would have come up with the ultimate re-grease-one-a-millennium compound. Maybe they have and maybe its just vaseline 😉

What everyone else says – exercise, mental stimulation, and can be quite nervous. Ours is 4, had her from being weeks old. Here’s a few photos.. We got a short-hair but she still moults like hell!!!

http://www.google.co.uk/search?q=montane+velo&tbm=shop&hl=en&oq=montane+velo&gs_l=products-cc.1.0.0l5.5927.10520.0.11608.12.10.0.2.2.0.192.1161.3j7.10.0…0.0…1ac.1.OTQzDAuNGLM#q=montane+velo&sa=X&hl=en&tbs=p_ord:p,vw:l&tbm=shop&ei=maWSUZ6uDqyA0AXsqIDwDA&ved=0CE4QvQ0&bav=on.2,or.r_cp.&bvm=bv.46471029,d.d2k&fp=d10ac520ea7951f6&biw=1280&bih=800

I think we need a “code” button on here….

As per leffeboy’s comments, also get rid of any multiple function calls doing the same thing and replace with constants or variables i.e:
CONVERT(DATETIME, ‘2012-01-01 00:00:00’, 102) AND CONVERT(DATETIME, ‘2012-12-31 00:00:00’, 102))
to
DECLARE @Start DATETIME = CONVERT(DATETIME, ‘2012-01-01 00:00:00’, 102)
DECLARE @End DATETIME = CONVERT(DATETIME, ‘2012-12-31 00:00:00’, 102)
….. cog_invoicedate BETWEEN @Start and @End

You could break the query into smaller chunks and insert into table variables or CTE’s, also analyse the query execution plan for poor performing steps (doing it against your large query wold be a pita) and this will give you some hints on missing indexes.

Importantly, (again stealing leffeboys thunder a little) run the SQL profiler and/or index tuning wizard to identify columns should be indexed (you should probably do at least those you join on and in a WHERE clause); this will give you the biggest benefit as it will do the work for you and in 99% of cases will give you a marked improvement.

Last but not least you could hire someone to re-write it for you and improve performance (email in profile, payment in cash, bike bits, or biscuits)!

Mailed you, lt me know if it arrives.

http://www.salesforce.com/uk/

Motorola motoactiv mp3/gps for £99 if you can still find one.

I posted the best offer I could find (at PC World) in this post yesterday, http://singletrackworld.com/forum/topic/psa-samsung-galaxy-note-101-tablet-16gb-wi-fi

Pcworld will pricematch a numbers of websites + 10% of the difference, and also have a deal to get £30 cashback if you buy a case with the tablet, this means you can buy a ten quid case and get a total of £80 cashback. Works out as around £150 for a tab and £240 for a note. Beware though, there are time limits on when you can apply for the casback!

http://www.bikeradar.com/gear/category/bikes/mountain/product/review-boardman-mtb-ht-pro-carbon-11-45015

3 tyres per bottle, but if it lasts that long who cares? I’d be interested in seeing any reviews as they surface (apparently the stuff is quite new which probably means stans again for me)

Anyone seen this Fenwicks one – apparently it sets to a gel and last for 3 years rather than 6 moths?

http://www.mcconveycycles.com/store/product/16056/fenwicks-airtight-tubless-tyre-sealant-500ml/

I am running non-tubeless tyres, racing ralphs on stans crests with just yellow tape. I found stans seals them easily when fitting so would assume it does the same when punturing, and not having a flat last year i kind of assumed it was doing its job or i had been very lucky.

It truly does take the p#ss, if your going to force someone to do a “training course” as part of their contract of getting JSA, make it a course where they gain some skills, confidence, and personal respect, dont make them work with other people getting paid a fair wage to do the same job. Being unemployed is humiliating enough without being humiliated as well.

If you give firms the opportunity to employ people at lower than market cost (NMW) of course some ae going to take advantage.

Does his laptop have publisher installed and what is the font name?

No, just putting you straight on your #### talking.

Better edit that before I get banned, wouldnt have anything to do in my IT job all day then 😉

Ask menothim to make your powerpoint, he is an IT guru:
http://singletrackworld.com/forum/topic/it-departments-are-little-short-of-a-ponzi-scheme-discuss

IT project that run over budget and aren’t delivered on time tend to be managed by people who think they know about IT after being in the business 2 minutes, or getting into te business from another area of management and thinking IT is an easy ride, or needing to know a little about IT to get something done (from your earlier posts in the links above that seems to be you).

I cant tell whether your being sarcastic or just generally dont have a clue but you probably dont ride a bike either, just hang about here because you wish you could ride a bike as well as you do IT.

comparison sites – confused, gocompare, moneysupermarket, comparethemarket, also cashback sites like quidco, topcashback, etc also offer additional offers if you sign up. It costs insurance sites about £40 a pop for each customer they get through comparison websites though so also try the cheapest results from compare sites directly.

Thanks guys, waiting for a an autodiagnstics check (not by a main dealer!!) but misfires, cuts out, dashboard lights going nuts, clock going nuts, rev counter ans speedo flicking up and down randomly, dash light staying on when I turn the ignition off and pull the key out. Driving home the other night and there was a smell of electrical burning, then it all started kicking off, luckily I managed to get it home. I am hoping its something inexpensive like an electrical short somewhere but from what I’ve read it looks like the ECU.

topic around sealskinz here:
http://singletrackworld.com/forum/topic/sealskinz-socks-2

Make sure you try all the price comparison sites (confused, gocompare, moneysupermarket, beat that quote, etc) as some have deals with insurers where they are guaranteed to be the cheapest site, also try cashback sites like quidco as you can get cash back deals to save more by signing up. Its generally cheaper to insure the female driver as the main policy holder and the male partner as a named driver.

A large roll of MTFU should do the trick.

£16 for socks that leak after a while vs £100 for boots that leak after a while,, hmmmm….. seems like a no-brainer. They’ll be worn mostly for walkin’ the poooch in wet conditions so shouldnt be going deep enough for water to go over the tops. Thanks for the good advice guys!

I’ve found SealSkinz gloves a bit crap, hence my question about the socks before purchasing.

If Chuck Norris had a mountain bike it would be made from bits of van damme and segal.

Buy the right running shoes – visit a proper running shop or physio with some form of gait analysis, the money spent will be well worth it.

2 local bikeshops to try – bikescene in Guisborough and westbrooks in Stokesley.

I’ve got crests with schwalbe (non tubeless tyres) and they lost quite a bit of air at first.
I installed the rim tape & tubeless valves, pumped them up to about 60psi until the bead pinged on, put the stans juice in, shook it about a bit, let some air out so the tyres were quite soft and went for a bit of a ride (as mathew h describes), then I layed the wheels flat on a bucket, pumping up, shaking and rotating over a weekend until the juice had penetrated the porous sidewalls.

I’ve got some 2010 crosstrails sat in the garage doing nothing if your interested. For sale or would consider swapping for something interesting (outdoor gear, biking gear, etc).

http://www.singletrackworld.com/forum/topic/mavic-crosstrail-2010-extras-1

Email in profile.

Hursty – sent you a couple of emails lately, dont know if you got them?

car drivers need to be told.

I am sure all the car drivers in the world will join STW just to read this post and immediately change the way they drive; wow, thats great work for a sunday, you’ve changed the world.

If your working at Wilton and are looking to do a lot of riding I would recommend Guisborough – theres some decent riding at Guisborough woods and surrounding areas (eston hills, north yorkshire moors, carlton, swainby, osmotherly, etc) and its pretty close to Wilton especially if you plan to cycle to work (you could go via Wilton Lane which brings you right out at Wilton International).

If your only going to do the occasional bit of cycling your probably better going for Yarm, Ingleby Barwick (a bit of a traffic nightmare though), Norton, Stockton and travelling a few miles if you want to do some cycling.

Stokesly and Guisborough are probably a little higher rental cost as they’re small towns but try Robinsons, whitegates, browns, property angels, for lettings and try to get hold of a copy of the Thursday night evening gazette as that has a housing section with some decent letting section.

Who you going to work for (just out of interest)?

http://www.bikeradar.com/gear/category/accessories/gadgets/product/review-mad-catz-airdrives-fit-interactive-stereo-earphones-11-44716

Take photographs of the bike, please please please please pleeeeaaaaaase take photographs of the bike and save yourself some hassle. Better still take a photograph of yourself with/on the bike so your in the photo. Even better take photographs of yourself on the bike outside your home where the bike is insured.

Hot as f##k, and I dont mean its looks.

Looks more like a slim fast advert

Has it got grinder on it? maybe thats why it hasnt rang!