Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 44,971 through 44,985 (of 66,712 total)

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

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 1

Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try to show them better ways to accomplish a task. I have personally been berated by a few OPs for not JUST answering the question.
Or for asking additional questions trying to get additional details.
Perhaps there's something here? Maybe an auto move of the question to Ask.SSC?

I think this should be left up to OP, personally. A button that they can move their question on the OP to ASKSSC directly without having to retype it all, locking the thread, and a link in the AskSSC.com component back to the original for those looking for more background in the discussion?

- Craig Farrell

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Evil Kraig F (7/30/2014)
Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try to show them better ways to accomplish a task. I have personally been berated by a few OPs for not JUST answering the question.
Or for asking additional questions trying to get additional details.
Perhaps there's something here? Maybe an auto move of the question to Ask.SSC?
I think this should be left up to OP, personally. A button that they can move their question on the OP to ASKSSC directly without having to retype it all, locking the thread, and a link in the AskSSC.com component back to the original for those looking for more background in the discussion?

I could see some benefit to that.

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

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 3

Eirikur Eiriksson (7/30/2014)
Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try to show them better ways to accomplish a task. I have personally been berated by a few OPs for not JUST answering the question.
Or for asking additional questions trying to get additional details.
Perhaps there's something here? Maybe an auto move of the question to Ask.SSC?
It is a challenge as sometimes the question itself is wrong with no appropriate/correct answer, such as "where do I find the pixy dust that turns SQL Server 2014 into SQL Server 2012?"
Don't think there is any favour in transferring those to Ask.SSC
😎

And all these years, I thought Pixy Dust only worked in RPG on the AS400.

Many times people 'just want the answer', and seem to not realize how important the full context (definition, what they have done, what they are trying to do) has tremendous influence on options and scalability in the end.

Moving a question will not likely change behavior of the poster, nor how someone will answer it.

The OP is either willing to learn or give additional information, and those replying usually either give solutions or wait until they think they understand enough to give good feedback.

I think the button and leave it up to the OP is a good idea.

Dwain Camps SSC Guru Points: 86948 More actions · Answer 4

Lynn Pettis (7/30/2014)
DECLARE @Value1 INT, @Value2, VARCHAR[20]; -- Just for demo purposes DECLARE YourCursor INSENSITIVE CURSOR FOR SELECT CustomerId, CustomerName FROM dbo.Customer ORDER BY CustomerId; OPEN YourCursor; FETCH NEXT FROM YourCursor INTO @Value1, @Value2; WHILE @@FETCH_STATUS = 0 BEGIN -- Do work here FETCH NEXT FROM YourCursor INTO @Value1, @Value2; END CLOSE YourCursor DEALLOCATE YourCursor;

Thanks Lynn! That's one for my snippets file. Always forget that bloody CURSOR syntax!

Wait a minute! Is that a good thing?

BTW. You forgot to terminate a couple of the statements with a semi-colon. 🙂

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

autoexcrement SSCertifiable Points: 5956 More actions · Answer 5

I would like to suggest that the title of this thread be changed to:

Are the posted questions getting worser?

"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 6

Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try to show them better ways to accomplish a task. I have personally been berated by a few OPs for not JUST answering the question.
Or for asking additional questions trying to get additional details.
Perhaps there's something here? Maybe an auto move of the question to Ask.SSC?

Interesting idea.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

Jeff Moden (7/30/2014)
Steve Jones - SSC Editor (7/30/2014)
Lynn Pettis (7/30/2014)
It should be noted as well, that sometimes people come to SSC and ask question(s) and then actually get upset when we try to show them better ways to accomplish a task. I have personally been berated by a few OPs for not JUST answering the question.
Or for asking additional questions trying to get additional details.
Perhaps there's something here? Maybe an auto move of the question to Ask.SSC?
Interesting idea.

Instead of a move to Ask.SSC, maybe a special forum for each edition called "Quick Answers Only"?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

autoexcrement SSCertifiable Points: 5956 More actions · Answer 8

How about "crap answers only"?

"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 9

Now now, there are cases where I can feel the frustration of the OP practically shouting "Just tell me the damned keywords and I'll look it up on my own!" due to some discussions that occur around here. I've jumped in on a number of them where a brief question about some particular technique turns into a request for 18 pieces of samples and documentations, when the person didn't even want to discuss code.

I'm also guilty of doing the same when I didn't have a fricking clue what they were trying to describe. *shrugs*.

Sometimes the answer to a very long, arduously typed question is: "You want partitioning. link here: <someurl>". BING! Off they go, running to the heavens happy to know where to go next. It depends. I wouldn't necessarily rip into people who need that though.

- Craig Farrell

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 10

autoexcrement (7/30/2014)
How about "crap answers only"?

Heh... maybe that would make a good alternative to "The Thread". 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 11

Jeff Moden (7/30/2014)
autoexcrement (7/30/2014)
How about "crap answers only"?
Heh... maybe that would make a good alternative to "The Thread". 😀

Careful, we don't want to provoke The Thread. 😀

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Lynn Pettis (7/30/2014)
Jeff Moden (7/30/2014)
autoexcrement (7/30/2014)
How about "crap answers only"?
Heh... maybe that would make a good alternative to "The Thread". 😀
Careful, we don't want to provoke The Thread. 😀

I think most have forgotten that The Thread evolved into a sentient being several years ago.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 13

SQLRNNR (7/30/2014)
Lynn Pettis (7/30/2014)
Jeff Moden (7/30/2014)
autoexcrement (7/30/2014)
How about "crap answers only"?
Heh... maybe that would make a good alternative to "The Thread". 😀
Careful, we don't want to provoke The Thread. 😀
I think most have forgotten that The Thread evolved into a sentient being several years ago.

Yes, (s)he has been dormant for a while. 😀

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

Really?? Let's put a 500 million row table into an in-memory table.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Lynn Pettis (7/30/2014)
Really?? Let's put a 500 million row table into an in-memory table.

It could work - depending on what the data is in that table and the data types. Of course you'd have to have enough memory for it. I'm sure Microsoft is hoping for bigger than that at some point.

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