[proper domain design]

sure do. check out databasedebunkings

warning: "procedural programmers" will detest just about everything recommended there, claim it is all impractical theory, won't perform acceptably,is impossible in the real...

[[You'll have up to 8 bits to designate just "how" the data is missing. You certainly do NOT want to store 'TBD' | 'NA' | etc. in any column(s).]]

Oh well,...

I guess you missed the word "usually" in my previous post? I don't do anything in database design really "by default". Not sure how you read that into...

[[ non identity ]]

the relational term for that is "natural key".

I would never design a table structure without one. There ALWAYS is one, and if no-one can say what...

everything should be made as simple as possible, BUT no simpler.

yes agreed. if you want to persist the _reason_ why you have no data, well sure, that is fine. but that is not a null, that is valid information. ...

well actually it does get rid of nulls. Because you are no longer persisting nulls in the database.

Sure sometimes information will not be known. And output...

it's actually pretty easy to work with an absolute ban.

You just take any column where you would otherwise need nulls, and make a related table for it and voila'.

No...

there is another very negative consequence of allowing nulls. It is a different kind of performance problem, but a very real one in my experience. You may call...

I've advocated for years that many of our metrics for data quality should be based on statistical analysis rather than brute force counting of every single value in every single...

[ instead, it'll check for 9999-12-31 and the other "don't know" values! Crazy]]

Not necessary at all.

Simply create a view that either eliminates rows with nulls using a where clause as...

I feel there are a number of good options.

1. Personally, I feed magic numbers are STILL preferable over nulls. BUT I don't recommend them typically. ("default" value input by...

very simple solution to all the nonsense.

MAKE ALL COLUMNS NOT NULLABLE.

If you can't figure out how to design a schema where that works for your business requirements, you can...

mister_zed (9/12/2014)

---

kenambrose (9/11/2014)

---

I can't recall a single environment in the past 10 years I have worked in that allowed OPENQUERY. It was always considered a no no due...

I can't recall a single environment in the past 10 years I have worked in that allowed OPENQUERY. It was always considered a no no due to security...