Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 13,711 through 13,725 (of 66,815 total)

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

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

The Dixie Flatline (4/1/2010)
Hmmm.... who do we know in the neighborhood?

Do we have an active Field Agent out there? :w00t:

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 2

Paul White NZ (4/1/2010)
Grant Fritchey (4/1/2010)
There's no way I can see to comment on the article. Shame really because that shouldn't be alllowed to stand as written.
I looked for that too - my frustration at not being able to comment was part of the reason I posted here.

Pinged the author. we'll see if he responds.

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

The Dixie Flatline (4/1/2010)
From the "About The Author" section.
Eric is active in the local SQL Server Community, serving as the president of the Colorado Springs SQL Server Users Group.
Copyright 2007 TechTarget
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1280004,00.html
Hmmm.... who do we know in the neighborhood?
I also noticed that he was linking to an article by Denny Cherry which essentially makes the same incorrect statements about table variables. So it's a classic case of bad information being perpetuated. Hopefully, the discussion of the articles by their paying members clears that up.

Ready for another road trip? 😛

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]

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

FYI, here's the suggestion I had sent to Steve for today's QOD:

[font="Verdana"]The undocumented command DBCC TimeWarp 'VerifyOnly'

(Select all that apply)

A - Returns the same results with SQL 2008 Enterprise Edition as "DBCC TimeWarp" with SQL 2005

B - Returns the same results with SQL 2008 Enterprise Edition as "DBCC check_db" with SQL 2000 Standard Edition

C - Is not supported with SQL Express 2005

D - Generates an error with SQL 2000 All Editions, SQL 2005 All Edition, and SQL 2008 Standard Edition

E - All of the above

F - None of the above

[/font]

What's the correct answer?

Edit: I swapped the order of answers E & F

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]

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

E.

Edited, because Alvin timewarped the answers after I answered.

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

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

GilaMonster (4/1/2010)
F.

Since I swapped the order of the answers, your answer would now be E - All of the 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]

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

E

__________________________________________________

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

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

Dangit... I hoped to be one-up on Gail just once before I die. Of course if F and E were reversed, there would have been no right answer.... and I hear from Steve that NULLS have been deprecated.

__________________________________________________

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

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

Usually F.

SET LANGUAGE TO hamster for E.

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

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

I thought "hamster" was a collation.

__________________________________________________

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

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 11

NULLs HAVE been deprecated, haven't you heard. SQL 11 will have no NULLs, Start rewriting now, defaults required, blah, blah, april fools, new code, more work, etc. etc.

george sibbald SSC Guru Points: 104210 More actions · Answer 12

got caught by the 'quoting whilst new post pops up' trick

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

george sibbald SSC Guru Points: 104210 More actions · Answer 13

Alvin Ramard (4/1/2010)
FYI, here's the suggestion I had sent to Steve for today's QOD:
[font="Verdana"]The undocumented command DBCC TimeWarp 'VerifyOnly'
(Select all that apply)
A - Returns the same results with SQL 2008 Enterprise Edition as "DBCC TimeWarp" with SQL 2005
B - Returns the same results with SQL 2008 Enterprise Edition as "DBCC check_db" with SQL 2000 Standard Edition
C - Is not supported with SQL Express 2005
D - Generates an error with SQL 2000 All Editions, SQL 2005 All Edition, and SQL 2008 Standard Edition
E - All of the above
F - None of the above
[/font]
What's the correct answer?
Edit: I swapped the order of answers E & F

nasty and devious Alvin. Save it for April 01 next year.

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

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

george sibbald (4/1/2010)
got caught by the 'quoting whilst new post pops up' trick

I've had that problem too. Need to remember to always hit F5 before clicking Quote.

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]

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

Steve Jones - Editor (4/1/2010)
NULLs HAVE been deprecated, haven't you heard. SQL 11 will have no NULLs, Start rewriting now, defaults required, blah, blah, april fools, new code, more work, etc. etc.

How can NULLs be NULLified in a version that doesn't support NULLs? 😛

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]