Are the posted questions getting worse?
-
BWFC (5/23/2014)
Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is a global site and people work all kinds of hours and shifts but it would be nice to have had some kind of reply after a couple of days. Even if this reply is, 'what you suggested doesn't work. Have you got any other ideas?' That would be better than nothing. I'd like to think that the OP hasn't come back because my answer was exactly what they wanted and nothing further needed to be said, in this case a thank you would be appreciated.Yes, it is frustrating at times but as Gail said you do get used to it. What is also frustrating, though, is when an OP does come back and says 'what you suggested doesn't work. Have you got any other ideas?' but doesn't bother to tell you why your suggestion didn't work.
-
Grant Fritchey (5/23/2014)
BWFC (5/23/2014)
Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is a global site and people work all kinds of hours and shifts but it would be nice to have had some kind of reply after a couple of days. Even if this reply is, 'what you suggested doesn't work. Have you got any other ideas?' That would be better than nothing. I'd like to think that the OP hasn't come back because my answer was exactly what they wanted and nothing further needed to be said, in this case a thank you would be appreciated.Better ignored than argued with incorrectly. Or worse, the "yeah, but we can't change anything, anywhere, anytime, now how do I fix it" responses.
Oh goodness. I definitely fall into that second camp there to a degree, since I've worked with nothing but vendor software so far :-P. I know I can't really make many changes to what the vendor nonsense does, but when I've asked for help with what I CAN change, the responses here have been great, and they've done a lot of good.
Thanks for all the help you all put out! I know it can be frustrating (heck, even I get frustrated reading some of the posts I've seen here, and I can't even begin to help!), but I'm sure there's tons of people that appreciate the effort, myself definitely included :-).
Oh, and if I've fallen into the trap of being less than appreciative of anyone's assistance, please feel free to whap me on the head a good few times 😀
- 😀
-
Lynn Pettis (5/23/2014)
BWFC (5/23/2014)
Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is a global site and people work all kinds of hours and shifts but it would be nice to have had some kind of reply after a couple of days. Even if this reply is, 'what you suggested doesn't work. Have you got any other ideas?' That would be better than nothing. I'd like to think that the OP hasn't come back because my answer was exactly what they wanted and nothing further needed to be said, in this case a thank you would be appreciated.Yes, it is frustrating at times but as Gail said you do get used to it. What is also frustrating, though, is when an OP does come back and says 'what you suggested doesn't work. Have you got any other ideas?' but doesn't bother to tell you why your suggestion didn't work.
Or does tell you why it doesn't work, demonstrating that his earlier posts have been utterly misleading as to what he was trying to do.
Tom
-
BWFC (5/23/2014)
Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is a global site and people work all kinds of hours and shifts but it would be nice to have had some kind of reply after a couple of days. Even if this reply is, 'what you suggested doesn't work. Have you got any other ideas?' That would be better than nothing. I'd like to think that the OP hasn't come back because my answer was exactly what they wanted and nothing further needed to be said, in this case a thank you would be appreciated.Yes, but it's what it is. They may post on STackOverflow as well and get an answer (or anywhere else). They may figure it out. They may be intimidated by responses.
Ultimately, I do what I can, help where I can, cease worrying about what I cannot control.
-
LOL. Apparently I need to endorse my SSC friends more on LinkedIn.
_______________________________________________________________
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/ -
GilaMonster (5/23/2014)
Steve, can anything be done about shrills like this:http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that DB recovery software.
We have an account ban in place, and they can't register with the same email. Not sure what more we can do without writing code for a specific message or link, and that can be gotten around, so it's a pain.
I could add a banned links list and potentially search it on posting, but the code might be tricky to get into prod.
-
Steve Jones - SSC Editor (5/23/2014)
GilaMonster (5/23/2014)
Steve, can anything be done about shrills like this:http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that DB recovery software.
We have an account ban in place, and they can't register with the same email. Not sure what more we can do without writing code for a specific message or link, and that can be gotten around, so it's a pain.
I could add a banned links list and potentially search it on posting, but the code might be tricky to get into prod.
We can just keep reporting that nonsense. Eventually they will get tired of it.
_______________________________________________________________
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/ -
Steve Jones - SSC Editor (5/23/2014)
BWFC (5/23/2014)
Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is a global site and people work all kinds of hours and shifts but it would be nice to have had some kind of reply after a couple of days. Even if this reply is, 'what you suggested doesn't work. Have you got any other ideas?' That would be better than nothing. I'd like to think that the OP hasn't come back because my answer was exactly what they wanted and nothing further needed to be said, in this case a thank you would be appreciated.Yes, but it's what it is. They may post on STackOverflow as well and get an answer (or anywhere else). They may figure it out. They may be intimidated by responses.
Ultimately, I do what I can, help where I can, cease worrying about what I cannot control.
As always on here, my original post has led to much more than I actually expected. It can pretty much always be guaranteed that there will be reasoned discussion and debate and hopefully everyone comes away having learned something. I particularly like the way the big hitters will even chip in to a minor player's slightly whiny post about people not saying thank you.
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
Sean Lange (5/23/2014)
LOL. Apparently I need to endorse my SSC friends more on LinkedIn.That can't be dwain 😉 there is no giant fish.
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 -
Wow - I have been away from the thread for a long time. I've been busy at work with an avalanche of new projects and improvements to existing process. One of those projects included a requirement to generate a well-formed XML file from the output of a stored procedure for delivery to a client. In a move that will surely warm the cockles of Jeff Moden's heart, I used the bcp utility to accomplish this without resorting to a custom application or (gasp) SSIS.
It was a little tricky, though - either my Google-fu was too weak to find the answers I needed or they don't exist on the web, and the Books Online documentation was, ahem, somewhat less than clear and complete. Since there doesn't seem to be a guide for doing this anywhere else, I have posted what worked for me on my blog (which I have also been away from for too long): Export XML From SQL Server Using bcp.
As always, comments, suggestions, and pork chops from this group are always welcome, but I would strongly prefer that your remarks or complaints pertain to the post rather than things like my dubious lineage and questionable personal hygiene.
EDIT: Fixed the link. Thanks Jo Pattyn and J Livingston SQL.
Jason Wolfkill
-
Welkom back wolfkillj, could you fix the link to your blog? It points to the thread.
-
Jo Pattyn (5/24/2014)
Welkom back wolfkillj, could you fix the link to your blog? It points to the thread.http://sqlsouth.wordpress.com/2014/05/23/export-xml-from-sql-server-using-bcp/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day -
Steve Jones - SSC Editor (5/23/2014)
GilaMonster (5/23/2014)
Steve, can anything be done about shrills like this:http://www.sqlservercentral.com/Forums/FindPost1573887.aspx
He's posting on thread after thread on damaged DBs, missing backups, etc, usually talking garbage and with links to that DB recovery software.
We have an account ban in place, and they can't register with the same email.
Thanks, that should be enough.
My main problem with him (and I suspect the same person previously under different account names) is that they're not blatantly spam (Kitchen in Lancashire anyone?) and that what they post sounds just plausible enough to be taken as good advice
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
And the article on premature optimisation submitted. I may need to take leave the day it's published, so that I have time to reply to all the nasty comments that are sure to come.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Sean Lange (5/23/2014)
LOL. Apparently I need to endorse my SSC friends more on LinkedIn.Answer No to the one about TFS. Unless it's a recipe for alphabet soup.
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
Viewing 15 posts - 43,996 through 44,010 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply