Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 12,046 through 12,060 (of 66,712 total)

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

Gianluca Sartori (2/24/2010)
RBarryYoung (2/23/2010)
Here's the line (*):
Itzik Ben-Gan, "Calculating Concurrent Sessions, Part 3" (SQL Server Magazine, March 2010)
... In a benchmark test that I ran, it proved to be an order of magnitude faster compared with New Set-Based Solution 1. I’d like to thank Ben Flanaghan, Arnold Fribble, and R. Barry Young for coming up with the new solution. ...
(*: Steve, I am pretty sure that this falls under "Fair Use" guidelines. Feel free to edit it out, if not.)
Thanks Barry, and congrats again!
Am I living in a different universe if I confess I don't know Ben Flanaghan nor Arnold Fribble? If you collaborated with them to draw the solution, they must be darn good.

Nope, we all came up with the same answer, independently.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

WayneS SSC Guru Points: 95460 More actions · Answer 2

RBarryYoung (2/23/2010)
Thats's what the Fair Use doctrine is all about, Wayne. Paid or not, copyright or not, we are still allowed to quote text from sources, within limits. The U.S. long ago decided that this was a necessary right in order to protect Free Speech in a democratic society.

So, the legal system actually did something right??? I wasn't aware it extended as far as it did. Thanks for the info, and the wiki article.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

GSquared (2/23/2010)
Elliott W (2/23/2010)
GilaMonster (2/23/2010)
Are we geeks or not?
Yes, nerds NO!
I have a shirt that proclaims "GEEK" accross the front, just so there is no question..
CEWII
By derivation, a "geek" is someone who bites the heads off of live chickens in a circus sideshow, while a "nerd" is a socially awkward person with a scholarly personality.

Yep, that works then... geek.

"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

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

RBarryYoung (2/23/2010)
Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if a CLR solution come overcome the "call per row" penalty.
As for the old Hammer saw (:-P), I actually would defend SQL as an appropriate and even preferred solution for this problem (barring really significant performance differences).

Hey Barry,

Can you guess what this:

...is a (one million row) execution plan for? 😛

Paul

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

WayneS SSC Guru Points: 95460 More actions · Answer 5

Paul White (2/24/2010)
RBarryYoung (2/23/2010)
Give it a go, Paul. The solution that we (independently) came up with is pretty darn efficient, so I would be particularly interested to see if a CLR solution come overcome the "call per row" penalty.
As for the old Hammer saw (:-P), I actually would defend SQL as an appropriate and even preferred solution for this problem (barring really significant performance differences).
Hey Barry,
Can you guess what this:
...is a (one million row) execution plan for? 😛
Paul

Something that you're about to write an article on?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

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

WayneS (2/24/2010)
Something that you're about to write an article on?

Oh highly amusing, Wayne! :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 7

no, it's a sheep.

---------------------------------------------------------
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."

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

jcrawf02 (2/24/2010)
no, it's a sheep.

Do we dare ask what he's referring to, or who he's talking to? 😀

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]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Alvin Ramard (2/24/2010)
jcrawf02 (2/24/2010)
no, it's a sheep.
Do we dare ask what he's referring to, or who he's talking to? 😀

No

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

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 10

Steve Jones - SSC Editor

SSC Guru

Points: 736280

February 24, 2010 at 9:46 am

#1124355

I agree with Jason. Be careful what you ask for here.

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

Steve Jones - Editor (2/24/2010)
I agree with Jason. Be careful what you ask for here.

I used to work with a redneck from [state name withheld to protect the innocents] who had a small farm. I'm well aware of the risks!!! :w00t:

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]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 12

Alvin Ramard (2/24/2010)
Steve Jones - Editor (2/24/2010)
I agree with Jason. Be careful what you ask for here.
I used to work with a redneck from [state name withheld to protect the innocents] who had a small farm. I'm well aware of the risks!!! :w00t:

All I can say is, love the one you're with.:hehe:

And phooey, as if I'm the only one who ever said anything in The Thread that someone thought was off-topic. Within the last ten minutes.

---------------------------------------------------------
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."

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

jcrawf02 (2/24/2010)
Alvin Ramard (2/24/2010)
Steve Jones - Editor (2/24/2010)
I agree with Jason. Be careful what you ask for here.
I used to work with a redneck from [state name withheld to protect the innocents] who had a small farm. I'm well aware of the risks!!! :w00t:
All I can say is, love the one you're with.:hehe:
And phooey, as if I'm the only one who ever said anything in The Thread that someone thought was off-topic. Within the last ten minutes.

Just be careful about loving the one ewe're with. 😀

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]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 14

Alvin Ramard (2/24/2010)
Just be careful about loving the one ewe're with. 😀

wow, I concede....whatever it is we're competing for.

---------------------------------------------------------
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."

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

jcrawf02 (2/24/2010)
Alvin Ramard (2/24/2010)
Just be careful about loving the one ewe're with. 😀
wow, I concede....whatever it is we're competing for.

No, I think you win.

By the way was that Dolly?

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