Consistent Data Presentation

Question

Post reply

Consistent Data Presentation

Dave62

SSCertifiable

Points: 7459
More actions
April 19, 2011 at 8:12 pm

#238805

Comments posted to this topic are about the item Consistent Data Presentation

Viewing 15 posts - 1 through 15 (of 31 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Just what I needed, a simple question with obviously correct answers

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Gobikannan SSCrazy Points: 2735 More actions · Answer 2

Simple and nice question.

-----------------
Gobikannan

UMG Developer SSChampion Points: 13482 More actions · Answer 3

Thanks for the question!

I am surprised at the number of wrong answers so far...

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 4

This was a bit easy 🙂

Find the answer by elimination...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 5

When I saw the newsletter, which presents only the question but not the answer options, I was afraid that this would be a debatable question, since many design best practices are more or less subjective and far from carved in stone.

Luckily, that was not the case. The author picked best and worse practices that were so obvious that I would have expected a correct answer rate of at least 90%.

The current rate is 82%. Obviously, even this basic knowledge is in dire need of reinforcement for 18% of the users of this site. Which makes this a good and valuable question.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

paul s-306273 SSChampion Points: 10727 More actions · Answer 6

Koen Verbeeck (4/19/2011)
This was a bit easy 🙂
Find the answer by elimination...

Yes, elimination is the key here.

I think there should be more questions like this...

M&M SSC-Insane Points: 21700 More actions · Answer 7

M&M

SSC-Insane

Points: 21700

April 20, 2011 at 2:36 am

#1313786

Nice to have questions like this 🙂

M&M

cengland0 SSCertifiable Points: 6102 More actions · Answer 8

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?

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 9

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?

Apparently, the 'Choose 2' hint is added automatically...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Brigadur SSCrazy Points: 2097 More actions · Answer 10

The link in the explanation (http://msdn.microsoft.com/en-us/library/ff647793.aspx) says:

"This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies."

Boy that hurt! :crying:

Am I a dinosaur? Sometimes talking to application developers, I feel I am.

Richard Warr SSCertifiable Points: 6963 More actions · Answer 11

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?

2% have selected that one though. It may not sound much but it means one in fifty businesses may be in trouble 😉

Dave62 SSCertifiable Points: 7459 More actions · Answer 12

The inspiration for this question came from: http://www.sqlservercentral.com/TotalScores

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.

I also learned something new from this question. For those who complain that the questions do not get reviewed by the editors, I can assure you that they indeed do get reviewed. This question had to be modified and resubmitted twice before getting published. I, for one, appreciate all the hard work that goes into making this site the valuable resource that it is to all of us.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 13

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.

Ah, so I'm not the only whose points don't match 😀

It is not necessarily a redundancy issue, if those points are calculated facts. But that means they are calculated twice, and one of them has an error in the calculation...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

tabinsc SSCommitted Points: 1812 More actions · Answer 14

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

Tony
------------------------------------
Are you suggesting coconuts migrate?