nvogel
  • Member for 11 years, 3 months
  • Last seen more than a month ago
Is there a canonical source supporting "all-surrogates"?
Accepted answer
9 votes

"All PKs are surrogates" is not a very sound strategy at all and certainly not one that you are ever likely to find an "authoritative" source for. Firstly think about what is meant by "primary key" ...

View answer
Problems in coordination between software and database teams
7 votes

Make database specialists part of the team rather than separate them. Database developers / development DBAs don't have to be full time on every project but they absolutely should be part of the team, ...

View answer
Why not expose a primary key
3 votes

For most applications it's pretty much essential that you DO expose keys to users. To use an information system effectively the users of that system will normally need a way to identify the ...

View answer
Is there value denoting a key as "Primary"?
Accepted answer
3 votes

Logically and practically speaking there are really no "primary" keys in the relational model [1] because all candidate keys can and do have exactly the same status, features and function in the ...

View answer
How could RDBMSes be considered a fad?
3 votes

The problem is that many developers wrongly equate RDBMS with SQL. SQL is a truly awful language by modern standards. It is a flawed and incomplete implementation of a "relational" language (SQL isn't ...

View answer
How will you handle NULL values in your application?
3 votes

This is one of the problems with nulls. Whenever the database developer puts them into the database the application developer has to take them out again. Very often the best policy is to avoid or ...

View answer
Using auto-increment clustered key and guid primary key together
1 votes

It is not unusual to have several keys in a table and there's nothing fundamentally wrong with that. If a table has more than one key then the choice of "primary" key is unimportant - or only as ...

View answer