Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-04 : 19:57:57
|
| Steve writes "I was wondering what your take is on Identity fields? I have read a bit about them and use them in my work, but I know Joe Celko does not like them for a variety of reasons.I never use them as clustered indexes, but occasionally use them as primary keys. To me, there are lots of cases where I do not have a strong primary key, like a list of employees. In this case, we use an identity field as the PK which I feel is essentially a hash of the employee. This also becomes the employee number and has no other meaning other than a unique numeric for each employee.I appreciate your taking the time to put down some thoughts and thanks in advance.Steve" |
|
|
|
|
|
Intelligent vs. Surrogate Keys