Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 35,551 through 35,565 (of 66,712 total)

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

TomThomson SSC Guru Points: 104773 More actions · Answer 1

Lynn Pettis (4/18/2012)
Here is a our first challenge. No one should post again until we get what has been requested.

And for once CELKO posts something that seems eminently sensible in context, instead of a rant about standards.

Tom

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Stefan Krzywicki (4/18/2012)
Just complaining for a second
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it has been fixed in 2012, but seeing as I won't get to use that until 2016 or 2020, that's cold comfort.

If you install BIDSHelper you can change the scope.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 3

Koen Verbeeck (4/18/2012)
Stefan Krzywicki (4/18/2012)
Just complaining for a second
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it has been fixed in 2012, but seeing as I won't get to use that until 2016 or 2020, that's cold comfort.
If you install BIDSHelper you can change the scope.

I saw something about that in my searches. Have you tried it? Does it integrate with SSMS? Is it trustworthy (from a reliable manufacturer)? I just didn't have the time to do that research and convince those who need convincing that it is worth installing and then do the installation. : -)

And is it free? Probably the biggest block of all.

--------------------------------------
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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 4

SQLRNNR (4/18/2012)

ACinKC (4/18/2012)
hbtkp (4/13/2012)
i think i will lost my job , i am on dead linequote]
hbtkp (4/13/2012)
he just told me i cant help u with code,so i need help from you,
hbtkp (4/13/2012)
i m fresher in sql
hbtkp (4/15/2012)
i know basic,
If nothing else, it's been entertaining to watch.
hbtkp (4/17/2012)
i m closing this thread
I wonder if he/she had to ask someone how to do it...
Nah - just moving on to other threads trying to get the answers there

Speaking of "moving on", I'm amazed that so many people "entertain" such trolls for so long. Some of you good folks sure mean well by posting the same request for additional information but, holy moly, I wouldn't ask for it as many times as you do. It's almost like you're trying to teach such people a lesson and they're just not ever going to comply. Can we just move on and help someone else instead of trying to get the last word in with constant hammering with a moroff? Telling someone you need more info a half dozen or more times simply won't qualify you for sainthood. 😉

--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: 1004340 More actions · Answer 5

Koen Verbeeck (4/18/2012)
Stefan Krzywicki (4/18/2012)
Just complaining for a second
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it has been fixed in 2012, but seeing as I won't get to use that until 2016 or 2020, that's cold comfort.
If you install BIDSHelper you can change the scope.

Heh... same holds true if you do it in T-SQL. 😉

--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)

Revenant SSC-Forever Points: 42467 More actions · Answer 6

Jeff Moden (4/18/2012)
Koen Verbeeck (4/18/2012)
Stefan Krzywicki (4/18/2012)
Just complaining for a second
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it has been fixed in 2012, but seeing as I won't get to use that until 2016 or 2020, that's cold comfort.
If you install BIDSHelper you can change the scope.
Heh... same holds true if you do it in T-SQL. 😉

SSIS is the weakest part of SQLS. Fortunately, guys in charge know that.

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 7

SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
Lynn,
My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me the power of ignoring bad behavior. What she would suggest in these cases is to send them to the link where it explains how to pose a question, and then just ignore them until they correctly post code and sample data. If they make an effort, but it's still unacceptable, thank them for trying (because you always reward good behavior), then point them back to the link for whatever they have missed. Then EVERYONE should ignore any comments they make until they post enough information where you can actually help them.
You gain nothing by arguing with them. That just makes them think they can shame you into helping them, without them putting forth any more effort.
You may even be giving them an excuse to tell their boss "I'm asking for help but *nobody* knows how to fix this particular problem."
The sad fact is that there are some people who can't be helped.
Help those who can.
You may be right. But it didn't seem to matter how many times we pointed him to that article. The only thing we didn't do is copy/paste the article into the thread itself, and believe me I was tempted to do that.
On another note, looking through his posts I did find where he posted his formula for his cumulative totals. Instead of posting it in the thread where we asked for it, he posted it in a different thread. Then I found a much earlier thread where this same formula was giving him an error.
Do it once and then ignore until they actually post something of use. Baby steps.
Agreed, but we all have to follow this rule, at least those of us who now know about it.
Yup - and it ain't easy.

But, if some of you top guns start following this practice, then others will eventually ask in The Thread: "What do I do about this kind of thread?"

Then they will learn to refrain too.

It's easier to break the habit if everyone else is doing it.

We could start a support group.

Lynn could be the first member. 🙂

"Hi, my name is Lynn."

"Hi, Lynn...."

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

CapnHector SSCoach Points: 16143 More actions · Answer 8

The Dixie Flatline (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
Lynn,
My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me the power of ignoring bad behavior. What she would suggest in these cases is to send them to the link where it explains how to pose a question, and then just ignore them until they correctly post code and sample data. If they make an effort, but it's still unacceptable, thank them for trying (because you always reward good behavior), then point them back to the link for whatever they have missed. Then EVERYONE should ignore any comments they make until they post enough information where you can actually help them.
You gain nothing by arguing with them. That just makes them think they can shame you into helping them, without them putting forth any more effort.
You may even be giving them an excuse to tell their boss "I'm asking for help but *nobody* knows how to fix this particular problem."
The sad fact is that there are some people who can't be helped.
Help those who can.
You may be right. But it didn't seem to matter how many times we pointed him to that article. The only thing we didn't do is copy/paste the article into the thread itself, and believe me I was tempted to do that.
On another note, looking through his posts I did find where he posted his formula for his cumulative totals. Instead of posting it in the thread where we asked for it, he posted it in a different thread. Then I found a much earlier thread where this same formula was giving him an error.
Do it once and then ignore until they actually post something of use. Baby steps.
Agreed, but we all have to follow this rule, at least those of us who now know about it.
Yup - and it ain't easy.
But, if some of you top guns start following this practice, then others will eventually ask in The Thread: "What do I do about this kind of thread?"
Then they will learn to refrain too.
It's easier to break the habit if everyone else is doing it.
We could start a support group.
Lynn could be the first member. 🙂
"Hi, my name is Lynn."
"Hi, Lynn...."

after seeing mark's latest post making the assertion in thread that the users are the same i guess i should have left my rant in place. oh well

"HI, My name is Hector."

For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]

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

capn.hector (4/18/2012)
The Dixie Flatline (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
Lynn,
My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me the power of ignoring bad behavior. What she would suggest in these cases is to send them to the link where it explains how to pose a question, and then just ignore them until they correctly post code and sample data. If they make an effort, but it's still unacceptable, thank them for trying (because you always reward good behavior), then point them back to the link for whatever they have missed. Then EVERYONE should ignore any comments they make until they post enough information where you can actually help them.
You gain nothing by arguing with them. That just makes them think they can shame you into helping them, without them putting forth any more effort.
You may even be giving them an excuse to tell their boss "I'm asking for help but *nobody* knows how to fix this particular problem."
The sad fact is that there are some people who can't be helped.
Help those who can.
You may be right. But it didn't seem to matter how many times we pointed him to that article. The only thing we didn't do is copy/paste the article into the thread itself, and believe me I was tempted to do that.
On another note, looking through his posts I did find where he posted his formula for his cumulative totals. Instead of posting it in the thread where we asked for it, he posted it in a different thread. Then I found a much earlier thread where this same formula was giving him an error.
Do it once and then ignore until they actually post something of use. Baby steps.
Agreed, but we all have to follow this rule, at least those of us who now know about it.
Yup - and it ain't easy.
But, if some of you top guns start following this practice, then others will eventually ask in The Thread: "What do I do about this kind of thread?"
Then they will learn to refrain too.
It's easier to break the habit if everyone else is doing it.
We could start a support group.
Lynn could be the first member. 🙂
"Hi, my name is Lynn."
"Hi, Lynn...."
after seeing mark's latest post making the assertion in thread that the users are the same i guess i should have left my rant in place. oh well
"HI, My name is Hector."

Hi, My name is Lynn and I like to feed the trolls in the hope that they may just learn something.

Revenant SSC-Forever Points: 42467 More actions · Answer 10

Lynn Pettis (4/18/2012)
capn.hector (4/18/2012)
The Dixie Flatline (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
Lynn,
My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me the power of ignoring bad behavior. What she would suggest in these cases is to send them to the link where it explains how to pose a question, and then just ignore them until they correctly post code and sample data. If they make an effort, but it's still unacceptable, thank them for trying (because you always reward good behavior), then point them back to the link for whatever they have missed. Then EVERYONE should ignore any comments they make until they post enough information where you can actually help them.
You gain nothing by arguing with them. That just makes them think they can shame you into helping them, without them putting forth any more effort.
You may even be giving them an excuse to tell their boss "I'm asking for help but *nobody* knows how to fix this particular problem."
The sad fact is that there are some people who can't be helped.
Help those who can.
You may be right. But it didn't seem to matter how many times we pointed him to that article. The only thing we didn't do is copy/paste the article into the thread itself, and believe me I was tempted to do that.
On another note, looking through his posts I did find where he posted his formula for his cumulative totals. Instead of posting it in the thread where we asked for it, he posted it in a different thread. Then I found a much earlier thread where this same formula was giving him an error.
Do it once and then ignore until they actually post something of use. Baby steps.
Agreed, but we all have to follow this rule, at least those of us who now know about it.
Yup - and it ain't easy.
But, if some of you top guns start following this practice, then others will eventually ask in The Thread: "What do I do about this kind of thread?"
Then they will learn to refrain too.
It's easier to break the habit if everyone else is doing it.
We could start a support group.
Lynn could be the first member. 🙂
"Hi, my name is Lynn."
"Hi, Lynn...."
after seeing mark's latest post making the assertion in thread that the users are the same i guess i should have left my rant in place. oh well
"HI, My name is Hector."
Hi, My name is Lynn and I like to feed the trolls in the hope that they may just learn something.

<sarcasm>Hi, my name is Revenant and I am an alcoholic.</sarcasm>

A day has only 86,400 seconds; could we please move on to something that is worth at least 30 of them?

</sarcasm again, not a good XML, I admit>

(much thanks, my friends)

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

Revenant (4/18/2012)
Lynn Pettis (4/18/2012)
capn.hector (4/18/2012)
The Dixie Flatline (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
Lynn,
My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me the power of ignoring bad behavior. What she would suggest in these cases is to send them to the link where it explains how to pose a question, and then just ignore them until they correctly post code and sample data. If they make an effort, but it's still unacceptable, thank them for trying (because you always reward good behavior), then point them back to the link for whatever they have missed. Then EVERYONE should ignore any comments they make until they post enough information where you can actually help them.
You gain nothing by arguing with them. That just makes them think they can shame you into helping them, without them putting forth any more effort.
You may even be giving them an excuse to tell their boss "I'm asking for help but *nobody* knows how to fix this particular problem."
The sad fact is that there are some people who can't be helped.
Help those who can.
You may be right. But it didn't seem to matter how many times we pointed him to that article. The only thing we didn't do is copy/paste the article into the thread itself, and believe me I was tempted to do that.
On another note, looking through his posts I did find where he posted his formula for his cumulative totals. Instead of posting it in the thread where we asked for it, he posted it in a different thread. Then I found a much earlier thread where this same formula was giving him an error.
Do it once and then ignore until they actually post something of use. Baby steps.
Agreed, but we all have to follow this rule, at least those of us who now know about it.
Yup - and it ain't easy.
But, if some of you top guns start following this practice, then others will eventually ask in The Thread: "What do I do about this kind of thread?"
Then they will learn to refrain too.
It's easier to break the habit if everyone else is doing it.
We could start a support group.
Lynn could be the first member. 🙂
"Hi, my name is Lynn."
"Hi, Lynn...."
after seeing mark's latest post making the assertion in thread that the users are the same i guess i should have left my rant in place. oh well
"HI, My name is Hector."
Hi, My name is Lynn and I like to feed the trolls in the hope that they may just learn something.
<sarcasm>Hi, my name is Revenant and I am an acoholic.</sarcasm>
A day has only 86,400 seconds; could we please move on to something that is worth at least 30 of them?
</sarcasm again, not a good XML, I admit>
(thanks)

IF you want something worth 30 seconds, I don't think you'll find it here in The Thread. All things here are accepted, well, except long technical discussions, those need to be moved to the approriate fourms. :-D:-D

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 12

Shifting gears hard to the opposite side of the spectrum, have you folks been watching Wayne Sheffield's blog? He's done some awesome testing against some of the new LEAD functionality of SQL Server 2012. Here's his latest post...

http://blog.waynesheffield.com/wayne/archive/2012/04/sql-server-2012-performance-test-gap-detection/

--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 13

Jeff Moden (4/18/2012)
Shifting gears hard to the opposite side of the spectrum, have you folks been watching Wayne Sheffield's blog? He's done some awesome testing against some of the new LEAD functionality of SQL Server 2012. Here's his latest post...
http://blog.waynesheffield.com/wayne/archive/2012/04/sql-server-2012-performance-test-gap-detection/

Cool info!

Paul White SSC Guru Points: 150467 More actions · Answer 14

Jeff Moden (4/18/2012)
He's done some awesome testing against some of the new LEAD functionality of SQL Server 2012.

An efficient algorithm out-performs an inefficient one? Who knew! Seriously, the code there does not show a good use of LEAD. My concern would be that people form a *general* opinion from that post that the new windowing tools in 2012 do not perform well, and that would be unfortunate.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 15

Stefan Krzywicki (4/18/2012)
Koen Verbeeck (4/18/2012)
Stefan Krzywicki (4/18/2012)
Just complaining for a second
Scope for variables in SSIS are utter crap, it'd be better if scope didn't even exist here. Yes, I hear it has been fixed in 2012, but seeing as I won't get to use that until 2016 or 2020, that's cold comfort.
If you install BIDSHelper you can change the scope.
I saw something about that in my searches. Have you tried it? Does it integrate with SSMS? Is it trustworthy (from a reliable manufacturer)? I just didn't have the time to do that research and convince those who need convincing that it is worth installing and then do the installation. : -)
And is it free? Probably the biggest block of all.

I surely have tried it. In my SSIS best practices presentation, best practice #1 is "Install BIDSHelper. Now." 😀

It does not integrate with SSMS, as the name says it, it is a plug-in for BIDS (aka Visual Studio). It is trustworthy, I have never had much issues with it, but it can make the editing/opening of packages a bit slower, as it has to highlight certain objects in the designer.

It is free, as it is published on Codeplex. Every client I ever worked with had BIDSHelper installed. Or I installed it for them 🙂

(It's not only for SSIS, but also for SSAS and SSRS)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP