Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,641 through 20,655 (of 66,712 total)

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

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

...and, because I'm a complete and utter dork, it's almost 5, and I think it's funny, I'll repeat a poll I did at work today, assuming you guys will get it much faster.

If I said something was "For the greater good", would you get the literary reference, and what do you think it was from?

Wrong answers I got were hilarious:

•Nine inch nails

•Utilitarianism

•A Greater Good (History 1998–2008), an album by Neuroticfish

•The Greater Good, the unifying philosophy of the Tau in the table-top wargame Warhammer 40,000

•STEVE Murray (supposed to be Bill Murray)

•Animal Farm

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

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 2

Stefan Krzywicki (10/19/2010)
Greg Edwards-268690 (10/19/2010)
Alvin Ramard (10/19/2010)
Stefan Krzywicki (10/19/2010)
Alvin Ramard (10/19/2010)
Steve, do we have an award for this one?
http://www.sqlservercentral.com/Forums/Topic1007106-392-1.aspx
Should give him a Lincoln award for preserving the Union.
... and people say MY jokes are bad? 😛
Edit: Just can't get my fingers and brain to work at the same speed.
And for all the little Lincolns gathered as others throw their 2 cents worth in?
Seems to have gotten scared off, hope they come back and see there are a few good tips to be found.
I got the impression that they may be someone who would be willing to learn and possibly given a bit more context to the problem if suggestions were made.
Greg E
I'm hoping he wasn't scared of, but is trying to implement some of the suggestions. A query like that can take a long time to rewrite.

They came back. Final query - no unions, 9 sec runtime.

They were worth making suggestions to.

Greg E

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

Greg Edwards-268690 (10/19/2010)
Stefan Krzywicki (10/19/2010)
Greg Edwards-268690 (10/19/2010)
Alvin Ramard (10/19/2010)
Stefan Krzywicki (10/19/2010)
Alvin Ramard (10/19/2010)
Steve, do we have an award for this one?
http://www.sqlservercentral.com/Forums/Topic1007106-392-1.aspx
Should give him a Lincoln award for preserving the Union.
... and people say MY jokes are bad? 😛
Edit: Just can't get my fingers and brain to work at the same speed.
And for all the little Lincolns gathered as others throw their 2 cents worth in?
Seems to have gotten scared off, hope they come back and see there are a few good tips to be found.
I got the impression that they may be someone who would be willing to learn and possibly given a bit more context to the problem if suggestions were made.
Greg E
I'm hoping he wasn't scared of, but is trying to implement some of the suggestions. A query like that can take a long time to rewrite.
They came back. Final query - no unions, 9 sec runtime.
They were worth making suggestions to.
Greg E

How long was it taking before?

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 4

Alvin Ramard (10/19/2010)
Greg Edwards-268690 (10/19/2010)
Stefan Krzywicki (10/19/2010)
Greg Edwards-268690 (10/19/2010)
Alvin Ramard (10/19/2010)
Stefan Krzywicki (10/19/2010)
Alvin Ramard (10/19/2010)
Steve, do we have an award for this one?
http://www.sqlservercentral.com/Forums/Topic1007106-392-1.aspx
Should give him a Lincoln award for preserving the Union.
... and people say MY jokes are bad? 😛
Edit: Just can't get my fingers and brain to work at the same speed.
And for all the little Lincolns gathered as others throw their 2 cents worth in?
Seems to have gotten scared off, hope they come back and see there are a few good tips to be found.
I got the impression that they may be someone who would be willing to learn and possibly given a bit more context to the problem if suggestions were made.
Greg E
I'm hoping he wasn't scared of, but is trying to implement some of the suggestions. A query like that can take a long time to rewrite.
They came back. Final query - no unions, 9 sec runtime.
They were worth making suggestions to.
Greg E
How long was it taking before?

OP says:

This query currently takes the better part of an hour to run which is not at all acceptable but it does return the right results.

I can see how you'd miss that, as it's in the third sentence, and that's WAY too much to read....:w00t::-P:-D

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

jcrawf02 (10/19/2010)
I can see how you'd miss that, as it's in the third sentence, and that's WAY too much to read....:w00t::-P:-D

My input buffer filled up before I hit the end of the query. I aborted at that point.

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]

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 6

Alvin Ramard (10/19/2010)
jcrawf02 (10/19/2010)
I can see how you'd miss that, as it's in the third sentence, and that's WAY too much to read....:w00t::-P:-D
My input buffer filled up before I hit the end of the query. I aborted at that point.

I hear that happens a lot in the older engines...

:hehe:

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

TomThomson SSC Guru Points: 104773 More actions · Answer 7

I found this response http://www.sqlservercentral.com/Forums/FindPost1007296.aspx to a typical Celko post quite amusing.

Tom

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

Tom.Thomson (10/19/2010)
I found this response http://www.sqlservercentral.com/Forums/FindPost1007296.aspx to a typical Celko post quite amusing.

Your link doesn't work. There's a single quote at the end of the url. I removed it from the quote above.

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

jcrawf02 (10/19/2010)
...and, because I'm a complete and utter dork, it's almost 5, and I think it's funny, I'll repeat a poll I did at work today, assuming you guys will get it much faster.
If I said something was "For the greater good", would you get the literary reference, and what do you think it was from?
Wrong answers I got were hilarious:
•Nine inch nails
•Utilitarianism
•A Greater Good (History 1998–2008), an album by Neuroticfish
•The Greater Good, the unifying philosophy of the Tau in the table-top wargame Warhammer 40,000
•STEVE Murray (supposed to be Bill Murray)
•Animal Farm

Xena Warrior Princess?

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

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

CirquedeSQLeil (10/19/2010)
jcrawf02 (10/19/2010)
...and, because I'm a complete and utter dork, it's almost 5, and I think it's funny, I'll repeat a poll I did at work today, assuming you guys will get it much faster.
If I said something was "For the greater good", would you get the literary reference, and what do you think it was from?
Wrong answers I got were hilarious:
•Nine inch nails
•Utilitarianism
•A Greater Good (History 1998–2008), an album by Neuroticfish
•The Greater Good, the unifying philosophy of the Tau in the table-top wargame Warhammer 40,000
•STEVE Murray (supposed to be Bill Murray)
•Animal Farm
Xena Warrior Princess?

Damn, I defy anyone to top that.

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 11

The Incredibles?

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 12

jcrawf02 (10/19/2010)
CirquedeSQLeil (10/19/2010)
jcrawf02 (10/19/2010)
...and, because I'm a complete and utter dork, it's almost 5, and I think it's funny, I'll repeat a poll I did at work today, assuming you guys will get it much faster.
If I said something was "For the greater good", would you get the literary reference, and what do you think it was from?
Wrong answers I got were hilarious:
•Nine inch nails
•Utilitarianism
•A Greater Good (History 1998–2008), an album by Neuroticfish
•The Greater Good, the unifying philosophy of the Tau in the table-top wargame Warhammer 40,000
•STEVE Murray (supposed to be Bill Murray)
•Animal Farm
Xena Warrior Princess?
Damn, I defy anyone to top that.

Care Bears

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 13

Gianluca Sartori (9/21/2010)
Paul White NZ (9/20/2010)
Steve Jones - Editor (9/20/2010)
BTW, I got an appeal from Itzik that Window functions might not make SQL 11 and he's appealing people to upvote connect items.
http://www.sqlmag.com/blogs/puzzled-by-t-sql/tabid/1023/entryid/13085/Window-Functions-OVER-Clause-Help-Make-a-Difference.aspx
I have to admit that I'm not sure these are a huge win, or a hugely important add to SQL Server, but I'd like to know more. I think that the article makes a good case in the abstract, but it's hard to read and understand and I'd like to see more practical uses here that make a convincing case. Anyone got a good set of common things that they see, which would be improved with Window functions?
I don't think the additions are that important either, but my main worry is that they would be implemented poorly. Previous efforts with common logical features have used worktables or spools in various modes (recursive CTEs, PARTITION BY aggregates) and none have been sparkling performers, in general. Their other recent similar effort was PIVOT - enough said.
I agree that some of the new features have been implemented poorly, but I really would like to see those window functions in the next release. Once they're in the product I'm sure MS won't take away new features. If they end up with a poor implementation, Service Packs and CUs could be a way to deliver better algorithms.
I'm not sure Jeff's going to vote for ROWS/RANGE, for it would make the quirky update quite useless... 😛

Heh... I, for one, won't miss it. Instead of using the QU and listening to otherwise reasonable fellow MVP's lose their minds, we'll all be able to concentrate on applying Lead, Lag, SUM(), and COUNT() to do some amazing things.

I do fear the same thing that Paul White does... if their implementation is no more effective than what they did with Pivot and Unpivot, the I'd just as soon not see the implementation in 11. I'd rather they take their time a do it correctly.

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

Paul White NZ (9/21/2010)
Gianluca Sartori (9/21/2010)
I agree that some of the new features have been implemented poorly, but I really would like to see those window functions in the next release. Once they're in the product I'm sure MS won't take away new features. If they end up with a poor implementation, Service Packs and CUs could be a way to deliver better algorithms.
I can think of many other things I'd like to see added or improved first. Maybe my experience is unusual, but I don't find myself needing this sort of functionality very often. On the rare occasions that I do, there are a number of fine alternatives already - including Hugo Kornelis' set-based iteration method, and SQLCLR.
I may be in a glass half-empty mood today, but MS rarely go back and improve stuff after first release.

I prefer your simplified row number checker. It dosn't slow down much and doesn't have problems with unbalanced sets that Hugo's code does.

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

WayneS SSC Guru Points: 95460 More actions · Answer 15

Steve Jones - SSC Editor (10/19/2010)
WayneS (10/18/2010)
... we need several hundred years of records to know this, and we barely have one hundred. I also believe that this whole global warming stuff is all politicalized - and as usual, they are full of, well, hot air (to be nice about it).
I might argue we need several thousand years of records. The Earth has been around for a long time, and it's hard to know what the pattern is.

I won't disagree. My point is that we need a lot more information than what we actually have.

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