A few steps better, split - set based static sql :

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit null,...

Indexing strategy is impossible to do without knowing what queries are run on the server and their frequncy/execution plan... you should really look into hireing a dba or consultant if...

Which columns were in the primary key (in the same order)?

All I need is the average width of the columns in the index.

BTW, all indexes keep a refference to the clustered index so even if you don't include it explicitly,...

How large is the clusered index (average size of one row of the index). How many non clustered indexes do you have (you know that they keep a refference...

BTW 2 refferences on 18 posts is harldy being called everywhere.

Back to life now .

My account / My forum subsriptions / delete .

I said I had to browse while waiting your reply to my reply... that's all.

I have a life, I'm playing with the nefew while answering this. But come to think of it this is all your fault... I had to browse the forum while...

Check the books online... it's buried somewhere in the datetime datatypes !!!

Yeah yeah, back to my vacations .

If anyone's offering me a ticket I might be interested .

That was just my first week of vacation... got 1 more left before really comming back. Then I got another 2 weeks at xmas but that's too far out...

Ya me too ...

That's probabely what tipped off my informess (who doesn't want to be named) .

Or from today's article of 2003 :

Finding and Deleting Duplicate Data