Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 55,021 through 55,035 (of 66,608 total)

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

Thomas Rushton SSC-Insane Points: 22648 More actions · Answer 1

GilaMonster (7/21/2016)
ThomasRushton (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Celko?
The first wouldn't apply to Celko. Traceflags aren't ansi standard.
Some people, unfortunately, have an elevated opinion of themselves.

Yes, I thought of the traceflags / standard thing after I posted. Still, intrigued to know who it was.

Thomas Rushton
blog: https://thelonedba.wordpress.com

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 2

GilaMonster (7/21/2016)
ThomasRushton (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Celko?
The first wouldn't apply to Celko. Traceflags aren't ansi standard.
Some people, unfortunately, have an elevated opinion of themselves.

The only person I know who appears to actually know all undocumented trace flags (and most of them even by head) is Paul White. But he would never do any of the things shown in these three links.

But frankly, I don't think I know anyone that would fit the bill on these.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Eirikur Eiriksson SSC Guru Points: 182884 More actions · Answer 3

BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.

One of the certainties of live: "There will always be wannabes"

😎

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 4

Hugo Kornelis (7/21/2016)
GilaMonster (7/21/2016)
ThomasRushton (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Celko?
The first wouldn't apply to Celko. Traceflags aren't ansi standard.
Some people, unfortunately, have an elevated opinion of themselves.
The only person I know who appears to actually know all undocumented trace flags (and most of them even by head) is Paul White. But he would never do any of the things shown in these three links.
But frankly, I don't think I know anyone that would fit the bill on these.

Somewhere on ssc (I think, but possibly PFS) Paul was asked how he figured out so many trace flags and he declined to answer the question fully, so that one may fit. Given the level of effort involved and the personal gain derived from it, I don't find this stance unreasonable.

Edit: in the comments section at the bottom of this article.

^{“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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Hugo Kornelis (7/21/2016)
But frankly, I don't think I know anyone that would fit the bill on these.

I've done the second a few times, out of forgetfulness only not malicious intent.

I think part of Paul's traceflag discovery method is a while loop with DBCC TRACEON, and a debugger. Not the kind of thing most people could replicate (or would want to)

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

Grant Fritchey SSC Guru Points: 398716 More actions · Answer 6

BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.

Innocent of that crime... yikes.

"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

Grant Fritchey SSC Guru Points: 398716 More actions · Answer 7

GilaMonster (7/21/2016)
Hugo Kornelis (7/21/2016)
But frankly, I don't think I know anyone that would fit the bill on these.
I've done the second a few times, out of forgetfulness only not malicious intent.

Same here. I'm pretty sure I haven't posted all my demos online in every instance. These are coming off a little harsh.

"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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 8

Beatrix Kiddo

SSC-Dedicated

Points: 32407

July 21, 2016 at 4:25 am

#1891265

They're very pointed/passive-aggressive.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Hugo Kornelis (7/21/2016)
GilaMonster (7/21/2016)
ThomasRushton (7/21/2016)
BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.
Celko?
The first wouldn't apply to Celko. Traceflags aren't ansi standard.
Some people, unfortunately, have an elevated opinion of themselves.
The only person I know who appears to actually know all undocumented trace flags (and most of them even by head) is Paul White. But he would never do any of the things shown in these three links.
But frankly, I don't think I know anyone that would fit the bill on these.

I know a few people to make the claim. Paul W knows them pretty well and I know some of what he did to discover them. I know he would rather people go off on that trek themselves to find it out though because of the potential problems that could arise by playing with all of them.

I don't know anybody that fits the bill of the last two links.

Well, maybe the last one but always clearly as a joke.

Seems like whoever submitted these three has an ax to grind.

I don't think the three relate to one specific individual - rather a few different incidents or people.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

GilaMonster (7/21/2016)
Hugo Kornelis (7/21/2016)
But frankly, I don't think I know anyone that would fit the bill on these.
I've done the second a few times, out of forgetfulness only not malicious intent.
I think part of Paul's traceflag discovery method is a while loop with DBCC TRACEON, and a debugger. Not the kind of thing most people could replicate (or would want to)

There is a lot of debugger involved in it. Spot on with the loop. That is the brute force part of what he does. There are pieces of it that he hasn't shared and rightfully so imho.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

jasona.work SSC Guru Points: 50085 More actions · Answer 11

SQLRNNR (7/21/2016)
GilaMonster (7/21/2016)
Hugo Kornelis (7/21/2016)
But frankly, I don't think I know anyone that would fit the bill on these.
I've done the second a few times, out of forgetfulness only not malicious intent.
I think part of Paul's traceflag discovery method is a while loop with DBCC TRACEON, and a debugger. Not the kind of thing most people could replicate (or would want to)
There is a lot of debugger involved in it. Spot on with the loop. That is the brute force part of what he does. There are pieces of it that he hasn't shared and rightfully so imho.

IIRC, if this is Paul Randal, he used to work for MS. So potentially, he might also be using some "inside" tricks to dig out the flags, which if he shared it would get him in a heap-o-trouble (NDAs and such.)

jasona.work SSC Guru Points: 50085 More actions · Answer 12

Just took a look at the weather radar for Michigan...

My new generator may get a work out tonight.

Big line of storms sweeping in from the northwest coming this way...

djj SSCoach Points: 18831 More actions · Answer 13

jasona.work (7/21/2016)
SQLRNNR (7/21/2016)
GilaMonster (7/21/2016)
Hugo Kornelis (7/21/2016)
But frankly, I don't think I know anyone that would fit the bill on these.
I've done the second a few times, out of forgetfulness only not malicious intent.
I think part of Paul's traceflag discovery method is a while loop with DBCC TRACEON, and a debugger. Not the kind of thing most people could replicate (or would want to)
There is a lot of debugger involved in it. Spot on with the loop. That is the brute force part of what he does. There are pieces of it that he hasn't shared and rightfully so imho.
IIRC, if this is Paul Randal, he used to work for MS. So potentially, he might also be using some "inside" tricks to dig out the flags, which if he shared it would get him in a heap-o-trouble (NDAs and such.)

In Paul's newsletter, he says he has not been on forums recently. Not to mention he is traveling in Europe.:-)

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

jasona.work (7/21/2016)
IIRC, if this is Paul Randal, he used to work for MS.

No. Paul White.

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

Jeff Moden SSC Guru Points: 1003916 More actions · Answer 15

BrainDonor (7/21/2016)
Does anybody know who the "Hotshot SQL Guru" is?
https://tmblr.co/Z14uHt29WaOS7
https://tmblr.co/Z14uHt29Ww0kS
https://tmblr.co/Z14uHt29ZP3zF
Somebody wasn't impressed.

Probably a group effort by the folks at Brent Ozar Unlimited, since it's posted that the tmblrs are "curated by Brent Ozar Unlimited".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)