Thanks..

Really saved me alot of hassle on this one.

Thanks you've saved me alot of time and fragmentation.

In my situation the DB has received a huge data import, several years of data its now going to grow much slower...

Thanks guys

There is no external table (tblcustomer), the current data is correct, where the same value appears in field ID more than once the customer name is the same in...

Sorry for confusion, hope this explains it better

Have a table with an ID field which is not part of the PK.

ID always contains a value about 97% unique.

I want to...

Thanks for that, I had misunderstood.

I need to store just date no time part.

Converting to int 20091023 wouldn't even be beneficial.

Wanted to double check.

Non clustered index will use a clustered index if exists, so important clustered index field(s) has to be small.

I wonder if sp_spaceused is reporting clustered index...