June 17, 2009 at 6:56 am
tony.sawyer (6/17/2009)
Paul White (6/17/2009)
It might pay those bemoaning the quality of the question to submit a better one...?
Ooh theres a challenge... Where do we send them? 🙂
Hey Tony,
http://qa.sqlservercentral.com/Contributions/New/Question
There is a link on the QOD page, but it isn't very noticable...
Have fun! I look forward to trying your question 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 17, 2009 at 6:58 am
David Burrows (6/17/2009)
I don't think it was sloppy at all.Don't be put off by the bemoaning of the few. 🙂
Some QOTD have suffered with the answers but I think that if they are corrected/enhanced then all for the good, they stir up a good debate. We are all here the learn (well I am anyway).
Right with you on that David! :w00t:
To be fair, it wasn't the best question of the year...:-D...but then again maybe it was - for the debate that ensued.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 17, 2009 at 7:00 am
It certainly wasn't worse than some of mine. It's hard to write a good question and consider all the angles.
VM has tried, though, and submitted a dozen or so that will come out over the next few months. I think there are some good ones in there.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 17, 2009 at 7:02 am
Paul White (6/17/2009)
Hey Tony,
http://qa.sqlservercentral.com/Contributions/New/Question
There is a link on the QOD page, but it isn't very noticable...
Have fun! I look forward to trying your question 🙂
Erm - is there a link that we don't have to install an ActiveX control - my network admin isn't keen on that sort of thing...
June 17, 2009 at 7:02 am
Paul White (6/17/2009)
It might pay those bemoaning the quality of the question to submit a better one...?😎
Heh heh! Good point, Paul!
Since I already did submit a few questions some time ago (and got the flak I deserved for my share of sloppiness), I know first-hand how hard it is to foresee everything. No matter how hard you try to make the question as unambiguous and clear as possible, the number of people visiting this site is so high that some of them are bound to be more imaginative!
June 17, 2009 at 7:08 am
tony.sawyer (6/17/2009)
Erm - is there a link that we don't have to install an ActiveX control - my network admin isn't keen on that sort of thing...
Not to my knowledge. Steve has just posted so he might notice your question and reply.
It's not a very dangerous piece of software - try submitting from home...?
😀
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 17, 2009 at 7:10 am
Hugo,
Just for the record, I include myself in the set of members who should submit a question!
Scary!
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
June 17, 2009 at 7:14 am
I love good thick porkchops:-D
June 17, 2009 at 8:39 am
WOW! I'm waiting for questions from you guys!:-)
June 17, 2009 at 8:50 am
tony.sawyer (6/17/2009)
Erm - is there a link that we don't have to install an ActiveX control - my network admin isn't keen on that sort of thing...
No, we don't have one. The ActiveX is the XStandard editor, fairly well known in the world. You can check them out.
If you'd like to just email one, send it to articles at sqlservercentral dot com
and include a question, 2-6 answers, mark the correct one(s), and include an explanation with a URL that backs it up.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 2, 2009 at 12:25 am
For my case, I ll vote t char(1), as I am not dealing with any UNICODE data. Hence, space is more important to me rather tha flexibility.
July 2, 2009 at 12:29 am
good for you, when you make an assumption you make an A$$ out of who and who?
not me-- I choose NCHAR or NVARCHAR, because it's not fair to take your assumptions and shove them into your code.
design to spec-- if it's not specified, plan for the worst or ask for clarification.
who is to tell me which country the question-asker was in?
If I knew that-- then I would know the answer, most likely.
But still-- it's not fair to assume anything ever.
July 6, 2009 at 12:56 pm
varchar(1) is definitely wrong because it adds an overhead to the table
July 9, 2009 at 10:31 am
if you have ever worked with localization, the answer is clearly nchar(1)...
July 14, 2009 at 3:04 pm
dblanchard (7/9/2009)
if you have ever worked with localization, the answer is clearly nchar(1)...
Im with you there...nchar(1).
No character set was specified....so I have to choose unicode to handle all possibilities.
one character is not synonymous with one byte so I'm STILL using unicode
Cannot be null or emptystring......so no need to choose a variable length datatype.
nchar(1) is the most correct answer IMHO so thats what i chose. I lobby for the answer to be changed.
Viewing 15 posts - 151 through 165 (of 182 total)
You must be logged in to reply to this topic. Login to reply