Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 1,936 through 1,950 (of 66,712 total)

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

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

Derek Dongray (2/24/2009)
Maybe the posted questions have stopped getting worse and OPs are starting to ask sensible questions with well-formatted sample data?

More likely, everyone was so busy chatting about favourite books that no one answered any questions

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

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

Lynn Pettis (2/24/2009)
Alvin Ramard (2/24/2009)
Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house employee.
I believe that is a FORMER White House employee.

I reckon it's a farmer. But it could be a toilet-cleaner, there's some Cockney in there.

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

rodjkidd SSCoach Points: 15915 More actions · Answer 3

Derek Dongray (2/24/2009)
--------------------------------------------------------------------------------
Maybe the posted questions have stopped getting worse and OPs are starting to ask sensible questions with well-formatted sample data?

More likely, everyone was so busy chatting about favourite books that no one answered any questions

--------------------------------------------------------------------------------

Gail Shaw

Nice one Gail - there is probably quite a few people thinking "Whay has no one answered my question, was really that complicated or dumb?"

I must admit I've only looked at this thread today, not that I can answer most of the questions or have the patience of you, Lynn and Gsquared (amounst others!) 🙂

rodjkidd SSCoach Points: 15915 More actions · Answer 4

Oops, a big failure there for me on trying to quote other people...

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 5

More likely, everyone was so busy chatting about favourite books that no one answered any questions.

Not true, Gail!! I even got into a dispute with Jeff about concatenation!!

Of course, productivity at my day job suffered yesterday.....

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Steve Jones - SSC Editor SSC Guru Points: 736173 More actions · Answer 6

I just answer "do what Jeff said" and go on my way :hehe:

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 7

I just answer "do what Jeff said" and go on my way

Sure... spoil my fun... 😉

Steve, it wasn't really a dispute. I'm trying hard to adopt the philosophy of not having an opinion that isn't backed by experience and/or test results. Jeff was asking the OP why concatenate in T-SQL at all, instead of just delivering the raw data and letting the UI handle the concatenation. The tests I ran suggest (to me anyway) that it really isn't enough extra work to worry about.

Now I have to apologize for actually bringing up T-SQL in a thread that is about everything BUT....

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

Bob Hovious (2/24/2009)

The tests I ran suggest (to me anyway) that it really isn't enough extra work to worry about.

It's not just about work. It's about doing things where they make sense. Let the database do what it's good at (manipulating data) and let the presentation layer do what it's good at (presenting data)

Same argument for why web service calls don't belong in a CLR procedure (it's a database, not an application server) and why dates shouldn't be formatted in the database.

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 9

Gail, can I respond to the "doing things where they make sense" through an email or something? I think there is a case where it does make sense, but I hate to turn this fun thread into another place for technical discussion.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

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

Bob Hovious (2/24/2009)
Gail, can I respond to the "doing things where they make sense" through an email or something? I think there is a case where it does make sense, but I hate to turn this fun thread into another place for technical discussion.

Why don't you start a thread in the Strategies forum?

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 11

Why don't you start a thread in the Strategies forum?

Just did, thanks 🙂

http://www.sqlservercentral.com/Forums/Topic663702-49-1.aspx

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

LutzM SSC Guru Points: 107049 More actions · Answer 12

Lynn Pettis (2/24/2009)
Alvin Ramard (2/24/2009)
Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house employee.
I believe that is a FORMER White House employee.

Isn't it a coincidence that "somebody" is claiming to be a former WhiteHouse employee shortly after a new guy just started a job at the very same location?

What are the chances of this fellow now trying to work in the IT business after he figured that neither shoe-catching nor a job in his daddy's business would fit into his interests?

Maybe his intention was to clean windows and he just picked up the wrong definition from wiki?

And doesn't "IT" also stand for "Industrial Tourism"?

So, an "it-pro at windows" would not necessarily have anything to do with computers... Right?

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 13

Has anyone started an "Are the posts on the 'Are the posted questions getting worse?' thread getting worse" thread yet?

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

Michael Valentine Jones (2/24/2009)
Has anyone started an "Are the posts on the 'Are the posted questions getting worse?' thread getting worse" thread yet?

Not yet, but I wouldn't be surprised if The Thread started one soon...

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 15

hmmmm.....

First there was The Thread.

Then came Son of the Thread.

NO!!!!!!

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]