December 8, 2010 at 2:29 am
Grant Fritchey (12/7/2010)
GSquared (12/7/2010)
Steve Jones - SSC Editor (12/7/2010)
Brandie Tarvin (12/7/2010)
I have to wonder if this thread is encouraging people to respond more harshly to articles, posts, etc. Certain we've seen an uptick amongst ourselves of bashing other posters. But today I see this in response to one of Jeff's articles.Mike McIver (12/7/2010)
Really . . . I don't know where to start. <CommentCutting> This article is an example of how poor coding propagates...We know the old saying. There's a critic in every crowd. Several of us have already responded to this post, but I wonder how many of us would have answered the way we did if that second comment weren't inserted into the respondent's reply.
Are we propagating bad internet / forum behavior? This thread can be seen by anyone, remember. Even those who don't have an SSC login.
I have been a little concerned about this, trying to keep an eye on it. There is a little "piling on" at times, and I'm not sure if it's good or bad. On one hand I like to see people supporting others, or emphasizing that more information is needed. Easy for an OP to dismiss one person. However when it becomes 4 or 5 people, I think it can be a little intimidating.
I've noticed the same thing, and have been working to avoid it.
Same here. It's even a part of my limiting the number of posts I make to The Thread.
If someone posts something - anything apart from humour - which is false, it should be pointed out and a correction posted. We're all free to participate at either end of the stick. However, some of the cr@p in Jeffs discussion is bordering on deliberate baiting. He made the shortcomings of ISNUMERIC very clear and offered an alternative, pointing out that it won't be viable in every case but could be used as the basis of a viable solution. That's been ignored. Jeff's coped well with this of course, having run the discussion gauntlet many times before, but it won't be quite so easy for first-time article writers.
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
December 8, 2010 at 5:11 am
Tom.Thomson (12/7/2010)
Brandie Tarvin (12/7/2010)
I have to wonder if this thread is encouraging people to respond more harshly to articles, posts, etc. Certain we've seen an uptick amongst ourselves of bashing other posters. But today I see this in response to one of Jeff's articles.Mike McIver (12/7/2010)
Really . . . I don't know where to start. <CommentCutting> This article is an example of how poor coding propagates...I've seen that sort of attack on Jeff's articles quite often; there are those, unfortunately, who don't believe in writing whatever works efficiently with checks to make sure you know (before it causes any problems) if it stops working. A pity, but we have to live with them. What you quote is fairly mild compared to some of the nonsense that we've seen before. (Incidentally, a URL would be useful to save messing around with google - especially as google returns no results for what you quote).
Tom, I included the link in the words "This article". But the quote code makes the bold hard to see, I guess.
December 8, 2010 at 5:12 am
Given Steve's editorial yesterday (or sometime...) on the voting machine presentation from TED talks, I thought this Joy of Tech comic this morning very appropriate and funny.
December 8, 2010 at 6:15 am
Tom.Thomson (12/7/2010)
Roy Ernest (12/7/2010)
jcrawf02 (12/7/2010)
Where do space aliens outsource to?India... 🙂
Nonsense. They outsource to Hollywood.
That wouldn't be "out"-sourcing, now would it?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 8, 2010 at 7:35 am
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291
I signed up to hear what he says.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
December 8, 2010 at 7:40 am
jcrawf02 (12/8/2010)
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291I signed up to hear what he says.
Yeah, I'm looking forward to that one too. I wonder if I can stream it over my phone so I can listen while driving home? May have to try.
"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
December 8, 2010 at 9:51 am
Grant Fritchey (12/8/2010)
jcrawf02 (12/8/2010)
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291I signed up to hear what he says.
Yeah, I'm looking forward to that one too. I wonder if I can stream it over my phone so I can listen while driving home? May have to try.
Headline: "Man flips car on icy road when Autoshrink proven to be beneficial"
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
December 8, 2010 at 9:54 am
jcrawf02 (12/8/2010)
Grant Fritchey (12/8/2010)
jcrawf02 (12/8/2010)
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291I signed up to hear what he says.
Yeah, I'm looking forward to that one too. I wonder if I can stream it over my phone so I can listen while driving home? May have to try.
Headline: "Man flips car on icy road when Autoshrink proven to be beneficial"
So, if a DBA goes crazy in his car, does he need an Autopshrink?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 8, 2010 at 11:06 am
Grant Fritchey (12/8/2010)
jcrawf02 (12/8/2010)
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291I signed up to hear what he says.
Yeah, I'm looking forward to that one too. I wonder if I can stream it over my phone so I can listen while driving home? May have to try.
I wonder if it will be recorded for later consumption...
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
December 8, 2010 at 12:30 pm
CirquedeSQLeil (12/8/2010)
Grant Fritchey (12/8/2010)
jcrawf02 (12/8/2010)
Did you guys see this? Presentation later today on how "shrinking...can be a best practice"? https://www2.gotomeeting.com/register/974801291I signed up to hear what he says.
Yeah, I'm looking forward to that one too. I wonder if I can stream it over my phone so I can listen while driving home? May have to try.
I wonder if it will be recorded for later consumption...
Only in a compressed format.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 8, 2010 at 1:30 pm
I think this one is a case of mis-representation for the sake of advertising a presentation. "Best Practices" are not situations where you apply "It Depends" to outliers in the world of SQL databases. The fact that something CAN be done IF you need it as a LAST RESORT on an OUTDATED system is hardly a "Best Practice".
Oh well. He's a decent presenter, at least.
*Edit - ok, his comment about table variables made me change my mind. Vague statements about "table variables are almost always better than temp tables" with no testing, in light of all the stuff that's gone on already with testing, swing and a miss.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
December 8, 2010 at 1:40 pm
Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of you that shouldn't submit. Here's the link, http://www.sqlpass.org/sqlrally/2011/SubmitToSpeak.aspx
Edit: had wrapped the link in a code block instead of url. Doh :crazy:
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
December 8, 2010 at 2:11 pm
Jack Corbett (12/8/2010)
Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of you that shouldn't submit. Here's the link, http://www.sqlpass.org/sqlrally/2011/SubmitToSpeak.aspxEdit: had wrapped the link in a code block instead of url. Doh :crazy:
You're assuming we're going to be remotely near Florida... I should probably sign up to the site at some point, though... 😀
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 8, 2010 at 2:27 pm
Jack Corbett (12/8/2010)
Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of you that shouldn't submit. Here's the link, http://www.sqlpass.org/sqlrally/2011/SubmitToSpeak.aspxEdit: had wrapped the link in a code block instead of url. Doh :crazy:
I submitted a list of my jokes but they all got turned down. 🙁
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]
December 8, 2010 at 2:27 pm
Jack Corbett (12/8/2010)
Hey guys, I don't see any threadizens on the list of submissions to SQLRally yet! What's taking y'all so long. There isn't any of you that shouldn't submit.
Yeh volunteering to pay air fare? I already have one USA and one European trip planned, and that's just until April. $1500 for the USA flights, $1000 for the ones to Europe.
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
Viewing 15 posts - 22,261 through 22,275 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply