Being slightly pedantic I think the question:

is wrong and not a reflection on the spirit of the article, more correctly...

Manual being depricated in favour of automatic? Never! - I can only think of one person with an automatic and again that was due to disability.  In fact I have...

Rip out all that computer equipment which drains power, and you could get an extra 10mpg I reckon It is an interesting concept,...

All interesting stuff, but difficult to really tell due to hardware differences.  e.g. anyone who has a v.fast temp table setup (i.e. maybe on a many spindle RAID 0 or even...

Erm, I am assuming the article is incomplete, or written incorrectly.  It states initially that the batched zipcode field update takes 20 hours, it does not state that this was...

Will get around to checking a few of these ideas later in the week - mainly becuase the request for a clustered index on the date field but the DB...

Indexes being rebuilt, with clustered on the time - will have performance info in a bit

Nope that is is exactly the same performance (as stated in in my original post - had already tried this with joins) although I did run your version just in...

See now here is where I miss the point, why oh why are you using the time that has been set aside for learning and development (i.e. at a code...

An interesting and ever increasing problem with a lot of Face:Face meetings these days, there is an argument (here playing the devils advocate) that the success of sites like...

Out of interest, being a native of the SQL server's new country, why the move to the UK? Have we better hosting here????

The ***** part of the ELSE was two SELECT statements

* EDIT * Just noticed the original poster has a split function!  so I guess you can ignore the next paragraph!

All good and well  Robert, and am in agreement with...

Please note as well as an IT Pro, I am also a semi pro Photographer (may explain storage patterns!)

Main machine:

• 36GB SCSI Primary OS
• 36GB SCSI Swap (OS & PS)
• 250GB RAID 1...

Playing devils advocate, even if it is out of stock they may forward order it if saved in basket