Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 12,106 through 12,120 (of 66,712 total)

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

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 1

Paul White (2/26/2010)
CirquedeSQLeil (2/26/2010)
Sad when they just won't relent - just keep pushing it. Not good.
I posted it there, and I'm posting it here:
http://meta.wikimedia.org/wiki/Don't_be_a_dick
Mr Corgi needs less of whatever he's been doing too much of today. Caffeine?

I'm begining to think his name is "Richard" and that he really shouldn't use Corgi poo for incense.

--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: 1004372 More actions · Answer 2

Paul White (2/26/2010)
Jeff,
Did you really just post:
The actions to take to counter intrusions should always be taken before the attempt at penetration and I'm careful to take those actions.
...? Have you ever been to prison? :laugh:
Paul

Nope... :hehe: Heh... you did pick up on the intonation, though.

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

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

lmu92 (2/26/2010)
Kit G (2/26/2010)
Hey! You got it! Glad I could help out with your understanding of Cloud Computing. One other thing I should mention, the temperature of the servers hosting the Cloud Computing is important. Get that temperature low enough, and you go from Clouds to Snow.
Unless you and your clients are prepared for the sudden change, it can cause a bit of upset with your client base, but generally makes the kids happy.
Does SnowFlakeComputing also imply, I wouldn't need a frozen mug to get a cold BIT (German beer brand name)?
Regarding the risk of sudden temperature change: I would actually tell the clients that cloud computing will reduce global energy consumption as well since the data center must not be chilled anymore to avoid the risk of SnowFlakeComputing transformation 😛

Snowflake computing - BI in the cloud.

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

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

Jeff Moden (2/26/2010)
I guess I'd get into trouble if I recommended that someone started Lithium treatment, huh?
http://www.sqlservercentral.com/Forums/Topic873721-145-1.aspx

Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several previous ones too.

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 5

GilaMonster (2/27/2010)
Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several previous ones too.

I had noticed that too, but thought 'Welsh Corgi' had improved in that regard recently. It seems my optimism was premature.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Paul White (2/27/2010)
GilaMonster (2/27/2010)
Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several previous ones too.
I had noticed that too, but thought 'Welsh Corgi' had improved in that regard recently. It seems my optimism was premature.

Isn't that just fantastic - removed all comments. Makes it hard to follow the entire thread.

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

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

CirquedeSQLeil (2/27/2010)
Paul White (2/27/2010)
GilaMonster (2/27/2010)
Someone is a little over-sensitive to corrections and disagreements. Not just that thread, several previous ones too.
I had noticed that too, but thought 'Welsh Corgi' had improved in that regard recently. It seems my optimism was premature.
Isn't that just fantastic - removed all comments. Makes it hard to follow the entire thread.

He's done that before in other threads. I noticed yesterday when looking over posting history. Irritating as hell.

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 8

:w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t:

------------------------------

Sequence Table article finished!

------------------------------

:w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t: :smooooth: :w00t:

I've sent a copy by mail to those that expressed an interest before.

I wouldn't mind one or two more, though. I'm primarily looking for feedback on style and readability now - not technical stuff, as I think that's pretty well covered. PM me your email address if you would like a copy.

Paul

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

D.Oc SSCrazy Points: 2875 More actions · Answer 9

Paul White (2/25/2010)
I've just received permission from Itzik to share my implementation with you, so I can finally post the test rig from his Calculating Concurrent Sessions article and my CLR UDA solution. This is 2008-only code and not production-quality.
In particular, the production version will not throw an exception if a row arrives out of sequence: it will optimize for rows received in sequence, but degrade gracefully (using a caching mechanism) if this optimization doesn't hold.
I apologise for the technical content 🙂
Paul

Just tested your code and got this as a result:

T-SQL Average Execution Time (ms) = 3584

CLR Average Execution Time (ms) = 3933

T-SQL faster by -09%

Nice

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."

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

D.Oc (2/28/2010)
Just tested your code and got this as a result:
T-SQL Average Execution Time (ms) = 3584
CLR Average Execution Time (ms) = 3933
T-SQL faster by -09%

Thank you very much for the feedback!

I sometimes found that the CLR solution ran faster on subsequent runs (without dropping and recreating).

Nevertheless, that's a good result.

Paul

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (2/27/2010)
I wouldn't mind one or two more, though. I'm primarily looking for feedback on style and readability now - not technical stuff, as I think that's pretty well covered. PM me your email address if you would like a copy.

Ok so that serves me right - there are now ten of you with advance copies! Huge thanks to everyone, especially for the brilliant feedback received so far. I'm going to stop sending out review copies now, just to draw a line somewhere. Thanks again!

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 12

So how's everyone today?

I'm not sure where my get-up-and-go is today. For some reason I feel emotionaly drained today.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Alvin Ramard (3/1/2010)
So how's everyone today?
I'm not sure where my get-up-and-go is today. For some reason I feel emotionaly drained today.

What time do the pubs open where you are?

Nah, really, sorry to hear that, Alvin. Would you like to tell us about your childhood?

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

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 14

Alvin Ramard (3/1/2010)
So how's everyone today?
I'm not sure where my get-up-and-go is today. For some reason I feel emotionaly drained today.

Alvin is having Withdrawal symptoms of Winter Olympics if I am not mistaken... 😀

-Roy

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 15

Roy Ernest (3/1/2010)
Alvin Ramard (3/1/2010)
So how's everyone today?
I'm not sure where my get-up-and-go is today. For some reason I feel emotionaly drained today.
Alvin is having Withdrawal symptoms of Winter Olympics if I am not mistaken... 😀

I do believe you're correct. Yesterday was an exciting day.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]