Identity and uniqueIdentifier and custom id

  • The PK (Primary Key) has nothing to do with a clustered or nonclustered index. It is a logical structure that gives you a field to uniquely identify a row. It can be a clustered or non-clustered index in its implementation, but they are not the same.

    You rebuild a clustered index to deal with fragmentation periodically. You don't need to mess with the primary key, the identity field, or anything else. You just specify the ALTER INDEX REBUILD commands.

  • Thanks, well if I get 1000's of users, I will hire some one to advise me... until I am there ...thanks for your help !!

    Signing off

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply