I realised it was a non clustered index, I was just surprised that with only three records per page (row size is 2.3k) and a clustered index on the same...

I agree, I just wondered why it suggested it.

Thanks!

Thanks for all the replies,

I will give the sub-query method a go.

Grant I will try and hunt down a copy of your article, thanks for the tip.

just noticed I'm in the wrong section, reposted in the 2005 T-SQL, mods please delete.