April 19, 2010 at 8:35 am
jcrawf02 (4/19/2010)
I don't know if I want anybody else's stinky feet in my shoes. gross.
Even if we make sure that they wear clean socks? 😛
April 19, 2010 at 8:50 am
Oh all right, clean socks. Hard to argue with your lovable wizened green face...:-D
---------------------------------------------------------
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."
April 19, 2010 at 8:59 am
anthony_merriwether (4/19/2010)
This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of line and unless you have developed psychic powers, have no right to question the motives or reasons of those who post. He who is without sin, cast the first stone. If you do not like the post, do not insult the inquirer an expose your arrogance, for lack of a better word... simply do not respond to the post inquirer. Above all, remember this is not your web site, so show respect for everyone. if you want to be respected. Seems to me that you should al have better things to do...like get back to work!
I may be mistaken, and my profound apologies if I am, but this post seems more like the post of a troll than anything else. The main contributors to this site do show respect. Everyone is given a chance. If a poster isn't professional on these forums, (whether new or a veteran of these forums) said poster gets jumped on for the lack of a professional manner.
The ones who don't get respect are those who have earned the disrespect. The disrespect is earned by repeatedly asking for answers without showing improvement or willingness to improve, just to have someone else do their work for them.
You say that unless the we have developed psychic powers that we have no right to question the posters. That's just the problem. We DON'T have psychic powers so that we can determine, at a distance with no data, just what the problem is and provide the correct answer. So, we have to rely on the old-fashioned way of posting questions to the Original Poster about the problem. And then hope that the psychic powers will activate so the reply can be understood.
-- Kit
April 19, 2010 at 9:11 am
Please do not resort to name calling. Seems that a few of you display your intellect in this way, which does not surprise me in the least. If you have nothing productive to say to me in response to my post, say nothing. I have made my point and I stand by it. Like it or not. Have a great day.
April 19, 2010 at 9:24 am
Jeff Moden (4/16/2010)
Heh.... famous last words would be... [font="Arial Black"]AHHHHH CRAP![/font]Just so you guys know... remember I said that I changed my cteTally code to use Gianluca's wonderful idea of using UNPIVOT instead of 10 SELECT 1 UNION ALL's??? Well, it turns out that it's quite machine dependent. I used it to do a million row split on a box at work and it came in at 4:18. Just to see how much faster it was, I also ran the old 10 SELECT code... the old code came in at 3:48!!!!!! The old code came in 30 seconds faster. I ran the test multiple times in disbelief.
I'm looking for the couple of posts I used the UNPIVOT code so I can post a correction. If you happen to run across the UNPIVOT code in your travels, send me the URL (please) so I can make a correction. Thanks, folks.
Gosh! I'm sorry, Jeff. I hope you caught all the posts and this caused no damage.
It would be interesting to know the reasons behind. Probably it's the same thing that made it run faster on my laptop, but it still is mysterious to me.
-- Gianluca Sartori
April 19, 2010 at 9:29 am
And, as stated before, this particular thread is like a water-cooler. We talk about everything in here without doing so directly in an OPs post. Respect is always shown (that I've seen anyway) until the OP no longer deserves it and Steve WILL step in if it crosses the line. And, as stated before, asking for additional detail allows most of us to provide viable, real solutions to stated problems. I'd rather have an answer that is spot-on, or reasonably close, to my issue than for a response that has no relevance to what I am trying to accomplish. This is a free site, nobody is contracted to ask or provide answers. It a bunch of good, quality SQL Server folks coming to assist and to have a little fun (read through this thread!!). Work can be, and is most times, stressful. This site allows us to blow off a little steam, to learn something new (I know I have!) and relax a bit. Plus, there are folks from all around the world contributing. You aren't going to get access to that vast array of knowledge in too many other places.
-- You can't be late until you show up.
April 19, 2010 at 9:33 am
anthony_merriwether (4/19/2010)
Please do not resort to name calling. Seems that a few of you display your intellect in this way, which does not surprise me in the least. If you have nothing productive to say to me in response to my post, say nothing. I have made my point and I stand by it. Like it or not. Have a great day.
I did not see anyone indulging in Name calling like you state. What you are trying to say is that you are right and no one in here can respond to your statements. That is not the way it should work...Right?
-Roy
April 19, 2010 at 9:51 am
If you do not see name caling, I suggest you read up a couple replies...things like 'Troll'. Last time I looked this is a noun by definition. Having cleared that up for you...let me end this meaningless and non productive dialogue by saying to you...I agree that some individuals post out of laziness. That is their perogative. If a person asks a question, either answer it or don't. That is your perogative, but to insult them is no ones province. I want to thank you all for your enlightening replies. I'm done with this... Have a great day.
April 19, 2010 at 9:58 am
anthony_merriwether (4/19/2010)
If you do not see name caling, I suggest you read up a couple replies...things like 'Troll'. Last time I looked this is a noun by definition. Having cleared that up for you...let me end this meaningless and non productive dialogue by saying to you...I agree that some individuals post out of laziness. That is their perogative. If a person asks a question, either answer it or don't. That is your perogative, but to insult them is no ones province. I want to thank you all for your enlightening replies. I'm done with this... Have a great day.
Exactly: meaningless and non productive.
I think we can stop it here.
-- Gianluca Sartori
April 19, 2010 at 10:01 am
Chris Morris-439714 (4/19/2010)
Paul White NZ (4/18/2010)
RBarryYoung (4/18/2010)
Yes, in binary. 😀010110010110010101110011
("yes" in binary)
Chortle 😀
Guffaw
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
April 19, 2010 at 10:02 am
Jack Corbett (4/19/2010)
Don't usually say this, but going to be in meetings for a few days, so I'll be even less active than I have been recently. Also have something going on every night this week until I head to Atlanta on Friday for SQLSaturday 41. Anyone else going to be there?
Not this year.
SQLSat in Orlando would be fun!!
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
April 19, 2010 at 10:08 am
CirquedeSQLeil (4/19/2010)
Jack Corbett (4/19/2010)
Don't usually say this, but going to be in meetings for a few days, so I'll be even less active than I have been recently. Also have something going on every night this week until I head to Atlanta on Friday for SQLSaturday 41. Anyone else going to be there?Not this year.
SQLSat in Orlando would be fun!!
I'm waiting for SQLSaturday in Orlando. I'm thinking that a few days of vacation in Orlando just before SQLSaturday might be a good thing.
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]
April 19, 2010 at 10:09 am
Lynn Pettis (4/19/2010)
anthony_merriwether (4/19/2010)
This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of line and unless you have developed psychic powers, have no right to question the motives or reasons of those who post. He who is without sin, cast the first stone. If you do not like the post, do not insult the inquirer an expose your arrogance, for lack of a better word... simply do not respond to the post inquirer. Above all, remember this is not your web site, so show respect for everyone. if you want to be respected.This has nothing to do with sin and everything to do with what some people do, or more precisely don't do, when posting questions on SSC or any of the other forums. If we choose to gripe about those posts on this particular thread, that is our choice. It allows us to vent our frustrations with others of a similar mind. In addition, if you have bothered to read this entire thread, you will also realize that it is more than a gripe session, it is actually a water cooler. We discuss much more than just bad posts, we ask each other to look at other threads where help is needed, we discuss issues of interest to each other beyond SQL Server.
Before you condemn us, perhaps you should walk in our shoes.
Interesting to condemn before having the facts straight - what was that about casting stones?
Please, my shoes are for my feet only - though many are more worthy than I to unloose my latchet.
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
April 19, 2010 at 10:12 am
Gianluca Sartori (4/19/2010)
anthony_merriwether (4/19/2010)
If you do not see name caling, I suggest you read up a couple replies...things like 'Troll'. Last time I looked this is a noun by definition. Having cleared that up for you...let me end this meaningless and non productive dialogue by saying to you...I agree that some individuals post out of laziness. That is their perogative. If a person asks a question, either answer it or don't. That is your perogative, but to insult them is no ones province. I want to thank you all for your enlightening replies. I'm done with this... Have a great day.Exactly: meaningless and non productive.
I think we can stop it here.
Late to the party - as you wish.
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
April 19, 2010 at 10:16 am
anthony_merriwether (4/19/2010)
This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of line
Well, your feelings are your own and no one can question them.
Your statements read as fact, which, unless you can back them up, you might want to consider rewording.
and unless you have developed psychic powers, have no right to question the motives or reasons of those who post. He who is without sin, cast the first stone. If you do not like the post, do not insult the inquirer an expose your arrogance, for lack of a better word... simply do not respond to the post inquirer.
Which is what a lot of people on here do, regularly. If you really do read through the events that have taken place over the year plus since this thread was started, you'll find that in many instances this place acts as a rallying point for getting MORE help to people, not less.
Above all, remember this is not your web site, so show respect for everyone. if you want to be respected. Seems to me that you should al have better things to do...like get back to work!
Respect is a two-way street. If you wanted to start a dialogue, you might have tried a different approach. As it is, your tone has probably caused many here to dismiss what you say out of hand. Not the best way to teach.
"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
Viewing 15 posts - 14,491 through 14,505 (of 66,742 total)
You must be logged in to reply to this topic. Login to reply