nason.peter (4/8/2015)

---

To address the point of the question, it is interesting/important to note that the same rules apply to database, schema and column names so you could in fact have...

I guess that I've been lucky. We made a decision that all of our clients have the identical schema even if there were tables that they were never likely...

Good one Wayne.

A large organization that I attended installed a new HVAC system. The thermostats were replaced by sensors and the system centrally controlled. People started complaining that...

The point of the tiny fact table and foreign key is that to add new items is an INSERT. To change the check constraint you must drop the old...

Phil Factor (4/2/2015)

---

However, Check Constraints are always important, and I cringe to see tables without them, just because I've witnessed, and sometimes experienced, many disasters caused by bad data getting...

I always said our old sys admin was a crank.

Hey, I have bit-switched in my share of code on IBM as well. I hated and loved the old 1130....

I get what you are saying.

The name of a thing should match what it does and a thing should...

I get the one dimension table used in a foreign key constraint and having it in a table rather than "in the code". There is no ALTER CONSTRAINT (IIRC)...

TomThomson (3/27/2015)

---

The JavaScript ghat I've seen uses type VAR for...

Order by column number? Initially my application did not order the results in any way. My beta team complained that when looking at a list of 150 or...

I'm working on a tool to help with this right now. First release is targeted for April.

See! No fat on these bones!

The poor admin is short-sighted. Some day it will bite him in the asterisk.

This a difference between misdemeanors and felonies. Surveillance footage can be used against someone breaking into a building but not used if someone is urinating on the building. ...

Eric while that seems perfectly reasonable to me I have been told differently. I am not a lawyer what I have heard is that this is so ingrained in...

Here in the central U.S. we are going through an interesting time with public data vs private data. But this data is not in a computer system per se.

We...