Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,3994,4004,4014,4024,403»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, May 23, 2014 1:02 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:05 PM
Points: 31,284, Visits: 15,750
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1574217
Posted Friday, May 23, 2014 1:04 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:10 AM
Points: 13,230, Visits: 12,709
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1574218
Posted Friday, May 23, 2014 1:36 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:36 AM
Points: 1,208, Visits: 3,901
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 Philosopher

How to post a question to get the most help
Post #1574223
Posted Friday, May 23, 2014 1:42 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:52 AM
Points: 17,980, Visits: 15,983
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
Post #1574226
Posted Friday, May 23, 2014 3:57 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:50 PM
Points: 1,061, Visits: 2,580
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
Blog: SQLSouth
Twitter: @SQLSouth
Post #1574256
Posted Saturday, May 24, 2014 5:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 5:17 PM
Points: 1,401, Visits: 6,797
Welkom back wolfkillj, could you fix the link to your blog? It points to the thread.
Post #1574290
Posted Saturday, May 24, 2014 5:23 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 11:25 AM
Points: 1,942, Visits: 20,007
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
Post #1574293
Posted Saturday, May 24, 2014 11:24 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 40,456, Visits: 36,912
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1574323
Posted Saturday, May 24, 2014 12:14 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 40,456, Visits: 36,912
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1574330
Posted Sunday, May 25, 2014 10:02 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 24, 2014 4:53 AM
Points: 3,422, Visits: 5,368
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!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1574435
« Prev Topic | Next Topic »

Add to briefcase «««4,3994,4004,4014,4024,403»»»

Permissions Expand / Collapse