March 4, 2009 at 1:19 pm
Seriously is there any place we can complain about this guy and his "advice quality"? I really don't like being represented by that guy as an mvp.
March 4, 2009 at 1:29 pm
Gail, Jeff & Steve are the three MVP's I know that haunt this thread. After I posted to the blog I had a different MVP send me a direct message via twitter regarding it. I sent him the guy's web site.
I don't know if they have a method of reporting on this guy or not.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 4, 2009 at 1:33 pm
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.
I just noticed something very concerning.
http://mangalpardeshi.blogspot.com/2008/10/some-query-optimization-tips_02.html - published October 2008
http://www.dotnet4all.com/snippets/2008/04/23-tips-to-improve-performance-of-your.html - published April 2008. Page isn't currently available, but the google cache is - http://209.85.229.132/search?q=cache:gyTOrFDjB1wJ:www.dotnet4all.com/snippets/2008/04/23-tips-to-improve-performance-of-your.html+%22most+frequently+found+values+are+placed+first.&hl=en&ct=clnk&cd=6&gl=za
http://www.scribd.com/doc/3567394/SQL-Server-Reference - uploaded 8 months ago.
Edit: How I found this lot - http://www.google.co.za/search?q=%22most+frequently+found+values+are+placed+first.&hl=en&lr=&filter=0
I think I need to have a chat with some people next week.
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
March 4, 2009 at 1:36 pm
Grant Fritchey (3/4/2009)
I don't know if they have a method of reporting on this guy or not.
Yup, and after what I just found, I'm going to. Just need to gather some more evidence first.
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
March 4, 2009 at 1:37 pm
GilaMonster (3/4/2009)
Grant Fritchey (3/4/2009)
I've been running a loop of "I love living in the city" by the Fear in my head for days now, so, I'd almost welcome the Star Wars theme, even the 70's disco version.Have you ever heard the version of the Imperial March done by Metallica? If not, see if you can locate it. It's a very nice take on the theme, and I had a portion of it as a cell phone ring for a while.
Here's a youtube link for it: http://www.youtube.com/watch?v=_iKhzqLsfAM
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 4, 2009 at 1:38 pm
Right. Now there really is something to report. He lifted that list. Go here and read through this:
http://www.sql-server-performance.com/tips/t_sql_where_p1.aspx
I found the tip that upset me on page 5. I'm not sure it's right, but at least there's a full explanation.
I think our buddy plagiarized that post, badly.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 4, 2009 at 1:41 pm
So in this case MVP may equal Most Verbiage Plagiarized?
March 4, 2009 at 1:43 pm
GilaMonster (3/4/2009)
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.I just noticed something very concerning.
http://mangalpardeshi.blogspot.com/2008/10/some-query-optimization-tips_02.html - published October 2008
http://www.dotnet4all.com/snippets/2008/04/23-tips-to-improve-performance-of-your.html - published April 2008. Page isn't currently available, but the google cache is - http://209.85.229.132/search?q=cache:gyTOrFDjB1wJ:www.dotnet4all.com/snippets/2008/04/23-tips-to-improve-performance-of-your.html+%22most+frequently+found+values+are+placed+first.&hl=en&ct=clnk&cd=6&gl=za
http://www.scribd.com/doc/3567394/SQL-Server-Reference - uploaded 8 months ago.
Edit: How I found this lot - http://www.google.co.za/search?q=%22most+frequently+found+values+are+placed+first.&hl=en&lr=&filter=0
I think I need to have a chat with some people next week.
It looks like it was all pulled from Brad Magehee. I reported it to him via Twitter. No response yet.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 4, 2009 at 1:44 pm
Jack Corbett (3/4/2009)
GilaMonster (3/4/2009)
Grant Fritchey (3/4/2009)
I've been running a loop of "I love living in the city" by the Fear in my head for days now, so, I'd almost welcome the Star Wars theme, even the 70's disco version.Have you ever heard the version of the Imperial March done by Metallica? If not, see if you can locate it. It's a very nice take on the theme, and I had a portion of it as a cell phone ring for a while.
Here's a youtube link for it: http://www.youtube.com/watch?v=_iKhzqLsfAM
No youtube at work. Gets the big red hand... then I have to go clean my IP address out of the database again so I don't end up on reports.... kidding
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
March 4, 2009 at 1:48 pm
Grant Fritchey (3/4/2009)
It looks like it was all pulled from Brad Magehee. I reported it to him via Twitter. No response yet.
I doubt Brad wrote all of those. He knows better. SQL_Performance allows user submissions (or at least used to)
But at 2003, this looks like the earliest source.
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
March 4, 2009 at 2:21 pm
ARTIST: Tom Lehrer
TITLE: Lobachevsky
Lyrics
Who made me the genius I am today
The mathematician that others all quote
Who's the professor that made me that way
The greatest that ever got chalk on his coat
One man deserves the credit
One man deserves the blame
And Nicolai Ivanovich Lobachevsky is his name, hi!
Nicolai Ivanovich Lobache-
I am never forget the day I first meet the great Lobachevsky. In one word he told me secret of success in mathematics. Plagiarize!
Plagiarize
Let no one else's work evade your eyes
Remember why the good Lord made your eyes
So don't shade your eyes
But plagiarize, plagiarize, plagiarize
Only be sure always to call it please "research"
There's more if anyone wants to see it all.
http://www.guntheranderson.com/v/data/lobachev.htm
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2009 at 2:27 pm
Bob, I've had that song in my head ever since it was brought up that Mangle was allegedly doing so.
I also have to admit I've had a long-term goal of posting a cover of that song online and claiming it for my own... 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 4, 2009 at 2:40 pm
GSquared (3/4/2009)
Bob, I've had that song in my head ever since it was brought up that Mangle was allegedly doing so.I also have to admit I've had a long-term goal of posting a cover of that song online and claiming it for my own... 🙂
Nice. I'll distribute it under your name at the kickoff meeting for my A.C.R.O.N.Y.M. project (title under development)
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
March 4, 2009 at 2:53 pm
Great minds think alike. I'm just happy that I'm not the only person on earth who might remember that song. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 4, 2009 at 2:57 pm
GilaMonster (3/4/2009)
Grant Fritchey (3/4/2009)
It looks like it was all pulled from Brad Magehee. I reported it to him via Twitter. No response yet.I doubt Brad wrote all of those. He knows better. SQL_Performance allows user submissions (or at least used to)
But at 2003, this looks like the earliest source.
I spoke with Brad via twitter. Those are old & out of date. They haven't been maintained. Doesn't matter, our friend didn't even do a good job of copying & pasting. He reversed things that Brad had posted, such as the order in the WHERE clause does not matter was transcribed as DOES matter.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 15 posts - 2,236 through 2,250 (of 66,000 total)
You must be logged in to reply to this topic. Login to reply