Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1011121314»»

Sort Order - Include Null al last Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2008 3:40 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 19, 2010 6:47 AM
Points: 100, Visits: 130
Ok, I think next QotD could be "how to write a query to increase the scores of those who (correctly) answered just 2 to today's QotD?"
Post #523118
Posted Wednesday, June 25, 2008 4:18 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 2, 2013 12:15 PM
Points: 1,443, Visits: 711
I know I picked the 2nd one too....
Post #523142
Posted Wednesday, June 25, 2008 5:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, February 9, 2009 7:44 PM
Points: 282, Visits: 37
Extremely poor. I had ticked the second one and got it wrong when it's clearly right, as demonstrated in this thread.
Post #523191
Posted Wednesday, June 25, 2008 6:34 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:50 PM
Points: 1,688, Visits: 2,271
A.) No judgement was made, was just posing a question.

B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why what may or may not take place could be a reasonable choice? One might as well say that supporting a QoTD feature is just too much trouble - to which I will respond that anyone having sufficient experience in a forum environment to justify getting seriously involved in supporting one in any fashion, ought to know what's involved AS WELL AS what's expected long before beginning, and be capable of brushing off any negative press and moving on without a hitch. What you're suggesting says that such a person shouldn't or couldn't be expected to behave in that kind of PROFESSIONAL manner, and I beg to differ. The simple fact is that getting it right IS sometimes the most important thing - especially when you have perhaps thousands of folks relying on you to do so. Whenever a website shows any consistent signs of not being reliable, it's reputation suffers significantly, and most folks know this and thus make their voices loud in order that they be heard and responded to, so as to help avoid the loss they might incur if said site suddenly became less available or otherwise impaired by reputation. Make sense?

Steve
(aka smunson)
:):):)

P.S. It's because we care !!!
majorbloodnock (6/25/2008)
smunson (6/24/2008)
If their reaction is that childish, then where's the professionalism associated with publishing a website of this caliber? You can't be a pro and then react to every user disappointment in your site as if you're just going to take your ball and go home.


Please don't judge someone on what they haven't yet done - especially when there's no legitimate hint that it even will be done.

Steve hasn't stopped the QOTD. He hasn't threatened to stop the QOTD. He has said there's a lot more work than is apparent in sanity checking a QOTD. He has said the amount of SSC's daily time that can be devoted to the QOTDs is less than is necessary to guarantee problem-free questions. He has said that if we want decent questions then more of us should step up to the mark and propose some.


Steve
(aka sgmunson)

Internet ATM Machine
Post #523223
Posted Wednesday, June 25, 2008 6:53 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 20,857, Visits: 32,877
Then I will make the assumption that you'll be the first to volunteer to vet future QotD and willing to stick with it through thick and thin. I would consider it, but I also know that between my work and my life, I don't know how much time I have extra to be a part of such a group.

P.S. I also care, and realize that the QotD is much more of a fun sideline than a serious educational aspect of this site. Look back at some of the humorous QotD that have been given.

The meat of this site are the forums and its participants, not the QotD.



smunson (6/25/2008)
A.) No judgement was made, was just posing a question.

B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why what may or may not take place could be a reasonable choice? One might as well say that supporting a QoTD feature is just too much trouble - to which I will respond that anyone having sufficient experience in a forum environment to justify getting seriously involved in supporting one in any fashion, ought to know what's involved AS WELL AS what's expected long before beginning, and be capable of brushing off any negative press and moving on without a hitch. What you're suggesting says that such a person shouldn't or couldn't be expected to behave in that kind of PROFESSIONAL manner, and I beg to differ. The simple fact is that getting it right IS sometimes the most important thing - especially when you have perhaps thousands of folks relying on you to do so. Whenever a website shows any consistent signs of not being reliable, it's reputation suffers significantly, and most folks know this and thus make their voices loud in order that they be heard and responded to, so as to help avoid the loss they might incur if said site suddenly became less available or otherwise impaired by reputation. Make sense?

Steve
(aka smunson)
:):):)

P.S. It's because we care !!!
majorbloodnock (6/25/2008)
smunson (6/24/2008)
If their reaction is that childish, then where's the professionalism associated with publishing a website of this caliber? You can't be a pro and then react to every user disappointment in your site as if you're just going to take your ball and go home.


Please don't judge someone on what they haven't yet done - especially when there's no legitimate hint that it even will be done.

Steve hasn't stopped the QOTD. He hasn't threatened to stop the QOTD. He has said there's a lot more work than is apparent in sanity checking a QOTD. He has said the amount of SSC's daily time that can be devoted to the QOTDs is less than is necessary to guarantee problem-free questions. He has said that if we want decent questions then more of us should step up to the mark and propose some.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #523241
Posted Wednesday, June 25, 2008 6:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, November 17, 2014 6:00 AM
Points: 1,049, Visits: 3,012
smunson (6/25/2008)
A.) No judgement was made, was just posing a question.

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and I've misunderstood.


B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why what may or may not take place could be a reasonable choice?


Not at all. I have made no justification whatsoever; merely summarised what has been said before. No more, no less. I'm happy to see Steve praised or damned for what he has said or done, but not for what he has not, so it seemed sensible to set out exactly those points. If you're reading more into my comment than that, I suspect you're falling into the same trap I just fell into above (regarding your A.) point). Since I've just done it, I can vouch for how easy it is to do ;)

As for the rest, perhaps the QOTD is becoming a lot of trouble. The forum is a free resource, so there's a limit to the effort we can expect to be put in. Whether or not "a lot of trouble" is now "too much trouble" is pure conjecture, but I'd imagine the more people take it too seriously, the higher that "too much trouble" score will creep compared with the value the forum and its members get out of the QOTD resource.

And I agree that mistakes in the QOTDs aren't doing SSC any favours.


Semper in excretia, sumus solum profundum variat
Post #523245
Posted Wednesday, June 25, 2008 7:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:50 PM
Points: 1,688, Visits: 2,271

majorbloodnock (6/25/2008)
smunson (6/25/2008)
A.) No judgement was made, was just posing a question.

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and I've misunderstood.

It wasn't my intention to do any more than make folks think about the question. Thanks!
majorbloodnock (6/25/2008)


B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why what may or may not take place could be a reasonable choice?


Not at all. I have made no justification whatsoever; merely summarised what has been said before. No more, no less. I'm happy to see Steve praised or damned for what he has said or done, but not for what he has not, so it seemed sensible to set out exactly those points. If you're reading more into my comment than that, I suspect you're falling into the same trap I just fell into above (regarding your A.) point). Since I've just done it, I can vouch for how easy it is to do ;)

Yes, you summarized, but since all I had were the words you provided, sans any statement that says you are just summarizing, it would be pretty hard to infer any intent other than a justification, and thus I apologize for the misinterpretation, as I recognize the difficulty in translating thought and intent to the written word.

majorbloodnock (6/25/2008)

As for the rest, perhaps the QOTD is becoming a lot of trouble. The forum is a free resource, so there's a limit to the effort we can expect to be put in. Whether or not "a lot of trouble" is now "too much trouble" is pure conjecture, but I'd imagine the more people take it too seriously, the higher that "too much trouble" score will creep compared with the value the forum and its members get out of the QOTD resource.

And I agree that mistakes in the QOTDs aren't doing SSC any favours.


And here you go back in the same direction as you appeared to be going before - suddenly the QOTD is potentially more trouble than it's worth, and I have to say that the very existence of this debate over it's value is proof enough of it's value.

It just seems that some folks have so little intolerance for ANYTHING that even remotely resembles a negative thought, that they'll settle for less than they deserve merely to avoid conflict. That just seems to me to be less than appropriate where something of significant value is concerned. It's not the conflict that's the important thing, it's how one resolves it.

And I agree with you wholeheartedly on the QOTD boo-boos not doing SSC any favors (American spelling). It's because I highly value SSC that I choose some level of conflict lest that valuable resource become less valuable.

Steve
(aka smunson)
:):):)

P.S. to Lynn Pettis - I would choose not to volunteer myself for something of the nature of QOTD - not because of the potential for user complaint, but merely because I have very little time for any kind of volunteer effort, much less something with a daily deadline that's based on a time zone from across the pond. IOW, I simply do not have the time. My point was that whatever the time requirement or level of negative feedback, whomever IS doing it CAN be expected to do it right and take care of it professionally. If the number of problems were minimal, then this would likely have been a rather odd occurrence instead of a much larger issue.


Steve
(aka sgmunson)

Internet ATM Machine
Post #523291
Posted Wednesday, June 25, 2008 7:45 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 20,857, Visits: 32,877
smunson (6/25/2008)

majorbloodnock (6/25/2008)
smunson (6/25/2008)
A.) No judgement was made, was just posing a question.

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and I've misunderstood.

It wasn't my intention to do any more than make folks think about the question. Thanks!
majorbloodnock (6/25/2008)


B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why what may or may not take place could be a reasonable choice?


Not at all. I have made no justification whatsoever; merely summarised what has been said before. No more, no less. I'm happy to see Steve praised or damned for what he has said or done, but not for what he has not, so it seemed sensible to set out exactly those points. If you're reading more into my comment than that, I suspect you're falling into the same trap I just fell into above (regarding your A.) point). Since I've just done it, I can vouch for how easy it is to do ;)

Yes, you summarized, but since all I had were the words you provided, sans any statement that says you are just summarizing, it would be pretty hard to infer any intent other than a justification, and thus I apologize for the misinterpretation, as I recognize the difficulty in translating thought and intent to the written word.

majorbloodnock (6/25/2008)

As for the rest, perhaps the QOTD is becoming a lot of trouble. The forum is a free resource, so there's a limit to the effort we can expect to be put in. Whether or not "a lot of trouble" is now "too much trouble" is pure conjecture, but I'd imagine the more people take it too seriously, the higher that "too much trouble" score will creep compared with the value the forum and its members get out of the QOTD resource.

And I agree that mistakes in the QOTDs aren't doing SSC any favours.


And here you go back in the same direction as you appeared to be going before - suddenly the QOTD is potentially more trouble than it's worth, and I have to say that the very existence of this debate over it's value is proof enough of it's value.

It just seems that some folks have so little intolerance for ANYTHING that even remotely resembles a negative thought, that they'll settle for less than they deserve merely to avoid conflict. That just seems to me to be less than appropriate where something of significant value is concerned. It's not the conflict that's the important thing, it's how one resolves it.

And I agree with you wholeheartedly on the QOTD boo-boos not doing SSC any favors (American spelling). It's because I highly value SSC that I choose some level of conflict lest that valuable resource become less valuable.

Steve
(aka smunson)
:):):)

P.S. to Lynn Pettis - I would choose not to volunteer myself for something of the nature of QOTD - not because of the potential for user complaint, but merely because I have very little time for any kind of volunteer effort, much less something with a daily deadline that's based on a time zone from across the pond. IOW, I simply do not have the time. My point was that whatever the time requirement or level of negative feedback, whomever IS doing it CAN be expected to do it right and take care of it professionally. If the number of problems were minimal, then this would likely have been a rather odd occurrence instead of a much larger issue.


Just as I don't have time either, understood. The real point here, is that too many people complain excessivily, don't offer any solutions to help out, and if asked to assist propably wouldn't, even if they had the time. The attitude today is everything should be perfect always, and anything else is unexceptable. The problem with that, however, is that is not possible. Mistakes will happen, and with the QotD, bad questions and/or answers will occur. I have no problems with the problem being brought to the communities attention, but when you read nothing but complaints and whining from everyone, it gets to the point of the ridiculous.

The QotD is, and I am definitely repeating myself, not the meat of this site. I enjoy reading and answering the QotD, some of them make me think, some teach, some reinforce what I already know, but it isn't why I come to this site. I have learned so much more from the forums than I ever could from OJT or learning on my own. I have found new ways of thinking about problems and new solutions to old ones I had fixed (some have actually been better). And, more importantly, I have been giving back to this community for all the help it has given me.

I feel that I have made some friends on this site as well. There are quite a few people here that I would like to someday meet in person. Some live here in the States, and some overseas. But even if that never happens, they are still here, and I can rely on their experience and wisdom. Regardless of the QotD, the forums and the people are what make this site one of the best resources for SQL Server on the web today.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #523327
Posted Wednesday, June 25, 2008 7:52 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
Lynn,

Well put. I couldn't have said it better myself.

(I considered doing a quoted reply, but I wasn't sure whether or not we get points for acreage.)

:D


Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #523341
Posted Wednesday, June 25, 2008 8:42 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:50 PM
Points: 1,688, Visits: 2,271
While I understand your point, why diminish the value of SSC by allowing something like QOTD to go so far off kilter? Perhaps it's time to consider making it the QOTW (weekly) or QOTM (monthly), in order to insure that the time necessary to get it right can be actually be spent?

Also, I suggested a solution - it was called fixing it by doing the right thing for the right reason(remove the bad question and restore the points for all correct answerers and issue the mea culpas). What concerns me is being lumped into the whiners category. QOTD requires some amount of resource to be done correctly, and all I ask is that either the resource be provided or someone step up to the plate to state that the resources simply aren't available and scale back the implementation to meet available resources. Isn't that what the likes of Grant Fritchey, Jeff Moden, Matt Miller, and so many others preach in their posts with respect to SQL and DBA job skills? Why should the operation of this website be any different?

Steve
(aka smunson)
:):):)

Lynn Pettis (6/25/2008)
smunson (6/25/2008)

majorbloodnock (6/25/2008)
smunson (6/25/2008)
A.) No judgement was made, was just posing a question.

OK. That's the way it came across, but I'm happy to apologise if that wasn't your intention and I've misunderstood.

It wasn't my intention to do any more than make folks think about the question. Thanks!
majorbloodnock (6/25/2008)


B.) You ask for no judgement on what hasn't yet been done, and then go on to try and justify why what may or may not take place could be a reasonable choice?


Not at all. I have made no justification whatsoever; merely summarised what has been said before. No more, no less. I'm happy to see Steve praised or damned for what he has said or done, but not for what he has not, so it seemed sensible to set out exactly those points. If you're reading more into my comment than that, I suspect you're falling into the same trap I just fell into above (regarding your A.) point). Since I've just done it, I can vouch for how easy it is to do ;)

Yes, you summarized, but since all I had were the words you provided, sans any statement that says you are just summarizing, it would be pretty hard to infer any intent other than a justification, and thus I apologize for the misinterpretation, as I recognize the difficulty in translating thought and intent to the written word.

majorbloodnock (6/25/2008)

As for the rest, perhaps the QOTD is becoming a lot of trouble. The forum is a free resource, so there's a limit to the effort we can expect to be put in. Whether or not "a lot of trouble" is now "too much trouble" is pure conjecture, but I'd imagine the more people take it too seriously, the higher that "too much trouble" score will creep compared with the value the forum and its members get out of the QOTD resource.

And I agree that mistakes in the QOTDs aren't doing SSC any favours.


And here you go back in the same direction as you appeared to be going before - suddenly the QOTD is potentially more trouble than it's worth, and I have to say that the very existence of this debate over it's value is proof enough of it's value.

It just seems that some folks have so little intolerance for ANYTHING that even remotely resembles a negative thought, that they'll settle for less than they deserve merely to avoid conflict. That just seems to me to be less than appropriate where something of significant value is concerned. It's not the conflict that's the important thing, it's how one resolves it.

And I agree with you wholeheartedly on the QOTD boo-boos not doing SSC any favors (American spelling). It's because I highly value SSC that I choose some level of conflict lest that valuable resource become less valuable.

Steve
(aka smunson)
:):):)

P.S. to Lynn Pettis - I would choose not to volunteer myself for something of the nature of QOTD - not because of the potential for user complaint, but merely because I have very little time for any kind of volunteer effort, much less something with a daily deadline that's based on a time zone from across the pond. IOW, I simply do not have the time. My point was that whatever the time requirement or level of negative feedback, whomever IS doing it CAN be expected to do it right and take care of it professionally. If the number of problems were minimal, then this would likely have been a rather odd occurrence instead of a much larger issue.


Just as I don't have time either, understood. The real point here, is that too many people complain excessivily, don't offer any solutions to help out, and if asked to assist propably wouldn't, even if they had the time. The attitude today is everything should be perfect always, and anything else is unexceptable. The problem with that, however, is that is not possible. Mistakes will happen, and with the QotD, bad questions and/or answers will occur. I have no problems with the problem being brought to the communities attention, but when you read nothing but complaints and whining from everyone, it gets to the point of the ridiculous.

The QotD is, and I am definitely repeating myself, not the meat of this site. I enjoy reading and answering the QotD, some of them make me think, some teach, some reinforce what I already know, but it isn't why I come to this site. I have learned so much more from the forums than I ever could from OJT or learning on my own. I have found new ways of thinking about problems and new solutions to old ones I had fixed (some have actually been better). And, more importantly, I have been giving back to this community for all the help it has given me.

I feel that I have made some friends on this site as well. There are quite a few people here that I would like to someday meet in person. Some live here in the States, and some overseas. But even if that never happens, they are still here, and I can rely on their experience and wisdom. Regardless of the QotD, the forums and the people are what make this site one of the best resources for SQL Server on the web today.



Steve
(aka sgmunson)

Internet ATM Machine
Post #523433
« Prev Topic | Next Topic »

Add to briefcase «««1011121314»»

Permissions Expand / Collapse