I love statistics. No SQL, of course. Some about our Forum: Members with no post: 44,22% Members with no countries: 49,78% Number of differentes countries: 83[:0] Members with countries: 1) USA : 38,95% 2) India : 14,31% 3) UK : 10,77% 4) Canada : 3,85% 5) Australia: 2,61% Rest of 78 : 29,51% (Yes, I have details[8D]) Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I bet if you look at the number of postings, the skew will be in UK's side [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1"><br /><font size="1">The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.</font id="size1">
As you know, when we work with statistics, we have to eliminate values outside of population, specially high values[}<img src='/community/emoticons/emotion-1.gif' alt='' />]. If we don't keep that value (Because is to weird), USA win[<img src='/community/emoticons/emotion-5.gif' alt='' />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All postings are provided “AS IS†with no warranties for accuracy.</font id="size1"><br /><br />
I suppose the quite half of the group would also most likely be the ones without a 'public' residence. In life, anonymity always precedes silence and lurking is never really considered polite. The membership and activity herein just reflects the obvious: technology drives need - for whatever. Language (English) is also a major factor in the current distribution of the statistics here. I always knew I would be 'a statistic' one day. Nathan H.O. Moderator SQL-Server-Performance.com
And I didn't realize how widespread SQL server 'problems' were. While you are still in a statistical mood, Luis, would you please give us the tally of posts by category by region (country or continent). It would be interesting to have a qualitative look at the implementation of Server-based solutions - albeit from the problematic point of view. Please oblige us. Nathan H.O. Moderator SQL-Server-Performance.com
Nathan: Give me a couple of days, meantime, you are top in post/country relation. Why?, Because from Kenya we have one, you. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
What a low turn out from Canada. A bit surprising I think. Glad I'm here when I can be (which isnt often enough sometimes) chris
Luis aka Stats guru I appreciate your interest in providing such stats and information other than SQL Server[8D]. quote:Originally posted by LuisMartin I love statistics. No SQL, of course. Some about our Forum: Members with no post: 44,22% Members with no countries: 49,78% Number of differentes countries: 83[:0] Members with countries: 1) USA : 38,95% 2) India : 14,31% 3) UK : 10,77% 4) Canada : 3,85% 5) Australia: 2,61% Rest of 78 : 29,51% (Yes, I have details[8D]) Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Here's some more stats, for stat's fans. These are from my website logs: Percent of Visits by Continent: North America, 56.36% Europe: 22.27% Asia: 12.31% Oceania (Australia): 4.41% South America: 3.71% Africa: .94% Antarctica: 0% ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com
Next I would like to represent from Antartica to keep on the list [<img src='/community/emoticons/emotion-2.gif' alt='' />][8D]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by bradmcgehee</i><br /><br />Here's some more stats, for stat's fans. These are from my website logs:<br /><br />Percent of Visits by Continent:<br /><br />North America, 56.36%<br />Europe: 22.27%<br />Asia: 12.31%<br />Oceania (Australia): 4.41%<br />South America: 3.71%<br />Africa: .94%<br />Antarctica: 0%<br /><br />-----------------------------<br />Brad M. McGehee, MVP<br />Webmaster<br />SQL-Server-Performance.Com<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS†with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
Satya, you would quickly discover that no amount of posting can unfreeze a rock-hard sub-zero database. You would be doomed eternally to using Analysis services with ice cubes and rollup jackets. Just stick with the good 'ol Queen. Nathan H.O. Moderator SQL-Server-Performance.com
Well, I allways think: I live in wrong place. If it rains soup, I have a fork in the hand. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Consider yourself lucky, I know folks who can't tell the difference between a fork and the hand. Madonna knew better when she said "Don't Cry Me Argetina" in Evita. Nathan H.O. Moderator SQL-Server-Performance.com
Nathan. you make me laugh for the first time in a day. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Brett, are you from Kansas City? If you are, I wonder what percent the US would have if we took out KC. lol MeanOldDBA derrickleggett@hotmail.com When life gives you a lemon, fire the DBA.
Nathan [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />I tried to carry on fun on the terms of Antartica and I've no plans to visit that continent .... enough frozen with Scottish weather.<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by vbkenya</i><br /><br />Satya, you would quickly discover that no amount of posting can unfreeze a rock-hard sub-zero database. You would be doomed eternally to using Analysis services with ice cubes and rollup jackets. Just stick with the good 'ol Queen.<br /><br />Nathan H.O.<br />Moderator<br />SQL-Server-Performance.com<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS†with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
Perhaps you could help out with the African count. It is always summer here and there are no complex SQL Server issues to grapple with: Just the occasional slow internet connection and the risk of your post timing out on Brad's server. Welcome. Nathan H.O. Moderator SQL-Server-Performance.com
I would like to know Africa........, and England, Italy, France, Germany,......[8D] Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Hey Luis,<br />sorry for passing by here that late....<br /><br />If you ever happen to visit Germany, don't forget to give me a call. Would be really nice to share a real beer with you [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />What I think is really interesting about your stats is the percentage of members with no post at all. Would be interested if posts are log normal distributed and what standard deviation there is...So , if you have the time... [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
Btw, the top 10 posters account for roughly two-third of all posts (61,85%) and you need to have more than 135 posts to make it to the first page of the member list. --Frank http://www.insidesql.de
I love Germany beer[8D]. About log normal distributed and standard desviation, statistics are very old now. I have to start again from the begining (and statistics was made page by page!!!!) I you have a way (Brad's way) to have an excel with all data, I'll be happy to do that. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
That's no art then anymore, Luis. That's just applying Excel to the data [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br />Btw, I prefer Czech Budweiser for that matter...<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br />If you ever happen to visit Germany, don't forget to give me a call. Would be really nice to share a real beer with you [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />I think you'll find that German beer is extremely poor in relation to English Beer (or even Scottish / Welsh Beer at that). The UK is without doubt the best producer of beer in the world.[<img src='/community/emoticons/emotion-2.gif' alt='' />]
Nice joke Dave,<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">I think you'll find that German beer is extremely poor in relation to English Beer (or even Scottish / Welsh Beer at that). The UK is without doubt the best producer of beer in the world.[<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />you english guys should finally learn to use a fridge for beer.<br />And note, my favorite beer is Czech!!!<br /><br />While we're at it. You guys have already done enough damage to the world when inventing black pudding<br /><br /><img src='http://www.insidesql.de/images/angel-smiley-027.gif' border='0' /><br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
...and satya. <br /><br />Can't I even type without missing a post???<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /><br />That was the smilie, I forgot to post...<br /><img src='http://www.insidesql.de/images/technik010.gif' border='0' />
<img src='http://www.insidesql.de/images/trinken027.gif' border='0' /><br /><br />Hey satya, that's not fair!!! I wasn't offended in any way, just forgot the usual smilie in my post. <br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
Thanks Frank.... then here you go.. quote: quote: -------------------------------------------------------------------------------- Originally posted by FrankKalis If you ever happen to visit Germany, don't forget to give me a call. Would be really nice to share a real beer with you -------------------------------------------------------------------------------- I think you'll find that German beer is extremely poor in relation to English Beer (or even Scottish / Welsh Beer at that). The UK is without doubt the best producer of beer in the world.... true in the case of beer taste.. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Originally posted by FrankKalis you english guys should finally learn to use a fridge for beer. And note, my favorite beer is Czech!!! While we're at it. You guys have already done enough damage to the world when inventing black pudding But if we stocked up the fridge with beer we wouldn't have anywhere to keep the black pudding! Or white pudding even, which is even more disgusting.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />But if we stocked up the fridge with beer we wouldn't have anywhere to keep the black pudding!<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />You have a point here! [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />Or white pudding even, which is even more disgusting.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Did you sell this to the US ?<br /><br /<a target="_blank" href=http://news.bbc.co.uk/1/hi/england/suffolk/3389957.stm>http://news.bbc.co.uk/1/hi/england/suffolk/3389957.stm</a><br /><br />[<img src='/community/emoticons/emotion-3.gif' alt='' />)]<br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
I prefer German beer, England Scottish and Argentina Red Wine[<img src='/community/emoticons/emotion-5.gif' alt='' />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All postings are provided “AS IS†with no warranties for accuracy.</font id="size1"><br /><br />
How can anyone say Black Pudding is disgusting! MMMMmmm, fried pigs blood, lovely. Can you break down the United Kingdom statistics to tell us how many are Scottish, and how many are English? I'm Scottish obviously, and I guess Satya is too, but a break down would be nice if possible. Come to think of it, Satya are you a Glasgow ned or an Edinburgh casual? Dave Hilditch.
I'm Scottish obviously, and I guess Satya is too, but a break down would be nice if possible. Come to think of it, Satya are you a Glasgow ned or an Edinburgh casual? Dave I'm an Indian settled in Edinburgh and rather prefered as Edinburgh casual... how about you. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Originally posted by dhilditch How can anyone say Black Pudding is disgusting! MMMMmmm, fried pigs blood, lovely. When you expect some kind of dessert for breakfast, you are at least very suprised. Well, I was... --Frank http://www.insidesql.de
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin</i><br /><br />I prefer...Argentina Red Wine[<img src='/community/emoticons/emotion-5.gif' alt='' />].<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Cheap stuff in most cases. Here in Germany Spanish Gran Reserva wine is sold at a reasonable price and is of excellent quality. Aah, red wine...almost always preferable to beer, imho!<br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
quote:Originally posted by FrankKalis Aah, red wine...almost always preferable to beer, imho! Certainly preferable to German beer. But you can't compare it to English Beer when you have such fine beers as this http://www.camra.org.uk/SHWebClass.ASP?WCI=ShowDoc&DocID=8621 Having said that though, German beer is in general much nicer than the worst of English brewed rubbish.
I don't know what German beer they sell to your country and what they give the tourists here to drink, but I certainly agree with you when you speak of Bavarian beer.<br />Anyway, time again for some smilies [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br /><img src='http://www.insidesql.de/images/trinken026.gif' border='0' /><br /><br />Cheers!<br /><br /><img src='http://www.insidesql.de/images/trinken027.gif' border='0' /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
I'm a dunfermline guy settled in Glasgow. How do you find the chippies over there? Do you take chippy sauce with your chippies? Dave Hilditch.
Chippies are nice.... i've tried with sauce once .. was good though... but delecious. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Luis....while you are still busy trying to hack that Excel spreadsheet on the statistics, it would be interesting to know how many posts were NOT made under the influence (of beer, wine or any other liquid poison). Kenyan Beer? No comment....but I know a few folks in South London (UK) who have been heard singing praises long after the hangover is gone. Nathan H.O. Moderator SQL-Server-Performance.com
NOT made under the influence (of beer, wine or any other liquid poison)?<br />No a single one[<img src='/community/emoticons/emotion-2.gif' alt='' />].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All postings are provided “AS IS†with no warranties for accuracy.</font id="size1"><br /><br />
I guess the last one is a typo, right? Did you mean: No a single malt? --Frank http://www.insidesql.de
No I mean: No a single wine. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
quote:Originally posted by LuisMartin No I mean: No a single wine. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy. Hey, you've deleted one!!! quote: NOT made under the influence (of beer, wine or any other liquid poison)? No a single one. Are you sure on this? --Frank http://www.insidesql.de
Yes, under wine influence, I wrote win instead wine. May be is time to change wine for beer. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Bier auf Wein, das laß sein<br />Wein auf Bier, das rate ich Dir.<br /><br />...as we say in Germany. Happy googling!<br /><br />[<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
Ich kann zwar kein Niederländisch, aber es ist nicht schwer, den Sinn zu erkennen. <br />I guess after drinking enough beer or wine, I can understand and perfectly speak Dutch [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
I feel its time to move this thread to Lighter side of DBA section... .and to continue. Any Scotch lovers out there????? Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Is this a trick question? [<img src='/community/emoticons/emotion-5.gif' alt='' />]<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
I guess when you understand enough German you've probably sobered up sufficiently for exhuming that aura of professionalism (Reichseisenbahnhauptbahnhofweichenhinundherschieber, surely).
I suggest we better forget it and blame it on the virtual alcohol [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
Back to statistics, here are some in regard to the free logowear I am giving away. I just mailed out 14 packages today, so if you have posted 250+ messages, you should see a package arrive at your door soon. Of these 14 packages, 4 went to the US, 3 to the UK, 2 to Canada, and the rest to other countries. These included Mexico, Sweden, Germany, Argentina, and Italy. These 14 packages had 30 different shirts as awards. The two top posters, each of which received 4 shirts, was Satya and Luis. The most expensive package to ship was to Luis, who lives in Argentina. It cost US $29.45 to send. ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com
Thanks a lot Brad. Luis Martin Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Strike! [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />Strange, but now that I know this, I'm _really_ curious what the clothes will look like.<br /><br />Thanks from me, too!!!<br /><br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
Thanks for the workout & prizes SantaClaus(Brad).... Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Argyle</i><br /><br />It's early Christmas <img src='http://img.adbdagiset.com/mix/xmas.gif' border='0' /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />That's a nice one! I've added it to my library<br /><br /><img src='http://www.insidesql.de/images/huepfer017.gif' border='0' /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
All the clothing came out great. Land's End, the company who makes the clothing, does a good job. I am even wearing my first logo shirt today at work. ----------------------------- Brad M. McGehee, MVP Webmaster SQL-Server-Performance.Com
U should have announced this earlier brad, I would have caught up wih my post count...... [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1"><br /><font size="1">The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.</font id="size1">
I just got my shirt. I'm wearing it to work tomorrow. <img src='/community/emoticons/emotion-1.gif' alt='' /> Thanks Brad.<br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
Gaurav#<br /><br />You should really catch up the forum.. nowadays you seems to be side-tracked.<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by gaurav_bindlish</i><br /><br />U should have announced this earlier brad, I would have caught up wih my post count...... [<img src='/community/emoticons/emotion-2.gif' alt='' />]<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1"><br /><font size="1">The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.</font id="size1"><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS†with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
Brad & Derrick its time to update your profile with latest photo... and will follow others. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
I do read the posts most of the time but the work pressure of the new job doesn't allow much time for anything else. I'll try to be more frequent. Gaurav Moderator Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />Brad & Derrick its time to update your profile with latest photo... and will follow others.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS†with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Yeah, pun taken. I'll fix this once a got my shirt [<img src='/community/emoticons/emotion-1.gif' alt='' />]<br /><br />--<br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />