Posted by pb648174 on 09/29/00 11:42

Just out of curiosity, lets say we are told that only a basic
description of something is needed, let's say a list of projects that a

user is going to work on, that needs to be 500 characters long. What
should the primary key be? Is it the 500 character description or an
identity column? Are there performance issues with having 500 character

foreign keys, indexes, etc.? In what ways is it going to be better than

using an identity column taking into account that it is going to be
passed through the QueryString, posted in links, etc.?

[Back to original message]