August 6, 2012 at 9:58 am
You could add me to a review list; I'd like to see something like an email or page where us "volunteers" go and review potential QOTD periodically, and after it's been peer reviewed by, say 2 or more of us, it could be added to the QOTD queue.
i wouldn't have a problem with reviewing, say five or ten questions as a batch every couple of weeks.
Lowell
August 6, 2012 at 10:34 am
I would be willing to be part of the group, as long as the commitment level is reasonably small. My guess is initially it would take some time but once it got rolling it wouldn't be a big deal. If we had 20 people and each question needed to be reviewed by 2 people we are only talking about any individual needing to review more than 1 question every 2 weeks.
I think the real concern is the additional administration by Steve to keep this all moving. What happens when a question does not meet the standards or there is some need of change? Who manages the stream at that point? Who manages the new team of people that are enforcing some level of standards? Do we have an application process or are we going to consider only certain people as qualified to be on the team? What happens when a reviewer is on vacation or does not respond to the requested review in a timely manner? I think the idea is a good one but there are a lot of unanswered questions.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 6, 2012 at 12:35 pm
Aside from the concerns raised in the past, detailed by Gus, I'd say people just need to lighten up. It's a QOTD, and the points don't actually mean anything.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
August 6, 2012 at 12:38 pm
jcrawf02 (8/6/2012)
Aside from the concerns raised in the past, detailed by Gus, I'd say people just need to lighten up. It's a QOTD, and the points don't actually mean anything.
But you are wrong about that.
Highest point tally in 2020 gets a free pass at Rapture and becomes the Super Bowl MVP for the next five years.:-D:-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 6, 2012 at 12:41 pm
SQLRNNR (8/6/2012)
jcrawf02 (8/6/2012)
Aside from the concerns raised in the past, detailed by Gus, I'd say people just need to lighten up. It's a QOTD, and the points don't actually mean anything.But you are wrong about that.
Highest point tally in 2020 gets a free pass at Rapture and becomes the Super Bowl MVP for the next five years.:-D:-D
I had no idea Aaron Rodgers was so knowledgeable about SQL Server!
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 6, 2012 at 1:34 pm
Sean Lange
I think the real concern is the additional administration by Steve to keep this all moving. What happens when a question does not meet the standards or there is some need of change?
Obviously if Steve approves the idea a standard operating procedure would be necessary and the first order of business for the volunteers. My suggestion (for discussion by the volunteers).
a. If flagged by the first "verifier" as requiring correction / amplification and the details of what needs correction / amplification are noted the second "verifier" reviews the submittal. If there is agreement on the need(s) then it is marked as return to submitter along with the verifier's comments. The return e-mail is sent of course by Steve.
b. The volunteers (primary and secondary) should be able to review submittals, select the ones they will review, and submitt the date when the their review will be completed.
b1. A job might be set up to e-mail the reviewers say a week in advance that they have work to do by their promised review date.
c. Lets say the first verifier oks the submittal, the second verifier agrees and sets a flag to indicate to Steve that the submittal is available for scheduling. (Steve of course decides the date for publication)
d. If first verifier approves and the second does not .. a third verifier is requested to join in or it is marked as such and the final decision as to schedule or return to the submitter is made by Steve.
Oviously implimentation implementation not going to occur over night, so lets keep discussing the pros and cons of what has been suggested.
For example, people who review a question need to be barred from getting points for answering the question.
I would think that those who volunteer are ethical enough to voluntarily obstain from answering that particular QOD or any other QOD they may have seen during the review process.
August 6, 2012 at 1:53 pm
Keep in mind that Steve may not have final say in whether that can be done or not. Volunteer-work for for-profit companies gets legally complicated. That's one reason why RedGate pays (albeit just barely) for articles they publish. All/most of us would be perfectly happy to write for SSC for free, with the pride of being published, the service to the community, the bragging rights on resumes, etc., all the recompense needed. But that can get sticky, since RedGate is for-profit and they benefit by our writing. Same with reviewing QotD submissions.
Their legal people would have to approve NDA and waiver forms, and all that. At least, I seriously hope they'd have to, or they may end up in a mess if someone gets upset about their QotD submission being rejected or whatever. We might reject for what seem to be valid reasons, have a situation like Jeff thinking Paul was being sarcastic, and RedGate and Steve end up having to handle irate people.
It's like querying delimited lists. It seems so simple, but the details ....
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 6, 2012 at 2:10 pm
I would tend to agree with Gus except for one thng, no one gets paid for QotD submissions. In addition, Steve could review the QotD if it is rejected and make a different call. I think what has been suggested could work and provide a means to help eleviate some of the problems with the QotD. It isn't going to make everyone happy, as there may still be people who complain about getting an aswer wrong for some reason or another.
August 6, 2012 at 2:48 pm
I'd be willing to assist on QotD validations, but my free time has constrained signficantly lately so I certainly couldn't guarantee timeliness (ie: under two weeks)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 6, 2012 at 4:32 pm
Why do people get upset when you can't provide an answer based on vague requirements?
August 6, 2012 at 4:43 pm
Lynn Pettis (8/6/2012)
Why do people get upset when you can't provide an answer based on vague requirements?
We would love to help you - can you provide some sample data?
:rolleyes:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 6, 2012 at 4:50 pm
SQLRNNR (8/6/2012)
Lynn Pettis (8/6/2012)
Why do people get upset when you can't provide an answer based on vague requirements?We would love to help you - can you provide some sample data?
:rolleyes:
Really??? You call this help? This site used to be a great place to get help and information. :Whistling: :w00t: 😛 😉
Actually, I got a good chuckle from your response.
August 6, 2012 at 4:54 pm
Lynn Pettis (8/6/2012)
SQLRNNR (8/6/2012)
Lynn Pettis (8/6/2012)
Why do people get upset when you can't provide an answer based on vague requirements?We would love to help you - can you provide some sample data?
:rolleyes:
Really??? You call this help? This site used to be a great place to get help and information. :Whistling: :w00t: 😛 😉
Actually, I got a good chuckle from your response.
:hehe::-D
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 6, 2012 at 4:58 pm
Lynn Pettis (8/6/2012)
Why do people get upset when you can't provide an answer based on vague requirements?
Primarily because that's how they get them from business users and hope we brought our magic wand to the internet. In this case, I think it's a matter of personal frustration being vented via persona.
However, I don't really have enough information to give more than a vague conclusion... 😉
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 6, 2012 at 5:02 pm
Evil Kraig F (8/6/2012)
Lynn Pettis (8/6/2012)
Why do people get upset when you can't provide an answer based on vague requirements?Primarily because that's how they get them from business users and hope we brought our magic wand to the internet. In this case, I think it's a matter of personal frustration being vented via persona.
However, I don't really have enough information to give more than a vague conclusion... 😉
:w00t:
And then they also get upset when we get snarky (and we sometimes get our hands slapped as well).
Party Time! Whose turn to take care of the Guard Hippo at the TitD?
Viewing 15 posts - 37,306 through 37,320 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply