February 24, 2009 at 8:13 am
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
February 24, 2009 at 8:17 am
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.
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
February 24, 2009 at 8:17 am
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!) π
February 24, 2009 at 8:19 am
Oops, a big failure there for me on trying to quote other people...
February 24, 2009 at 8:28 am
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
February 24, 2009 at 8:42 am
I just answer "do what Jeff said" and go on my way :hehe:
February 24, 2009 at 9:00 am
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
February 24, 2009 at 9:10 am
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
February 24, 2009 at 9:39 am
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
February 24, 2009 at 9:43 am
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
February 24, 2009 at 10:49 am
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
February 24, 2009 at 3:09 pm
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?
February 24, 2009 at 3:30 pm
Has anyone started an "Are the posts on the 'Are the posted questions getting worse?' thread getting worse" thread yet?
February 24, 2009 at 3:35 pm
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...
February 24, 2009 at 3:42 pm
hmmmm.....
First there was The Thread.
Then came Son of the Thread.
NO!!!!!!
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]
Viewing 15 posts - 1,936 through 1,950 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply