Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 18,481 through 18,495 (of 66,712 total)

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

Alvin Ramard (9/12/2010)
Alvin Ramard (9/12/2010)
Gail, you might want to bring a certain piece of steel with you if you go revisit that BIT datatype thread.
That OP is now on my ignore list.
Edit: I took a look at that OP's posts. On 8/24 he posted something that indicated that he's been asked to do something that should be done by the DBA who is on 3 months leave. After reading his posts, it's obvious that he's not familiar with SQL. Somebody needs to go slap this guy's boss.

all right, where in the heck is the ignore list?Are you guys holding out on me here? I can find the Buddy list, but an ignore would certainly be handy; when i click to add Gail as my "buddy" for example, it just says receive emails yes/no...is buddy with No an ignore?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

WayneS SSC Guru Points: 95460 More actions · Answer 2

Alvin Ramard (9/12/2010)
GilaMonster (9/12/2010)
Patience, yes, but that poster needs an attitude adjustment. Go back through their older posts.
I think part of his problem, on top of his poor communication skills, may be that he's being asked to do somethiing that he does not know how to do and he's not ready to admit. Disrespecting the people that are trying to help is not a winning move.
They say we learn by our mistakes. Some need a major mistake before they learn.

Agreed with both of you on this. Definitely not a way to endear others to help you.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95460 More actions · Answer 3

CirquedeSQLeil (9/12/2010)
WayneS (9/12/2010)
GilaMonster (9/12/2010)
Alvin Ramard (9/12/2010)
Alvin Ramard (9/12/2010)
Gail, you might want to bring a certain piece of steel with you if you go revisit that BIT datatype thread.
That OP is now on my ignore list.
Mine too. This was the clincher (To Alvin)
Once I got it working I will post the solution here for others like you who doesn't know about it.
Steve, intervention time?
Seems like Paul got it working. ((s)he seems to really like large fonts.) IMO, this is someone that is an extreme newby in SS being tasked to do stuff in the dba's absence. I kinda sense an ESL thing might be going on here also... So, let's try to be patient here.
Yeee ... Haaaaa...

Hehe. Yep!

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

Lowell (9/12/2010)
Alvin Ramard (9/12/2010)
Alvin Ramard (9/12/2010)
Gail, you might want to bring a certain piece of steel with you if you go revisit that BIT datatype thread.
That OP is now on my ignore list.
Edit: I took a look at that OP's posts. On 8/24 he posted something that indicated that he's been asked to do something that should be done by the DBA who is on 3 months leave. After reading his posts, it's obvious that he's not familiar with SQL. Somebody needs to go slap this guy's boss.
all right, where in the heck is the ignore list?Are you guys holding out on me here? I can find the Buddy list, but an ignore would certainly be handy; when i click to add Gail as my "buddy" for example, it just says receive emails yes/no...is buddy with No an ignore?

Sorry, but you're not permitted to use my ignore list. It's between my two ears and it does not accept remote comnnections, well, not before I get that implant perfected.. 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Alvin Ramard (9/12/2010)
They say we learn by our mistakes. Some need a major mistake before they learn.

I think the whole thread was a mistake, bordering on a train wreck.

See this post for my best guess at what happened here. I'm not sure everyone noticed that post before jumping in 😉

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White NZ (9/12/2010)
Alvin Ramard (9/12/2010)
They say we learn by our mistakes. Some need a major mistake before they learn.
I think the whole thread was a mistake, bordering on a train wreck.
See this post for my best guess at what happened here. I'm not sure everyone noticed that post before jumping in 😉

From the responses, it is entirely possible he/she still doesn't have it right. Paul provided something concrete, but they still have the problem that they don't actually know what 0 and 1 stand for. Or if NULL is allowed. They can translate it with the Case statement, but they flat out stated they don't understand what the DBA told them about what the numbers represent.

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 7

Paul White NZ (9/12/2010)
Alvin Ramard (9/12/2010)
They say we learn by our mistakes. Some need a major mistake before they learn.
I think the whole thread was a mistake, bordering on a train wreck.
See this post for my best guess at what happened here. I'm not sure everyone noticed that post before jumping in 😉

I read that, as it was evolving.

It reminded of the story about a psychology professor who walked into class one day with a mule and a big wooden stick. He then told the class that he was going to show them how to train the mule. He then took the wooden stick and whack the mule in the head with it, after which he turned to the class and said: "Step #1 - get the mules attention."

Getting the OPs attention is sometimes much harder than it should be.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Stefan Krzywicki (9/12/2010)
From the responses, it is entirely possible he/she still doesn't have it right. Paul provided something concrete, but they still have the problem that they don't actually know what 0 and 1 stand for. Or if NULL is allowed. They can translate it with the Case statement, but they flat out stated they don't understand what the DBA told them about what the numbers represent.

I don't think the question was ever that deep. He simply wanted to decode the column using IIF - and CASE is SQL Server's equivalent.

edit: You have to follow the link in my post to the other site where Lennie posted his IIF sample data.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 9

I think in this case it would be "with friends like these, who needs anchors." Works at about the same I imagine.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Grant Fritchey (9/12/2010)
I think in this case it would be "with friends like these, who needs anchors." Works at about the same I imagine.

I haven't heard that term since just before I left the russian mofia.

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

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 11

Good work one and all on the true / false nonsense, its very dispiriting when all you get is grief when you are trying to help.

My favourite part of that thread..

the DataBase Administrator he himself is very confused and coulld not explain logically

More likely "Got annoyed at me for not understanding"

Clear Sky SQL
My Blog[/url]

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 12

Yeah, well, I felt the need to step in and post the Mom response. Maybe that'll help. Maybe not. But seriously, that was just plain rude.

On another note, I'm seriously bummed that I don't qualify to submit a pre-con session for SQL Rally. Seriously, seriously bummed. @=(

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

WayneS SSC Guru Points: 95460 More actions · Answer 13

Threadizens,

I posted Friday about an issue in getting OpenDataSource to work on a server. I can't figure out why I'm getting this issue, and would really appreciate any input you'll might have in resolving this!

Thanks,

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 14

The Dixie Flatline (9/12/2010)
Comment expurgated in the interests of good taste.

It's finally happened. Bob's lost his edge. :-P;-)

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

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

That presupposes I had an edge to begin with.

Maybe I just regained my sense of shame...:unsure:

__________________________________________________

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