Are the posted questions getting worse?

  • Derek Dongray (3/4/2009)


    Intersting.

    It seems Mangal Pardeshi is an MVP in SQL Server

    http://www.microsoft.com/india/mvp/indiamvp.aspx#MangalPardeshi

    Mangal is an E&TC Engineer from Pune University. He started his career as an ERP Technical Consultant in 2007. Currently he works as a BI Developer + SQL Server DBA in Business Insights Consulting, Pune. His core areas of expertise are Data Warehousing and Business Intelligence. He also possesses expertise in Database Administration, SSIS, SSAS, SSRS and T-SQL. He is an active participant and moderator in MSDN SQL Server forum. He is also one of the top answerer in MSDN SQL Server Forums

    Presumably in the MSDN forums people just give answers without trying to find out why.

    Interesting...something similar happened two or three years ago - different person, similar mo, same MVP claim. A little googling revealed a person with the same name and career details on the same address as above (less the name of course). At the time I was astonished that someone so obviously far behind the regulars here could have been selected for MVP.

    โ€œWrite the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.โ€ - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • Grant Fritchey (3/4/2009)


    Holy smokes, a moderator and an MVP and he's that much of a jerk? I thought you had to be... you know... helpful... to make MVP?

    In theory.

    It's interesting, cause there's a clause in the agreement (and I don't think it's a problem making that known), that MVPs act, at all times, in a professional and courteous manner, especially with other MVPs. Not saying I've done so all the time (the thread under question's more than borderline), but...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Lynn Pettis (3/4/2009)


    Bob Hovious (3/4/2009)


    He started his career as an ERP Technical Consultant in 2007.

    Call me old-school, but I cannot understand someone STARTING their career as a consultant.

    QUESTION!! How does someone who started their career in 2007 become an MVP???

    That is a damned good question. I guess because he's a top poster on MSDN.

    Helps to be a moderator too. You can go back & clean up stuff that was wrong or upset people...

    There was a recent tweet from Aaron Bertrand, an MVP I respect, unlike the character under discussion, that said "Pretty happy with #mvp09, but like any large group, there are always some real douchebags mixed in." I think that seems to accurately reflect the status of this MVP, speaking only for myself.

    But still, in just over a year? Criminy.

    "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

  • They must be giving out MVPs with breakfast cereal these days!:D

    I've looked at some of his recent responses on MSDN and a lot of them seem to be of the form.

    Try this...code...

    In other words, someone says "How do I do...X...?" and he doesn't ask why they want to do it; he just gives them the script.

    Several others are just one-liners ... "Use ;WITH", "See this link", etc.

    I thought an MVP needed to do more than simply post a lot on MSDN?

    On 2nd thoughts, I suppose, from Microsoft's point of view, if he's top poster on an MSDN SQL Server forum then, almost by definition, he ought to be an MVP. He's obviously a very helpful person! Nobody requires that his posts be detailed (or even right?).

    Derek

  • Grant Fritchey (3/4/2009)


    GilaMonster (3/4/2009)


    Grant Fritchey (3/4/2009)


    Well that one just yacked me off but good. He may as well be quoting from my posts because I'm "guilty" of all the "crimes" he listed. But hey, don't take it personally, I just think you stink. Shove it...

    And this from someone who's a moderator over at MSDN.... http://social.msdn.microsoft.com/en-US/profile/?user=Mangal%20Pardeshi

    I would have expected better behaviour

    Holy smokes, a moderator and an MVP and he's that much of a jerk? I thought you had to be... you know... helpful... to make MVP?

    The worst thing is, from his continued posts, he's just irritated as hell at all of us and doesn't acknowledge in any way that he was in the wrong. We just misinterpreted his perfectly innocent comment... Right. Pull this leg, it plays Jingle Bells.

    I have not met many MVP's face to face, but have interacted with many on-line and all have been more than helpful and I'm sure Mangal tries to be helpful. I have not been super-impressed with any responses I have seen from him here or the few I browsed over at MSDN, but he has a lot over there.

    How do you get to be a moderator on the MSDN forums and what does it really mean?

  • Steve closed his second thread, and now he is really offended and picking up his marbles and going home.

  • Derek Dongray (3/4/2009)


    They must be giving out MVPs with breakfast cereal these days!:D

    I've looked at some of his recent responses on MSDN and a lot of them seem to be of the form.

    Try this...code...

    In other words, someone says "How do I do...X...?" and he doesn't ask why they want to do it; he just gives them the script.

    Several others are just one-liners ... "Use ;WITH", "See this link", etc.

    I thought an MVP needed to do more than simply post a lot on MSDN?

    On 2nd thoughts, I suppose, from Microsoft's point of view, if he's top poster on an MSDN SQL Server forum then, almost by definition, he ought to be an MVP. He's obviously a very helpful person! Nobody requires that his posts be detailed (or even right?).

    I read through several of them as well. I didn't see anything wrong or bad that he posted. I didn't see much in the way of depth either. Just volume. And this from someone who complains about the volume of posts. Whatever. Losing interest at this point.

    "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

  • Derek Dongray (3/4/2009)


    They must be giving out MVPs with breakfast cereal these days!:D

    Hey! Be nice!

    ๐Ÿ˜‰

    I thought an MVP needed to do more than simply post a lot on MSDN?

    Who knows. Selection process is secret. He must have impressed someone enough to nominate him.

    I got mine almost solely because of posts here so MSDN posts coule be enough. Just guessing though.

    Nobody requires that his posts be detailed (or even right?).

    Correct and helpful are required. I know I got asked for several forum posts where my answers helped someone

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Derek Dongray (3/4/2009)


    They must be giving out MVPs with breakfast cereal these days!:D

    I've looked at some of his recent responses on MSDN and a lot of them seem to be of the form.

    Try this...code...

    In other words, someone says "How do I do...X...?" and he doesn't ask why they want to do it; he just gives them the script.

    Several others are just one-liners ... "Use ;WITH", "See this link", etc.

    I thought an MVP needed to do more than simply post a lot on MSDN?

    On 2nd thoughts, I suppose, from Microsoft's point of view, if he's top poster on an MSDN SQL Server forum then, almost by definition, he ought to be an MVP. He's obviously a very helpful person! Nobody requires that his posts be detailed (or even right?).

    Hey All, I am leaving SSC for a month. I am going over to MSDN and get my post count high and become a moderator and ultimately be a MVP. You are all going to envious of me... Hehehehe

    :hehe:

    -Roy

  • Have you also noted that he changed his name? Now it doesn't match the name in the quoted replies to his deleted posts. :w00t:

  • Lynn Pettis (3/4/2009)


    Have you also noted that he changed his name? Now it doesn't match the name in the quoted replies to his deleted posts. :w00t:

    That's easily fixable (although a pain in the neck to do)

    Although, the name in quotes does still match his signature.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (3/4/2009)


    Lynn Pettis (3/4/2009)


    Have you also noted that he changed his name? Now it doesn't match the name in the quoted replies to his deleted posts. :w00t:

    That's easily fixable (although a pain in the neck to do)

    And probably not even worth the effort. :w00t:

  • GilaMonster (3/4/2009)


    Nobody requires that his posts be detailed (or even right?).

    Correct and helpful are required. I know I got asked for several forum posts where my answers helped someone

    Actually, I didn't find any of his MSDN replies wrong, just that they didn't include any caveats about possible side effects or even much in the way of explanation. As I said simply "Try this..." answers.

    The items I did find suspect were from reading his blog, in particular a list of SQL query performance tips with no explanation as to why any of them should be used.

    The one that particularly caught my eye was "When sorting a specific column often consider making that column a clustered index."!

    So I've got this database tuned to do frequent large bulk imports, but I've got this regular query which is running slow, so I'll just change which column is a clustered index...! :w00t:

    Edit: Added URL.

    Derek

  • Derek Dongray (3/4/2009)


    The items I did find suspect were from reading his blog, in particular a list of SQL query performance tips with no explanation as to why any of them should be used.

    Couple of those are dead wrong.

    In the WHERE-clause use the least likely true AND expression first.

    Order of expressions in the where doesn't matter. Optimiser will reorder then to make best use of an index.

    Avoid using UNION of two subsets from the same table. Instead use OR in the WHERE clause.

    In 2000 the optimiser had more options for evaluating a UNION than it did for an OR, so sometimes changing an OR to a UNION helped. In 2005 and higher, the optimiser has exactly the same options available for both and both options will usually perform the same.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Some other priceless pearls from the "Mangled" SQL Blog....

    5. Avoid using SELECT * FROM when only a few columns are needed. Try to specify each column.

    How about avoiding using SELECT * FROM in production code altogether?

    8. Try to use the best performing operator as possible.

    Okay, I'll try my best.

    15. Don't use ORDER BY if you don't really need it.

    There's no need to use ANYTHING if you don't really need it.

    21. In case using GROUP BY without an aggregate function try using DISTINCT instead

    To my knowledge, I have never used a GROUP BY without an aggregate function.

    What you have to love about all these rules are the total absence of examples, or explanations about "why". It's possible that he really doesn't have the depth of understanding to look at "truisms' with a critical eye. That's one thing I love about this site, when I get my head handed to me, I at least understand why.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 2,191 through 2,205 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply