Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,786 through 55,800 (of 66,712 total)

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

jasona.work SSC Guru Points: 50117 More actions · Answer 1

Lynn Pettis (9/13/2016)
jasona.work (9/13/2016)
Lynn Pettis (9/13/2016)
So a coworker HipChats me saying he needs some advice. Here is his question:
i have a stored procedure but the initial table is about 10million records, what is a good practice to break this up
Wow, looks like the typical question we get here where we need the crystal ball.
Frozen pork chops loaded into the pork chop launcher?
A sledgehammer?
A jackhammer?
A 120mm APFSDS round? :hehe:
Intermediate range ballistic missile, needs to go from Colorado Springs, CO to Hampton, VA.

Nah, an MRBM, it's only about 2700KM between those...

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 2

drew.allen (9/13/2016)
I recently submitted my first article for SSC. I got some great feedback on my rough drafts. Thanks Chris, Graham, and Wayne. I'm not sure what more is involved until it is actually published.
I also have ideas for a series of articles. There was a recent answer that made me realize that when I do write the series, I need to start with a basic concepts article, because the answer given was more complicated than it needed to be.
Drew

good luck with the article Drew.

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

SqlSanctum Ten Centuries Points: 1229 More actions · Answer 3

BLOB_EATER (9/13/2016)
Anyone willing to share general stats on their blogs. ( Or is this a rude request??!)
I have received 1000 views within the past 6 months which is poor ( but expected as Im quite new).. I am just trying to understand the sort of view hit the elite bloggers get... i.e. the MVPs / MCMs of this world. I'm guessing you guys hit many many many thousands over the month??

As a minor blip in the SQL world, my blog stats might make you feel a bit better than the massive numbers of the pros. I started blogging a little over a year ago and cover a random assortment of topics, mostly PowerShell or scripts I have.

In 2015, I made 33 posts with about 1,500 total views.

In 2016, I've made 25 posts with 5,500 total views, with ~400 views in January and over 800 last month. About 80% of my views are from Search Engines. I try to post once a week on the same day and same time, but I don't think that matters much unless it affects the searches.

I do syndicate on ToadWorld, when the syndication works, but haven't gotten the courage to try syndicating here yet.

Overall, the views don't matter to me, it's more important to force myself to write and try to delve deeper into subjects (but most of my topics are fairly low level). One of the best parts of blogging is that it provides me with an online, well-laid out repository for when I have to repeat something I do rarely.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

drew.allen (9/13/2016)
I recently submitted my first article for SSC. I got some great feedback on my rough drafts. Thanks Chris, Graham, and Wayne. I'm not sure what more is involved until it is actually published.
I also have ideas for a series of articles. There was a recent answer that made me realize that when I do write the series, I need to start with a basic concepts article, because the answer given was more complicated than it needed to be.
Drew

Thanks, Drew, and we'll get you feedback as soon as you can. I'm catching up from holiday, and a few people just left.

drew.allen SSC Guru Points: 76989 More actions · Answer 5

I think someone is in way over their head. Maybe we should just tell him to find another line of work.

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

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

drew.allen (9/13/2016)
I think someone is in way over their head. Maybe we should just tell him to find another line of work.
Drew

Who?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Here's a fun one. Client developer demands prod access because he used Entity Framework and now EFW has to manage the production database design. It gets better - EFW has to have sysadmin access so he can manage the server as well as the database schema from the application.

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

BLOB EATER SSChampion Points: 14609 More actions · Answer 8

Jeff Moden (9/13/2016)
Don't know if I can sway you one way or another but I've found an extreme advantage to posting and writing articles on SSC and that advantage is the Community here. There is no way that I could have learned as much over the years if I posted my articles on a private blog. One of the great examples of what I mean can be found in the discussion on the article I wrote about reducing multiple adjacent spaces to one. The method I used worked great compared to what I was used to seeing. Then a whole bunch of people jumped in on the discussion and I ended up learning of the amazing power and speed of nested REPLACEs and a nasty fast solution was revealed complete with some of the most thorough testing I've ever witnessed. Same happened on the TALLY OH! article. Lot's of good folks made additional suggestions and, as a result, the community built function known as DelimitedSplit8K has never been faster until 2012 came out and Eirikur Eiriksson came out with a improvement that made even that twice as fast.
Then there are a ton of folks that have written based on something they saw on this site and have come up with new things to do using "old" methods... Pattern Splits, N-Grams, different ways to generate other-than-flat test data, to name a ffew. The list goes on.
Like I've said so many times, "You've just got to love this community" and I think I personally wouldn't have learned as much without it and I'm pretty sure that level of interaction wouldn't have occurred on any blog I may have written... which is why I don't have my own blog. 🙂

Thanks for your input - much appreciated.

Kingston Dhasian SSCoach Points: 19799 More actions · Answer 9

How would somebody respond to this? The last statement of the OP is a cruel joke.

http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 10

Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.
http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx

Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.

😎

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 11

Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.
http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
😎

After reviewing all other contributions of the poster to the forum, I tried my hand at a reply.

99% chance that I will either (a) not get any response or, (b) get a polite and meanningless "thank you", or (c) get a reply that roughly translates into an insult. Only 1% chance that they'll actually act on my recommendation and than, after a few days, get back to me with a follow up question that actually shows that effort has been put in.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 12

Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.
http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
😎

The questions are certainly very odd. A manager who knows FA about SQL Server wants some information, and has asked someone else who also knows FA (but slightly more than the manager) to collect it.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 13

ChrisM@Work (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.
http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
😎
The questions are certainly very odd. A manager who knows FA about SQL Server wants some information, and has asked someone else who also knows FA (but slightly more than the manager) to collect it.

My bet's on 'performance problem and flailing around'

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

jasona.work SSC Guru Points: 50117 More actions · Answer 14

GilaMonster (9/14/2016)
ChrisM@Work (9/14/2016)
Eirikur Eiriksson (9/14/2016)
Kingston Dhasian (9/14/2016)
How would somebody respond to this? The last statement of the OP is a cruel joke.
http://www.sqlservercentral.com/Forums/Topic1817507-3739-1.aspx
Makes you wonder what the purpose is and English certainly not being OP's first language doesn't make it easier.
😎
The questions are certainly very odd. A manager who knows FA about SQL Server wants some information, and has asked someone else who also knows FA (but slightly more than the manager) to collect it.
My bet's on 'performance problem and flailing around'

Almost smells like a "let's find the stuff that doesn't seem to be used and drop / delete it" sort of question...

Or is that my cynicism showing through again?

Neil Burton SSC-Insane Points: 23002 More actions · Answer 15

Lynn Pettis (9/13/2016)
drew.allen (9/13/2016)
I think someone is in way over their head. Maybe we should just tell him to find another line of work.
Drew
Who?

He's busted me...

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 http://www.sqlservercentral.com/articles/Best+Practices/61537