cengland0 (4/20/2011)

---

I was wondering how you could have an "All of the above" option with a "Choose Two" directive. Let's say, for instance, that all of them were correct. You would select the "All of the above" option and which other one?

Dave62 (4/20/2011)

---

The inspiration for this question came from:

...


The number of Points (won) - 599 - for me near the top of the Question of the Day Breakdown table does not match my Score - 603 - at the bottom of the Question of the Day table. I have no idea why they differ. It may have nothing to do with the answers in this question. But it did get me thinking about designing for data consistency so I thought I'd submit the question.

tabinsc (4/20/2011)

---

I would argue that sometimes you may have redundant data in your database to make reporting easier and faster.

tabinsc (4/20/2011)

---

I would argue that sometimes you may have redundant data in your database to make reporting easier and faster.

tabinsc (4/20/2011)

---

I haven't proven this correct yet, but I am thinking redundant data in two tables makes sense if you need that data to join the tables properly and avoid table/index scans in the execution plan. You could create indexes on the redundant columns to force index seeks on both tables.