Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 12,721 through 12,735 (of 66,712 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

george sibbald (3/15/2010)
Jeez Alvin, that new avatar is even more annoying! 😀

OUCH

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

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 2

Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn only needs 4 more posts for 10,000 posts (not overall pts).
CountDown on?
Got the tent ready for the party? D'you sweep out all the hippo droppings?
Nah, the hippo is potty trained.
Did you do the hippo potty training?
hippo potty's a must 😀

Is that like DBCC TimeWarp'd hampster poo?

--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)

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 3

Greg Edwards-268690 (3/15/2010)
bitbucket-25253 (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
Lynn Pettis (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd rather not say, then don't.
47, three more years before I'm legally dead.
I take exception to this remark, I'm not dead yet!! 😉
Are you sure?
Actually, yes. I am still quite able to eat my favorite spicy foods without getting heartburn or indigestion. A sure sign, in my opinion, that I'm still alive! :w00t: (But that doesn't mean I don't feel older than I really am at times. 😛 )
All you young whipper snappers .... hope you last as long if not longer than myself ... (born April 18, 1932) .. no major aches, no major pains, one major surgery -- open heart, still able to rise and shine each morning. So you all plan to keep on plugging away
congratulations - keep on plugging away
1932 - I can't even get back that far using all my fingers and toes!
Although it's close....
Greg E

Heh... man, rocks don't live that long! 😛

--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)

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 4

Alvin Ramard (3/15/2010)
You know ..... If the right "outsider" read the Thread, some of us might end up with free room and board for the rest of our lives, wall padding included. 😀 hmmm :w00t:

What? You don't have wall padding, yet? It's so comforting...

--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)

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd rather not say, then don't.
47, three more years before I'm legally dead.

Glad to know I'm younger, oh, and better looking 😀 Happy Birthday.

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

Paul White SSC Guru Points: 150467 More actions · Answer 6

Alvin Ramard (3/15/2010)
Anybody else see a problem with this statement?
DECLARE @selectDate DATETIME = getdate()-365

Offensive. Not just because it does not work with any of the new date/time types in 2008 either.

In fact it is as bad as DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP), 0).

And let us not forget the epic SELECT CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, CURRENT_TIMESTAMP))).

Current favourite date-related expression: SELECT {fn CURRENT_DATE()}, which is an obscure way to write CONVERT(varchar(10),getdate(),23)). It is my favourite not because it is good (it is not), but because it is obscure and style 23 is undocumented :w00t:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Paul White SSC Guru Points: 150467 More actions · Answer 7

GilaMonster (3/15/2010)
I hate to ruin the good mood, but could anyone keen on bashing their head against a wall for a coupl hours follow up on this. Is midnight (almost) here. From our usual friend...[/url]

I am busy elsewhere, trying to convince him that min and max memory settings do work on 64-bit SQL Server. :doze:

My second run-in with him this week. First time I got a correction and an apology, think it was a one-off.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Paul White SSC Guru Points: 150467 More actions · Answer 8

george sibbald (3/15/2010)
I'll keep banging my head overnight till I feel better. Tomorrow it goes.

Aw. I think it's awesome!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (3/15/2010)
GilaMonster (3/15/2010)
I hate to ruin the good mood, but could anyone keen on bashing their head against a wall for a coupl hours follow up on this. Is midnight (almost) here. From our usual friend...[/url]
I am busy elsewhere, trying to convince him that min and max memory settings do work on 64-bit SQL Server. :doze:

Why on earth does he think they don't?

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

Paul White SSC Guru Points: 150467 More actions · Answer 10

GilaMonster (3/16/2010)
Paul White (3/15/2010)
GilaMonster (3/15/2010)
I hate to ruin the good mood, but could anyone keen on bashing their head against a wall for a coupl hours follow up on this. Is midnight (almost) here. From our usual friend...[/url]
I am busy elsewhere, trying to convince him that min and max memory settings do work on 64-bit SQL Server. :doze:
Why on earth does he think they don't?

Amazing isn't it? Another golden nugget of wisdom...

When I asked him why he thought that, he responded with something about AWE only being available on 32-bit. *sigh*

I think he has been confused by something he read without truly understanding it.

I am quite happy to educate him on the subject, it just frustrates me when people post authoritative-sounding statements that are just plain wrong...!

http://www.sqlservercentral.com/Forums/FindPost883101.aspx for anyone that feels like banging their head on the wall again.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (3/16/2010)
I am quite happy to educate him on the subject, it just frustrates me when people post authoritative-sounding statements that are just plain wrong...!

I feel another blog rant coming.

Other thing that frustrates me, along the same lines, is people insisting that a specific feature is deprecated when it's not.

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

Paul White SSC Guru Points: 150467 More actions · Answer 12

GilaMonster (3/16/2010)
I feel another blog rant coming.

See if you can include that http://en.wikipedia.org/wiki/Argument_from_authority link. Very cool.

Other thing that frustrates me, along the same lines, is people insisting that a specific feature is deprecated when it's not.

Heh. Like CONVERT, DBCC SQLPERF, and COALESCE? I think I have read threads claiming all those are deprecated recently...

The thing that bothers me most is getting distracted by dealing with the incorrect claims rather than getting on with answering the OP.

Ah well.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (3/16/2010)
GilaMonster (3/16/2010)
I feel another blog rant coming.
See if you can include that http://en.wikipedia.org/wiki/Argument_from_authority link. Very cool.

I think that's a different rant. The thread I think you're referring to just had me seeing red that day.

Other thing that frustrates me, along the same lines, is people insisting that a specific feature is deprecated when it's not.
Heh. Like CONVERT, DBCC SQLPERF, and COALESCE? I think I have read threads claiming all those are deprecated recently...

I've seen someone say that all DBCC statements are deprecated. I've seen ISNULL, Select into and a few others.

No idea why. It's not as if it's hard to tell, from BoL alone, if a specific feature is deprecated in a specific version.

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: 398890 More actions · Answer 14

CirquedeSQLeil (3/15/2010)
george sibbald (3/15/2010)
sorry Alvin, have to agree with Gail, jarjar has to be the most annoying character ever created in any film. Made my flesh crawl.
Always amazed me how it got past the censors.
I am one of the few that actually likes JarJar.

Yes, and you should immediately apologize and then seek counseling.

"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: 398890 More actions · Answer 15

Jack Corbett (3/15/2010)
Grant Fritchey (3/15/2010)
GSquared (3/15/2010)
Grant Fritchey (3/15/2010)
Oh cool, tossed under another bus. Thanks Alvin.
What year? (My birthday was yesterday, so I'm curious as to what the actual age difference is.) If you'd rather not say, then don't.
47, three more years before I'm legally dead.
Glad to know I'm younger, oh, and better looking 😀 Happy Birthday.

Younger anyway...

"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