SQL Server Performance

Top Forum Posters for May 2006

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

Page 1 of 2

  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
    bradmcgehee, Jun 13, 2006
    #2

  2. dineshasanka Moderator

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

    ----------------------------------------
    http://dineshasanka.blogspot.com/
    dineshasanka, Jun 13, 2006
    #2

  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.



    Luis Martin, Jun 13, 2006
    #2

  4. khtan New Member

    Congratulation to All.


    KH
    khtan, Jun 13, 2006
    #2

  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>
    FrankKalis, Jun 13, 2006
    #2

  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
    Madhivanan, Jun 14, 2006
    #2

  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.
    satya, Jun 14, 2006
    #2

  8. ranjitjain New Member

    Congrats Satya.
    Congratulations to all of you.
    ranjitjain, Jun 14, 2006
    #2

  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..."
    ramkumar.mu, Jun 14, 2006
    #2

  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
    FrankKalis, Jun 14, 2006
    #2

  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">
    ranjitjain, Jun 14, 2006
    #2

  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>
    FrankKalis, Jun 14, 2006
    #2

  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
    Madhivanan, Jun 14, 2006
    #2

  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>
    FrankKalis, Jun 14, 2006
    #2

  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
    Madhivanan, Jun 14, 2006
    #2

  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">
    satya, Jun 14, 2006
    #2

  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
    Madhivanan, Jun 15, 2006
    #2

  18. dineshasanka Moderator

    Then we will see a new leader

    ----------------------------------------
    http://dineshasanka.blogspot.com/
    dineshasanka, Jun 15, 2006
    #2

  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
    ghemant, Jun 17, 2006
    #2

  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..."
    ramkumar.mu, Jun 29, 2006
    #2

  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
    Madhivanan, Jun 29, 2006
    #2

  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..."
    ramkumar.mu, Jun 30, 2006
    #2
Page 1 of 2

Share This Page