Roy Ernest (6/30/2009)

---

So I assumed, and was apparently incorrect in that. (I hope this wasn't obfuscatory. I'm trying to be as precise as possible here, and am now assuming singular...

No more waiting required. Let me know if...

Sorry about that. I'm just used to things like this:

ya.. that...

Use Excel. Export it to text files, and use the XML file format to tell OpenRowset what the column definitions are and how many rows to skip at the...

It'll mean that, if the data every grows beyond the size of the allocated files, you'll get errors. Not having autogrow on is what will cause that. What...

That's accurate. More grammatically correct would be, "Column 'has_passed' is transitively dependent on columns 'student_id', and 'subject_id' via column 'marks'." (I'm assuming from the posts that English is...

"Disaster" is always subjective.

Nah. If the default is overriding the character set, setting the collation for the select won't fix that.

I like the idea of an XML structure for commenting. Never thought of that myself, and haven't run into it as a practice.

Where documentation standards have been set for...

So far, yes. I still plan to turn it into a t-shirt.

jcrawf02 (6/29/2009)

---

GSquared (6/29/2009)

---

Another advantage, off-topic, to a Names table, is that you can have a NameEquivalences table that records, by whatever means, the fact that "Johnathon" is the same as...

Try this:

select hmss.employee_code

from dw_historical_monthly_salesman_sales as hmss, sales_contests sc

where sc.contest_id = 11 and

hmss.commission_month between '5-1-09' and '6-30-09'

group by hmss.employee_code

having count(*) > 1

That'll at least tell you which...

GilaMonster (6/29/2009)

---

jcrawf02 (6/29/2009)

---

GSquared (6/29/2009)

---

I have a Dilbert strip, the XKCD about Little Bobby Tables (search that if you don't know it, required reading for DBAs), a picture of Darth Vader...

Reading leads to learning. Learning leads to knowledge. Knowledge leads to power. Power corrupts!

Lynn Pettis (6/29/2009)

---

If I remember the Modeling class at the TDWI conference a couple of years ago, 6NF is used to eliminate nulls being stored in a database. Also...