![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
select * from idea where quality = 'good'
When your DBA moves a database, it's a good idea to make sure all the tables still have their primary keys. I discovered this week that Oracle and SQL Server both enable you to move tables while leaving indexes behind.
It may be a sign of a strong framework when your software operates more or less successfully even when 75% of your tables lack proper unique constraints.
It may be a sign of good luck when this sort of thing only happens to (a) training databases and (b) production databases deployed in a situation in which data loss is not a big deal.
It may be a sign of a strong framework when your software operates more or less successfully even when 75% of your tables lack proper unique constraints.
It may be a sign of good luck when this sort of thing only happens to (a) training databases and (b) production databases deployed in a situation in which data loss is not a big deal.