• Fatal Exception Error (3/5/2010)


    Chad Crawford (3/4/2010)


    BTW - I thought of a few more assumptions that should have been included:

    --Assume you are in the database containing tblUsers

    --Assume you have been granted rights to select from tblUsers

    --Assume the server has available memory

    --Assume there is "sufficient" (whatever that means) disk space on the drive containing tempdb

    --Assume the server room has available power (line or generator)

    --Assume the server is plugged in

    --Assume the server is on

    --Assume the hippo is asleep

    Thanks for trivializing a legitimate gripe despite what you believe.

    The fact of the matter is any of the answers presented would have been correct given a certain set of assumptions. There were really no wrong answers.

    Please go ahead and continue mocking me and others that feel the same as I do by posting an asinine list of assumptions. It is not like other QOTD's never included Create Table or Insert statements.

    I deeply apologize. Although it was partially an attempt at humor, it was not my intent to mock you or anyone who is frustrated with the QOD.

    My intent was to point out that there is a long list of potential assumptions for any QOD and any QOD submitter, being human, is likely to forget one or more that are applicable to their question. Yes, other QODs have included create table and insert statements, but in the 5 or so years I've been answering the QOD, I remember very few that went to that level. Maybe they should have. We (speaking of everyone frequenting SSC, not any select group) are all professionals, but there are probably very few who are professional question writers. I dare say that most of the QODs were written by someone who in the course of their normal work (whether it be DBAdmin, DBArchitecth, DBDeveloper, DB%, or even "not like '%DB%' ") found something odd or new and thought, "Hey, I'll bet no one knows this, it would make a great question". Because this is a community effort, very few QODs are written by people well versed in the art of testing and question writing. It's a community effort and that shows from time to time.

    Yes, the items at the end of my list were ridiculous in nature. But the ones at the top were not. If the question were to really show the reasonable assumptions to answer the question, indicating that the user has permissions should definitely be one of them, but only one post in this discussion brought that out. Why? Because I'll wager that almost everyone assumed that was an unspoken assumption. That’s what I hoped to bring out with my list - there is a long list of assumptions that we work with all the time. Given that each of the answers had legitimate claim to be right forces one to step back and think, "What was the original intent of this question - what are they trying to test?" You may feel that there is a little luck involved there, but even recognizing that each of the answers is potentially correct shows that you have a level of knowledge greater than most, and you can take pride in that. If it's the points you need - there are about a half dozen different ways to guarantee you get the QOD right every time, and I'd be happy to share if you want some (I use two regularly - I allow myself to Google/BOL before answering and sometimes I'll read the discussion before answering if there is something I'm not clear on, but I'll already have my decision made based on what I expect to find before looking. Neither of those guarantees success, but there are two other techniques that do).