SQL Server Performance

Did anyone notice?

Discussion in 'The Lighter Side of Being a DBA' started by FrankKalis, Jan 5, 2006.

  1. FrankKalis Moderator

    Did anyone noticed that we silently crossed another barrier today?
    Have a look at the forum homepage and the number of members.

    We've crossed the 10k!

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  2. Madhivanan Moderator

    Thats really cool. You are other Statistician of this forum. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br /><b>4148 of 10000 Members have made 56010 posts in 39 forums, </b><br /><br />I wonder why more than half of members didnt post at least a single post<br />Anyway I hope they regularly visit and read the threads<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  3. ranjitjain New Member

    Yeah, wooppy<br /><br />Its indeed a gr[8] achivement for SSP[<img src='/community/emoticons/emotion-1.gif' alt=':)' />][<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  4. FrankKalis Moderator

    Well, maybe. Actually I just read the numbers. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  5. ghemant Moderator

    Hi,<br />Thats really nice <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />Hemantgiri S. Goswami<br />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami<br />
  6. Luis Martin Moderator

    Frank:<br />Can you live the statistics work for "The official statistics man in the Forum"[<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  7. FrankKalis Moderator

  8. Luis Martin Moderator

    Well, we can create a new section and make a survey to find out[<img src='/community/emoticons/emotion-3.gif' alt=':eek:' />)].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  9. FrankKalis Moderator

    Brilliant idea! But first we should build a project team to plan further steps. [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  10. dineshasanka Moderator

  11. satya Moderator

    GOod to see a new milestone in new year, good to see members are matching to my post count [8D].

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  12. FrankKalis Moderator

    Oh no, not again that topic. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  13. Luis Martin Moderator

    Is a virus Frank[<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  14. FrankKalis Moderator

    Okay, let's change reality then a bit. <br />Based on my verified reliable internal statistic, I will catch up with satya in June 2011.<br /><br />.<br />.<br />.<br />.<br />.<br />.<br />.<br />.<br />.<br />.<br />.<br />Now, don't ask about the time span over which I collected my data. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  15. FrankKalis Moderator

    Look, the above post brought it down to October 2010. [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  16. bradmcgehee New Member

    Great job everyone on reaching this great milestone. So what is the prediction (time) when we reach 100,000 members?

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  17. Luis Martin Moderator

    Can you give us some data?<br /><br />Number of members Dic 2003 and 2004.<br /><br />BTW: When Satya get 100000 post[<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  18. benwilson New Member

    that is a great achievement!<br /><br />hmmm...sounds like we need a project advisory committee and a project advisory committee advisory committee before we can think about planning...<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 FrankKalis</i><br /><br />Brilliant idea! But first we should build a project team to plan further steps. [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />'I reject your reality and substitute my own' - Adam Savage
  19. Luis Martin Moderator

    Ben<img src='/community/emoticons/emotion-2.gif' alt=':d' />on't forget sponsors[<img src='/community/emoticons/emotion-5.gif' alt=';)' />].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  20. FrankKalis Moderator

    Haha, sometimes even Dilbert can't keep up with reality. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  21. satya Moderator

    <br />THe count of 100,000 member will be reached by 2039[:0].<br />For joy I will maintain my count as similar to number of members count[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-5.gif' alt=';)' />][<img src='/community/emoticons/emotion-4.gif' alt=':p' />].<br /><br />I'm glad to see the threads are replied as soon as they are posted with brilliant workaround. I can see the forum is in good hands...[^]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote">Oh no, not again that topic. <br /><br />Great job everyone on reaching this great milestone. So what is the prediction (time) when we reach 100,000 members?<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  22. Luis Martin Moderator

    By that time (2039) will be fine if I remember who am I[<img src='/community/emoticons/emotion-5.gif' alt=';)' />].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  23. Madhivanan Moderator

    &gt;&gt;For joy I will maintain my count as similar to number of members count<br /><br />I think yours will be always more than that [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />&gt;&gt;By that time (2039) will be fine if I remember who am I<br /><br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  24. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br />For joy I will maintain my count as similar to number of members count<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Haha, did you know that the postcount column is of type TINYINT? Once you've reached the upper limit, your account is locked and you have to register anew and start with 0. [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br /><br /><br />...just kidding...<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  25. Madhivanan Moderator

    >>did you know that the postcount column is of type TINYINT?

    TINYINT or SmallInt?

    Madhivanan

    Failing to plan is Planning to fail
  26. FrankKalis Moderator

    Good catch. Was probably due to a lack of coffee. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  27. FrankKalis Moderator

  28. Luis Martin Moderator

    <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 />Great job everyone on reaching this great milestone. So what is the prediction (time) when we reach 100,000 members?<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 />I was working on it. From 01/11 to 01/23 we have 29 new members in average.<br />Some days like 01/15 we have 7(sunday) but on 01/22 we have 78 (sunday).<br />Why? who knows.<br /><br />If we keep the average, some day in 2014 we get 100000.<br /><br />I think will be before that year, because I suppose the average will grow in the next months/years.<br /><br />No way with 2039!!!!![<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  29. Madhivanan Moderator

    Thats cool Luis [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  30. FrankKalis Moderator

    Btw, in on <s>31.12.2005</s> 31.12.2014 there might be the following postcount scenario (cetris paribus) possible:<br /><br />Satya: 41,301<br />Luis: 29,855<br />Myself: 33,316<br /><br />And on 31.12.2039<br /><br />Satya: 127,589<br />Luis: 101,533<br />Myself: 116,865<br /><br />Now, don't ask me if I think any scenario is realistic. Maybe we should start to factor in some advanced statistical probability calculation here. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  31. Madhivanan Moderator

    Is it 31.12.2005 or 31.12.2015? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  32. FrankKalis Moderator

    Corrected. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  33. Madhivanan Moderator

    I think you need more Coffee [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  34. FrankKalis Moderator

    Probably I need more sleep. I should tell my daughter to get her teeth only during the days and stop that thing at 18:00 in the evening for 12 hours. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  35. satya Moderator

    Yeah schedule that job during peak hours and to have peaceful night during offpeak hours [<img src='/community/emoticons/emotion-5.gif' alt=';)' />].<br />By 2014 & 2039 I'm sure my son or daughter would continue my practice in the forums [<img src='/community/emoticons/emotion-5.gif' alt=';)' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</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>
  36. Madhivanan Moderator

    &gt;&gt;I should tell my daughter to get her teeth only during the days <br /><br />How is Nina? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  37. FrankKalis Moderator

    Yesterday was her first birthday. She got her first hairgrip and hairband (?!? not sure if that's a correct word). You know, typical things one buy's for a girl. Soooo sweet...<br /><br />...and completely different from the boys. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  38. Madhivanan Moderator

    &gt;&gt;Yesterday was her first birthday<br /><br />Convey my regards to her [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  39. satya Moderator

    [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] glad to hear...that sounds like daddy's favourite...[:I]<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 /><br />Yesterday was her first birthday. She got her first hairgrip and hairband (?!? not sure if that's a correct word). You know, typical things one buy's for a girl. Soooo sweet...<br /><br />...and completely different from the boys. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  40. FrankKalis Moderator

    Thanks guys! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Satya, sure she is and don't try to tell me it's any different with you. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  41. Luis Martin Moderator

    <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 /><br />Yesterday was her first birthday. She got her first hairgrip and hairband (?!? not sure if that's a correct word). You know, typical things one buy's for a girl. Soooo sweet...<br /><br />...and completely different from the boys. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Small word. My big girl Miranda(30 years old) also was her birthday[<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.<br />Leonardo Da Vinci<br /></font id="size1"><br /><font size="1"> Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte<br /></font id="size1"><br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br /><br /><br />
  42. FrankKalis Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />
  43. satya Moderator

    Oh yes same here too...[:I]<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 /><br />Thanks guys! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Satya, sure she is and don't try to tell me it's any different with you. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  44. mmarovic Active Member

    Congratulations to Nina & Miranda [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  45. FrankKalis Moderator

    Thank you, Mirko! [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />

Share This Page