Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,206 through 20,220 (of 66,738 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions on good, inexpensive, close places to stay? Guys to share a room with? Are any discounts still available? It's looking like it's going to cost us about $3k... does that seem about right to you'll?

I might could do with a room-mate for the week.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

TSQL Tuesday Post is done and in - even early. I found some interesting articles on the internet that perpetuated the myth too. I didn't reference them in the TSQL2sday post, but there is bad info out there. Post was simple and sweet - keeping it to the point. I probably missed a bunch on it - but I wanted to debunk at the base level.

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 3

CirquedeSQLeil (10/11/2010)
I found some interesting articles on the internet that perpetuated the myth too. I didn't reference them in the TSQL2sday post, but there is bad info out there.

Tell me about it. The mass of misinformation I found on table variables was frightening. That I found a disprovable myth stated as truth on an MSDN blog didn't help.

This site was somewhere between terrifying and hilarious - http://www.allinterview.com/showanswers/65496.html

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: 150468 More actions · Answer 4

GilaMonster (10/11/2010)
That I found a disprovable myth stated as truth on an MSDN blog didn't help.

I know you want to provide a link to that 🙂

GilaMonster (10/11/2010)
This site was somewhere between terrifying and hilarious - http://www.allinterview.com/showanswers/65496.html

Terrifying. Maybe I will experience some of the humour later, but for now, I'm just plain scared.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

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

george sibbald (10/11/2010)
WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions on good, inexpensive, close places to stay? Guys to share a room with? Are any discounts still available? It's looking like it's going to cost us about $3k... does that seem about right to you'll?
All together now.........
Y - M - C - A...............

Yuck. I stayed at the Y in New Orleans for an endocrine conference back in '89. It was disgusting, roaches and used needles everywhere. Norlinz was gorgeous back then, but no, not the Y.

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

Brandie Tarvin SSC Guru Points: 173080 More actions · Answer 6

Paul White NZ (10/11/2010)
Jack Corbett (10/11/2010)
$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.
A cheaper room-mate? :blink:

Hey! I may be cheap, but I'm not easy!

@=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 7

Brandie Tarvin (10/12/2010)
Paul White NZ (10/11/2010)
Jack Corbett (10/11/2010)
$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.
A cheaper room-mate? :blink:
Hey! I may be cheap, but I'm not easy!
@=)

That's OK. I've got both bases covered.

"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

WayneS SSC Guru Points: 95460 More actions · Answer 8

GilaMonster (10/11/2010)
CirquedeSQLeil (10/11/2010)
I found some interesting articles on the internet that perpetuated the myth too. I didn't reference them in the TSQL2sday post, but there is bad info out there.
Tell me about it. The mass of misinformation I found on table variables was frightening. That I found a disprovable myth stated as truth on an MSDN blog didn't help.
This site was somewhere between terrifying and hilarious - http://www.allinterview.com/showanswers/65496.html

My first though, on reading this link, was "OMG".

Well, I just found one good use for this URL... I'm going to use it as a Q&A at the end of my presentation, to see if the attendees of the presentation now know what the proper answer is. Now, to incorporate 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

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

Paul White NZ (10/12/2010)
GilaMonster (10/11/2010)
This site was somewhere between terrifying and hilarious - http://www.allinterview.com/showanswers/65496.html
Terrifying. Maybe I will experience some of the humour later, but for now, I'm just plain scared.

The humour side of it (well, for me anyway) is that anyone using that for interviews has likely done themselves more harm than good.

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: 150468 More actions · Answer 10

GilaMonster (10/12/2010)
...anyone using that for interviews has likely done themselves more harm than good.

Unless the interviewer provided one of those answers...:pinch:

Yikes.

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

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

Paul White NZ (10/12/2010)
GilaMonster (10/12/2010)
...anyone using that for interviews has likely done themselves more harm than good.
Unless the interviewer provided one of those answers...:pinch:
Yikes.

If that is the case, I wonder if they pad the voting too?:-P

Let's see - do I make it seem like the most correct by lots of YES votes...

Or make it have NO votes to see how much they know?

Good use for the site might be to have an interviewee comment on a thread like that.

Greg E

Jeff Moden SSC Guru Points: 1004410 More actions · Answer 12

WayneS (10/11/2010)
Jeff Moden (10/10/2010)
WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions on good, inexpensive, close places to stay? Guys to share a room with? Are any discounts still available? It's looking like it's going to cost us about $3k... does that seem about right to you'll?
Do you snore? I actually don't want your opinion on that... ask your wife. Do you snore? 😉
She says yes - a little bit louder than heavy breathing.
Just remembered that I'm also scheduled to give my presentation to my UG on that Thursday....

No pun intended, but I'll have to pass then. I'm a super light sleeper. Yeah... it's been a problem all my life and was really tough in the service.

--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: 1004410 More actions · Answer 13

GilaMonster (10/12/2010)
Paul White NZ (10/12/2010)
GilaMonster (10/11/2010)
This site was somewhere between terrifying and hilarious - http://www.allinterview.com/showanswers/65496.html
Terrifying. Maybe I will experience some of the humour later, but for now, I'm just plain scared.
The humour side of it (well, for me anyway) is that anyone using that for interviews has likely done themselves more harm than good.

I agree... there should be a bio-hazard warning on that site. I can see someone using it as a source of questions but not many of the answers.

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

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

Grant Fritchey (10/12/2010)
Brandie Tarvin (10/12/2010)
Paul White NZ (10/11/2010)
Jack Corbett (10/11/2010)
$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.
A cheaper room-mate? :blink:
Hey! I may be cheap, but I'm not easy!
@=)
That's OK. I've got both bases covered.

Heh DBADatingCentral 🙂

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

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

Jeff Moden (10/12/2010)
WayneS (10/11/2010)
Jeff Moden (10/10/2010)
WayneS (10/10/2010)
Hey gang... not definite yet, but my wife is talking about letting me spend the $ to go to PASS. 😀
Any suggestions on good, inexpensive, close places to stay? Guys to share a room with? Are any discounts still available? It's looking like it's going to cost us about $3k... does that seem about right to you'll?
Do you snore? I actually don't want your opinion on that... ask your wife. Do you snore? 😉
She says yes - a little bit louder than heavy breathing.
Just remembered that I'm also scheduled to give my presentation to my UG on that Thursday....
No pun intended, but I'll have to pass then. I'm a super light sleeper. Yeah... it's been a problem all my life and was really tough in the service.

At the risk of encountering a porcine missile, have you ever heard of earplugs? 😀

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