Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 44,011 through 44,025 (of 66,712 total)

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

Dwain Camps SSC Guru Points: 86948 More actions · Answer 1

SQLRNNR (5/23/2014)
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.

That picture predates my catch of the "giant fish."

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

TomThomson SSC Guru Points: 104773 More actions · Answer 2

dwain.c (5/25/2014)
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.

That "know about" doesn't specify how much knowledge - so your answer suggests you've never heard of "Transfer Fantastic Sums".

Everyone who has ever (in the last half dozen or so years, anyway) had to worry about costs in a development shop using MS tools knows that it is a cut back form of TFSTM (Transfer Fantastic Sums To Microsoft), shortened because they thought an FLA looked clumsier than a TLA. The marketeers then had to find a plausible three word phrase to fit the three letter form, and came up with Team Foundation Server.

edit: Of course it could also stand for Toyota Financial Services, Thanks For sharing, or Transactions on Fuzzy Systems (a popular IEEE Journal) or many other things.

Tom

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 3

TomThomson (5/26/2014)
dwain.c (5/25/2014)
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.
That "know about" doesn't specify how much knowledge - so your answer suggests you've never heard of it.
Of course everyone who has ever (in the last half dozen or so years, anyway) had to worry about costs in a development shop using MS tools knows that it is a cut back form of TFSTM (Transfer Fantastic Sums To Microsoft), used because they thought an FLA looked clumsier than a TLA. The marketeers then had to find a plausible three word phrase to fit the three letter form, and came up with Team Foundation Server.

Team Foundation $erver?

I am sure many 'know about' many things.

Although like me, many the depth of knowledge varies considerably.

Giving someone a problem to solve, and then having them verbally (or with a keyboard) describe a solution is much more telling than a linked in endorsement.

Just seeing how someone approaches the issue gives very good indication of how they can handle day to day challenges.

One of the more interesting tests I remember from high school - National Math Exam.

It was a mix of technical questions, along with some simple common sense questions.

Rare was the person who could ace this test.

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

Lynn Pettis

SSC Guru

Points: 442467

May 26, 2014 at 10:20 am

#1716507

I think the answer here is hire a consultant.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Lynn Pettis (5/26/2014)
I think the answer here is hire a consultant.

Not touching that one... 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Koen Verbeeck (5/26/2014)
Lynn Pettis (5/26/2014)
I think the answer here is hire a consultant.
Not touching that one... 🙂

Well, Jeff has braved it but didn't comment on the normalisation bit of the query, so I joined in too. But other than text book advice on where to go with normalisation (assuming that it's not some sort of data warehouse where denormalisation for performance isn't just plain irratonal) I too have nothing to say.

Tom

Jeff Moden SSC Guru Points: 1004354 More actions · Answer 7

GilaMonster (5/24/2014)
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.

Heh... I know what you mean. After such a thing, I sometimes lean into an electric fence just to get some feeling back. 😉

I can't wait for this one to come out. Thanks for taking the time to write it.

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

Jeff Moden SSC Guru Points: 1004354 More actions · Answer 8

TomThomson (5/26/2014)
Koen Verbeeck (5/26/2014)
Lynn Pettis (5/26/2014)
I think the answer here is hire a consultant.
Not touching that one... 🙂
Well, Jeff has braved it but didn't comment on the normalisation bit of the query, so I joined in too. But other than text book advice on where to go with normalisation (assuming that it's not some sort of data warehouse where denormalisation for performance isn't just plain irratonal) I too have nothing to say.

Heh... gettin' old. Apparently, I only have it in me to read 4 questions in the same post and didn't even see question 5. 😀

I went back and followed up on your good post, Tom.

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

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

Koen Verbeeck (5/26/2014)
Lynn Pettis (5/26/2014)
I think the answer here is hire a consultant.
Not touching that one... 🙂

Filing that one under 'barge pole'

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

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 10

J Livingston SQL (5/24/2014)
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/

Thanks for the temporary fix - I fixed the link in the original post.

Jason Wolfkill

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

Finally met Grant at Techorama. He was less scary than I imagined. Maybe because I subdued him with alcohol.

Compromising pictures will be posted later...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

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

I'm just lulling you into a false sense of security.

"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

rodjkidd SSCoach Points: 15915 More actions · Answer 13

Koen go to Karaoke with him - then he's scary! :w00t:

Rodders...

WayneS SSC Guru Points: 95460 More actions · Answer 14

rodjkidd (5/28/2014)
Koen go to Karaoke with him - then he's scary! :w00t:
Rodders...

Just thinking of Grant singing is scary!;-)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

WayneS (5/28/2014)
rodjkidd (5/28/2014)
Koen go to Karaoke with him - then he's scary! :w00t:
Rodders...
Just thinking of Grant singing is scary!;-)

Yeah it is

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