Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 11,941 through 11,955 (of 66,000 total)

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

Paul White SSC Guru Points: 150457 More actions · Answer 1

GSquared (2/22/2010)

Questions seem okay right now. Some of the answers have been abysmal recently. I guess it balances out somehow.

Ah yes the signal-to-noise thing. I've noticed a few people posting dodgy answers and advice, but I've rather enjoyed responding to them 😀

edit: tags

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

GSquared (2/22/2010)

Paul White (2/22/2010)

Is it just me...or are the posted questions getting better?

:smooooth:

Paul

Questions seem okay right now. Some of the answers have been abysmal recently. I guess it balances out somehow.

:blush: time for more reading, less writing.

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

Paul White SSC Guru Points: 150457 More actions · Answer 3

Paul White

SSC Guru

Points: 150457

February 22, 2010 at 7:36 am

#1122951

Chris Morris-439714 (2/22/2010)

:blush: time for more reading, less writing.

:laugh: Yeah, right! :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (2/22/2010)

Chris Morris-439714 (2/22/2010)

:blush: time for more reading, less writing.

:laugh: Yeah, right! :laugh:

No, really! And you, Mr White, should write an article on CROSS APPLY. I'm learning tons from reading your recent posts and I'm sure I'm not alone. In fact you could probably cobble together your last 50 or so to make an article. Who else can say with confidence "probably the best way to do this is with CROSS APPLY"?

We should know when and why it's best to use a particular method, but we're all lazy: "Nah, I'll do it this way 'cos I know it works". Then we whine about only gaining 50% over the "old" method, when really it's about the occasional ten-fold gain when the new method is mastered.

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

Trey Staker SSCarpal Tunnel Points: 4766 More actions · Answer 5

Chris Morris-439714 (2/22/2010)

Paul White (2/22/2010)

Chris Morris-439714 (2/22/2010)

:blush: time for more reading, less writing.

:laugh: Yeah, right! :laugh:

No, really! And you, Mr White, should write an article on CROSS APPLY. I'm learning tons from reading your recent posts and I'm sure I'm not alone. In fact you could probably cobble together your last 50 or so to make an article. Who else can say with confidence "probably the best way to do this is with CROSS APPLY"?

We should know when and why it's best to use a particular method, but we're all lazy: "Nah, I'll do it this way 'cos I know it works". Then we whine about only gaining 50% over the "old" method, when really it's about the occasional ten-fold gain when the new method is mastered.

I'll second this one... I'd love to see a good article on Cross APPLY.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

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

Chris Morris-439714 (2/22/2010)

No, really! And you, Mr White, should write an article on APPLY. I'm learning tons from reading your recent posts and I'm sure I'm not alone. In fact you could probably cobble together your last 50 or so to make an article. Who else can say with confidence "probably the best way to do this is with CROSS APPLY"?

We should know when and why it's best to use a particular method, but we're all lazy: "Nah, I'll do it this way 'cos I know it works". Then we whine about only gaining 50% over the "old" method, when really it's about the occasional ten-fold gain when the new method is mastered.

Well thanks very much! Gosh. :blush:

I just don't know that I'm ready for the world-wide fame that comes from being published on SSC :Wow:

http://www.tui.co.nz/default.asp?s1=Cool%20Shit&s2=Yeah%20Right%20Map

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White

SSC Guru

Points: 150457

February 22, 2010 at 8:12 am

#1122973

tstaker (2/22/2010)

I'll second this one... I'd love to see a good article on APPLY.

Ok, ok! I'll give it some thought...:cool:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (2/22/2010)

Chris Morris-439714 (2/22/2010)

No, really! And you, Mr White, should write an article on APPLY. I'm learning tons from reading your recent posts and I'm sure I'm not alone. In fact you could probably cobble together your last 50 or so to make an article. Who else can say with confidence "probably the best way to do this is with CROSS APPLY"?

We should know when and why it's best to use a particular method, but we're all lazy: "Nah, I'll do it this way 'cos I know it works". Then we whine about only gaining 50% over the "old" method, when really it's about the occasional ten-fold gain when the new method is mastered.

Well thanks very much! Gosh. :blush:

I just don't know that I'm ready for the world-wide fame that comes from being published on SSC :Wow:

http://www.tui.co.nz/default.asp?s1=Cool%20Shit&s2=Yeah%20Right%20Map

Paul, I look forward to checking out your link later at home, it's probably classed as "restricted" here. OTOH, our company website is probably classed as "restricted" where you are.

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

Paul White SSC Guru Points: 150457 More actions · Answer 9

Chris Morris-439714 (2/22/2010)

Paul, I look forward to checking out your link later at home, it's probably classed as "restricted" here. OTOH, our company website is probably classed as "restricted" where you are.

I am at home - it's 4:34am in NZ. So, I was able to enjoy your link in full. Sweet.

My link is just to a local brewery who happen to use 'yeah, right' in their advertisements.

Some are quite amusing.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Paul White (2/22/2010)

I just don't know that I'm ready for the world-wide fame that comes from being published on SSC :Wow:

You certainly are, and just because there's an article out there doesn't mean we wouldn't want one here. Especially from the famous Paul White.

Be sure to include some pictures of sheep for your tally table. 😛

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

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

Steve Jones - Editor (2/22/2010)

Paul White (2/22/2010)

I just don't know that I'm ready for the world-wide fame that comes from being published on SSC :Wow:

You certainly are, and just because there's an article out there doesn't mean we wouldn't want one here. Especially from the famous Paul White.

Be sure to include some pictures of sheep for your tally table. 😛

Which begs the question, does Jeff count pigs when he's tired? (pork chops, get it? pork... chops... never mind)

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

WayneS SSC Guru Points: 95405 More actions · Answer 12

Paul White (2/22/2010)

tstaker (2/22/2010)

I'll second this one... I'd love to see a good article on APPLY.

Ok, ok! I'll give it some thought...:cool:

Well??? Haven't you had enough time to think about it? Anything else we can do to convince you? Twist your arm a little more?

Seriously, this seems like an excellent topic, and you'd do a "totally awesome" job of it!

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

Steve Jones - SSC Editor SSC Guru Points: 728159 More actions · Answer 13

Steve Jones - SSC Editor

SSC Guru

Points: 728159

February 22, 2010 at 4:28 pm

#1123353

Ahh, the Thread is quiet. Or are we waiting for Paul's answer?

Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com

SQLRNNR SSC Guru Points: 281324 More actions · Answer 14

Steve Jones - Editor (2/22/2010)

Ahh, the Thread is quiet. Or are we waiting for Paul's answer?

Nah, we're just playing hide 'n seek. We hid it, now you find it 😉

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 15

Hey! I almost missed this, but Itzik Ben-Gan gave me kudos in his column this month for solving on of his 'unsolveable'(?) puzzles! How come no one told me about this?!?! :w00t::w00t:

[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]