Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 20,176 through 20,190 (of 66,738 total)

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

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

Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
I don't know. I sensed a touch of attitude underneath. Call me skeptical.
Maybe, but the fact that he didn't insult the poster or the database design with his usual backhanded theatrics gives me hope.

Hope is a 4 letter word too. 😛

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 2

Alvin Ramard (10/8/2010)
Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
I don't know. I sensed a touch of attitude underneath. Call me skeptical.
Maybe, but the fact that he didn't insult the poster or the database design with his usual backhanded theatrics gives me hope.
Hope is a 4 letter word too. 😛

Hope is the shining light at the end of the tunnel that's getting closer... and you realize you'll soon be free until you remember you got tied to the tracks an hour ago.

If DBA's start learning hope, they'll start to dream, then they might be happy. A happy DBA is a disaster waiting to happen. Worlds will explode, DBCC Timewarp will stop functioning due to the inverted depression matrix theorum, and users will get timely results instead of sending requests to the dark place known as the NOC... No... no hope here, please. We don't want to be the cause of such disasters.

- 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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

Craig Farrell (10/8/2010)
Alvin Ramard (10/8/2010)
Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
I don't know. I sensed a touch of attitude underneath. Call me skeptical.
Maybe, but the fact that he didn't insult the poster or the database design with his usual backhanded theatrics gives me hope.
Hope is a 4 letter word too. 😛
Hope is the shining light at the end of the tunnel that's getting closer... and you realize you'll soon be free until you remember you got tied to the tracks an hour ago.
If DBA's start learning hope, they'll start to dream, then they might be happy. A happy DBA is a disaster waiting to happen. Worlds will explode, DBCC Timewarp will stop functioning due to the inverted depression matrix theorum, and users will get timely results instead of sending requests to the dark place known as the NOC... No... no hope here, please. We don't want to be the cause of such disasters.

So you are saying that hope is only the four letter word for train?

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

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

Craig Farrell (10/8/2010)
Alvin Ramard (10/8/2010)
Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
I don't know. I sensed a touch of attitude underneath. Call me skeptical.
Maybe, but the fact that he didn't insult the poster or the database design with his usual backhanded theatrics gives me hope.
Hope is a 4 letter word too. 😛
Hope is the shining light at the end of the tunnel that's getting closer... and you realize you'll soon be free until you remember you got tied to the tracks an hour ago.
If DBA's start learning hope, they'll start to dream, then they might be happy. A happy DBA is a disaster waiting to happen. Worlds will explode, DBCC Timewarp will stop functioning due to the inverted depression matrix theorum, and users will get timely results instead of sending requests to the dark place known as the NOC... No... no hope here, please. We don't want to be the cause of such disasters.

I'm reading Terry Pratchett books for the first time (yeah, yeah, whatever, I've been busy), and he had a great one in Mort: "The light at the end of the tunnel, that's a flamethrower."

"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

TomThomson SSC Guru Points: 104773 More actions · Answer 5

Grant Fritchey (10/8/2010)
Craig Farrell (10/8/2010)
Alvin Ramard (10/8/2010)
Brandie Tarvin (10/8/2010)
Ray K (10/8/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
I don't know. I sensed a touch of attitude underneath. Call me skeptical.
Maybe, but the fact that he didn't insult the poster or the database design with his usual backhanded theatrics gives me hope.
Hope is a 4 letter word too. 😛
Hope is the shining light at the end of the tunnel that's getting closer... and you realize you'll soon be free until you remember you got tied to the tracks an hour ago.
If DBA's start learning hope, they'll start to dream, then they might be happy. A happy DBA is a disaster waiting to happen. Worlds will explode, DBCC Timewarp will stop functioning due to the inverted depression matrix theorum, and users will get timely results instead of sending requests to the dark place known as the NOC... No... no hope here, please. We don't want to be the cause of such disasters.
I'm reading Terry Pratchett books for the first time (yeah, yeah, whatever, I've been busy), and he had a great one in Mort: "The light at the end of the tunnel, that's a flamethrower."

And hope is the firmly held belief not only that there is a flamethrower at the end of the tunnel but also that this is a good thing. The result of hope is that a DBA who suffers from it, when he finds himself stuck in a tunnel that leads nowhere useful, ardently(1) desires a flamethrower to place at its end and therefor creates one, using something like shrinkfile or hibernate or full recovery model with no log backup or simple recovery model with full backup daily and differential backup every thirty seconds (2) to ignite all sorts of fires.

notes

(1) in case there are any ignorant Americans reading this British rant, may I remind them that "ardently" means "burningly" and that this is the only appropriate way to desire a flamethrower? And if there are any other Americans reading it, will they please contact the compilers of the Guinness book of records?

(2) I think the worse one I've actually seen was using full recovery model, twice daily log backup, one full database backup before the log backups started, and no further full backups (ever); after quite a long time (a bit more than a year - this was a low activity database) the dba noticed (or had it pointed out to him) that the log backups were taking up a lot of space, so he added a log backup deletion rule that deleted log backups older than two weeks (thus going from using a ridiculous amount of space but being able to recover, although it might take a long time to apply more than 730 log backup files, to using a more sensible amount of space but being completely unable to recover). Now, I have a great ability to do utterly stupid things; but I've never managed to approach that level.

Tom

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

******* BUMP ********

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

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

Well that's my T-SQL Tuesday post done and scheduled. Took me far longer than I had planned to write.

Has anyone here, other than Wayne, written a blog post or article showing that table variables are part of tempDB by querying the tempDB system tables (sys.objects, sys.tables, sys.columns)? If so, pls post link.

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

WayneS SSC Guru Points: 95460 More actions · Answer 8

GilaMonster (10/10/2010)
Well that's my T-SQL Tuesday post done and scheduled. Took me far longer than I had planned to write.

Well, you did say you were debunking three myths. I bet all the other bloggers are just going after one.

Has anyone here, other than Wayne, written a blog post or article showing that table variables are part of tempDB by querying the tempDB system tables (sys.objects, sys.tables, sys.columns)? If so, pls post link.

Oh, I see. Mine doesn't count. :-D:-P:hehe::cool:

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

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 9

Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.

Heh... the lion sleeps. That wasn't being polite and useful... that was a simple absence of malice. 😉 He simply decided that, today, he wasn't going to "kill" although I believe it probably hurt his back. :hehe:

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

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?

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

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 11

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? 😉

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

Jeff Moden (10/10/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
Heh... the lion sleeps. That wasn't being polite and useful... that was a simple absence of malice. 😉 He simply decided that, today, he wasn't going to "kill" although I believe it probably hurt his back. :hehe:

Or, it might have something to do with Steve talking to him

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 13

WayneS (10/10/2010)
Jeff Moden (10/10/2010)
Gianluca Sartori (10/8/2010)
At last, Mr. Celko gives a polite and useful answer to a poor-worded question.
It's nice to see everyone can learn.
Heh... the lion sleeps. That wasn't being polite and useful... that was a simple absence of malice. 😉 He simply decided that, today, he wasn't going to "kill" although I believe it probably hurt his back. :hehe:
Or, it might have something to do with Steve talking to him

He doesn't seem to be a person that can be convinced or scared easily.

I'm not questioning Steve's persuasion skills, but Joe's listening abilities...

-- Gianluca Sartori

WayneS SSC Guru Points: 95460 More actions · Answer 14

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

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 15

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?

$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate. I think the Red Lion(?) hotel is fairly inexpensive and close by (walking distance). I think Gail has stayed there.

There are forums on the Summit web site, http://www.sqlpass.org/summit/na2010/Connect/Forums.aspx, for trying to find a room/roommate as well.

Don't forget to use the SSC10 code for $200 off Summit registration AND a ticket to the SSC party on Monday night ($30 if you don't use the code).

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question