Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 52,861 through 52,875 (of 66,712 total)

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

They're probably not posting and just sitting back and waiting for someone to write the code for them. It's become all too common, but it's still sad.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Phil Parkin SSC Guru Points: 246960 More actions · Answer 2

I know ... my XML skills are not up to it and I wasn't excited to make them so!

Alan B has had a bash and the OP seems to be happy ... so far.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

I don't know if anyone is aware of this but I noticed Dwain Camps hadn't posted anything in awhile so I checked his blog (dwaincsql.com), simple-talk, twitter, linkedin... then came across this while searching for him on Facebook.

I'm absolutely heartbroken.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Sean Lange SSC Guru Points: 286590 More actions · Answer 4

So sad!!! I too had been wondering why we haven't heard anything from him. The world of sql server has lost a great contributor.

_______________________________________________________________

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/

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

Oh, my. He was a good long distance friend and a great human. I'm not just sad to lose a friend... I'm sad that the world has lost another one of the truly good guys.

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 6

Oh my God, this is so sad. I have no words.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

+1

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 8

Damn. That's hard. Sorry for the family.

"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

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

Here is to a good friend though we never met. You will be missed.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

I never got to meet Dwain and only knew him through his writing. He will definitely be missed.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Wow oh wow

That really sucks. Dwain is a good guy.

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 12

Wow, that's crushing. Never got to shake his hand, but exchanged lots of messages and emails.

RIP, Mr. Camps.

Stuart Davies SSCoach Points: 19505 More actions · Answer 13

Even though I only knew him through here it is a sad day indeed.

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

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

Oh heck. I knew he was unwell, we talked by email up until November or something. At that time his docs were telling him it was sciatica affecting his legs & back. I followed up with an email in December with no reply. I assumed he was so under the weather that he just didn't feel up to replying.

Stunned. He was fantastic to work with, intelligent, curious, inventive and upbeat. I've lost a friend, and the community has lost a unique member.

Rest in peace geezer.

^{“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

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 15

Jo Pattyn

SSC-Dedicated

Points: 32347

February 24, 2016 at 2:17 am

#1860647

RIP Dwain