SQL Server Performance

Top Forum Posters for May 2006

Discussion in 'Forum Statistics' started by bradmcgehee, Jun 13, 2006.

  1. bradmcgehee New Member

    satya374
    FrankKalis214
    LuisMartin197
    Madhivanan155
    mmarovic134
    Adriaan119
    cmdr_skywalker114
    joechang104
    Twan70
    ramkumar.mu69
    khtan64
    smy58
    ranjitjain54
    spacemonkey53
    Toni52
    derrickleggett46
    nigelrivett45
    dineshasanka29
    erkdahl26
    photura26

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  2. dineshasanka Moderator

    congradulations to all. Good that we can see the post count.

    ----------------------------------------
    http://dineshasanka.blogspot.com/
  3. Luis Martin Moderator

    Congratulations.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  4. khtan New Member

    Congratulation to All.


    KH
  5. FrankKalis Moderator

    Congrats. It's always a pleasure to see new names on that list. [<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>
  6. Madhivanan Moderator

    Congratulations to all. Keep it up [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  7. satya Moderator

    Keep up the good work folks, much appreciated and can see how the forum is growing...

    Satya SKJ
    Microsoft SQL Server MVP
    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.
  8. ranjitjain New Member

    Congrats Satya.
    Congratulations to all of you.
  9. ramkumar.mu New Member

    Congrats to all... keep going.<br />better we can add a separate list (his posts on each and every topic) for satya. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
  10. FrankKalis Moderator

    Well, a more appropriate query should look something like


    SELECT TOP 20 username, COUNT(*)
    FROM users
    WHERE username != 'satya'
    GROUP BY username



    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
  11. ranjitjain New Member

    Frank You are still missing this in the select query<br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br />UPDATE table set userpost=Frank<br />where userpost='Satya'<br /><br />SELECT TOP 20 username, COUNT(*)<br /> FROM users<br /> WHERE username != 'satya'<br /> GROUP BY username<br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<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 />Well, a more appropriate query should look something like<br /><pre id="code"><font face="courier" size="2" id="code"><br />SELECT TOP 20 username, COUNT(*)<br /> FROM users<br /> WHERE username != 'satya'<br /> GROUP BY username<br /></font id="code"></pre id="code"><br /><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 /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  12. FrankKalis Moderator

    <pre id="code"><font face="courier" size="2" id="code"><br />UPDATE table set userpost=<b>'</b>FrankKalis<b>'</b><br />where userpost='Satya'<br /></font id="code"></pre id="code"><br />[<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>
  13. Madhivanan 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 /><pre id="code"><font face="courier" size="2" id="code"><br />UPDATE table set userpost=<b>'</b>FrankKalis<b>'</b><br />where userpost='Satya'<br /></font id="code"></pre id="code"><br />[<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 /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />What happens if Satya stops posting and you post a lot? [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  14. FrankKalis Moderator

    How high do you expect the likelihood of that event to be? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><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>
  15. Madhivanan 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 />How high do you expect the likelihood of that event to be? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><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 /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Not until he goes for vacation [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  16. satya Moderator

    Beep ... "<b><font color="red">Updating system table data is prohibited...your access is revoked</font id="red"></b>".[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />As Madhi referred about vacation fyi, I will be in Mumbai (India) from 28th June to 2nd July for a conference.[<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"><i>Originally posted by ranjitjain</i><br /><br />Frank You are still missing this in the select query<br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br />UPDATE table set userpost=Frank<br />where userpost='Satya'<br /><br />SELECT TOP 20 username, COUNT(*)<br /> FROM users<br /> WHERE username != 'satya'<br /> GROUP BY username<br />[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<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 />Well, a more appropriate query should look something like<br /><pre id="code"><font face="courier" size="2" id="code"><br />SELECT TOP 20 username, COUNT(*)<br /> FROM users<br /> WHERE username != 'satya'<br /> GROUP BY username<br /></font id="code"></pre id="code"><br /><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 /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  17. Madhivanan Moderator

    >>I will be in Mumbai (India) from 28th June to 2nd July for a conference

    Well. Is there a chance to visit Chennai?

    Madhivanan

    Failing to plan is Planning to fail
  18. dineshasanka Moderator

    Then we will see a new leader

    ----------------------------------------
    http://dineshasanka.blogspot.com/
  19. ghemant Moderator

    Congratulations to all.

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  20. ramkumar.mu New Member

    <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 />Beep ... "<b><font color="red">Updating system table data is prohibited...your access is revoked</font id="red"></b>".[<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />As Madhi referred about vacation fyi, I will be in Mumbai (India) from 28th June to 2nd July for a conference.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />] <br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />is it from 28th june 2006 to 2nd july 2007? then we have a slim chance to beat you[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."
  21. Madhivanan Moderator

    &gt;&gt;is it from 28th june 2006 to 2nd july 2007? then we have a slim chance to beat you<br /><br />Not at all if it is from 28th june 2006 to 2nd july 2006 [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
  22. ramkumar.mu New Member

    Not at all even if it was 28th june 2006 to 2nd july 2007.<br /><br />A simple calculation, Apart from Satya, the second person in the list posts 250 posts per month (approx). so he posts, 3000 posts in a year. <br /><br />Even Luis and Frank cant do this. as they might reach 7500 at that time. it should take more tha 2 years to overtake satya (if he is on vacation for that long) which i think is mission impossible: 4 [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."

Share This Page