It sounds like this reporting / EDI server is perhaps just a snapshot of a production OLTP database and serving the purpose of an Operational Data Store (ODS). The query...

keymoo (6/27/2011)

---

I have a super table called Instrument. I have a sub-type table called BondInstrument. Relationship is one-one. PK is a column called InstrumentId.

I also have a table called InstrumentEvent...

The database developer really should be a SYSADMIN in the development environment, or at least have permission to VIEW SERVER STATE, ALTER TRACE, and SHOWPLAN permission. At the very least,...

The good news is that:

#1 30,000 rows is not a lot of data.

#2 Dropping a column is not a change of data operation, meaning that the column is marked as...

Perry Whittle (7/4/2011)

---

don't give out SA privileges 😀

I ask them to explain why they need SA, when they can't give a valid reason i use that as my push...

I think the issue should be wether a corporation's trade actually enables a corrupt government; not simply wether the government is corrupt in general.

Microsoft and Google enable citizens...

Information technology is like a slow poison to a totalitarian government, because it allows information to flow in and out of the system. Even if the government tries to bend...

I think there is a difference between conducting a simple business transaction with a suspect individual or government (ex: I give you 1,000 licenses of MS Office and you pay...

James Goodwin (7/1/2011)

...

Regarding Nulls, I haven't followed the theoretical literature enough to notice that there is a raging debate here, but from a practical standpoint I have noticed that people...

I once interviewed for one of the big national auto insurance providers. Part of the interview process (which lasted all day and mostly involved me sitting and waiting in a...

Tom, I think that overall this is a good primer on first normal form. You brought up the point that what constitutes an atomic value depends on the context with...

SanDroid (6/30/2011)

---

Eric M Russell (6/30/2011)

---

SanDroid (6/30/2011)

---

Eric M Russell (6/30/2011)

---

I never contain phone or address related columns in something like the primary customer table.

#1 An address or phone number isn't...

SanDroid (6/30/2011)

---

Eric M Russell (6/30/2011)

---

I never contain phone or address related columns in something like the primary customer table.

#1 An address or phone number isn't an attribute or measure...

I never contain phone or address related columns in something like the primary customer table.

#1 An address or phone number isn't an attribute or measure of the customer; the...

OK, here's a flippant comment so you can ignore this... when does a candidate key ever get promoted from candidate to the spot light? After all, even a Candidate for...