Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 18,826 through 18,840 (of 66,712 total)

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

WayneS SSC Guru Points: 95460 More actions · Answer 1

You know, I feel for both Gail and the OP here. I think the OP is under a lot of pressure and getting desperate to fix it. And Gail, of course, is plugging right along trying to get everything working right.

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

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

WayneS (9/16/2010)
You know, I feel for both Gail and the OP here. I think the OP is under a lot of pressure and getting desperate to fix it. And Gail, of course, is plugging right along trying to get everything working right.

Yeah, I tried to help a little but I'm afraid of either stepping on Gail trying to help him, or even worse getting him confused if I continue. I am mostly just reading along and seeing if anything new to me comes up. 🙂 I have to agree with your sentiment, though, Wayne, Gail is VERY good at this.

@Gail: Trial by fire much?

- 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

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

Craig Farrell (9/16/2010)
@Gail: Trial by fire much?

Actually no. In last 5 years I've had:

- One database with corrupt log that required a restore

- One very long restart/recovery (12 hours) resulting from poor (non-existent almost) I/O throughput

- One corrupt (RECOVERY_PENDING) database that after 12 hours of work and several tricks that shouldn't be in any book) was declared a complete loss.

Also talked a client through a restore to point-in-time (dropped table) over the phone

Of course, that excludes all the test databases that I've killed on my personal machine. No better way to learn than to cause the problem and then try and recover from it.

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

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

The Dixie Flatline (9/16/2010)
CirquedeSQLeil (9/16/2010)
Did Bob change his Avatar again?
Avatar? What avatar?
I see you, Jason.

Eywa hates you for that joke

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

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

Jeff Moden (9/16/2010)
Heh... you and your cat's had brain surgery? That explains a lot, Jon. 😛

Yeah, we swapped. It was a step up for me.

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

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

Stefan Krzywicki (9/16/2010)
GilaMonster (9/16/2010)
Stefan Krzywicki (9/16/2010)
Eats, Shoots and Leaves?
Yup. Borrowed it from a friend (M.A English Lit) and loved it.
It is a great book.

Have you read Anguished English?

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

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

GilaMonster (9/16/2010)
Actually no. In last 5 years I've had:
- One database with corrupt log that required a restore
- One very long restart/recovery (12 hours) resulting from poor (non-existent almost) I/O throughput
- One corrupt (RECOVERY_PENDING) database that after 12 hours of work and several tricks that shouldn't be in any book) was declared a complete loss.
Also talked a client through a restore to point-in-time (dropped table) over the phone
Of course, that excludes all the test databases that I've killed on my personal machine. No better way to learn than to cause the problem and then try and recover from it.

I'm seriously doing it wrong. 🙂 I think I've dealt with 10-12x the number of sillyness with T-log overfills, recovery problems, corrupted raid drives, etc... and I still can't keep up with you on the knowledge.

Where's that kowtow smiley when you need it? Closest I got: :smooooth:

One of these days I'd love to just pick your brain awhile. 🙂

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

The Dixie Flatline (9/16/2010)
CirquedeSQLeil (9/16/2010)
Did Bob change his Avatar again?
Avatar? What avatar?
I see you, Jason.

Are you so sure? If I close my eyes, can you see me now?

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

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

No!!

I disappeared!! :w00t:

__________________________________________________

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

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 10

Paul White NZ (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
What's humour? You hanging out with Brit's in TN?
He's finally learnt to spell properly. 😀
Perhaps a course on the correct use of apostrophes next?
😛

Heh... on that subject... how many people think that apostrophies should be used only to show possession or as a method of contraction?

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

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

Paul White NZ (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
What's humour? You hanging out with Brit's in TN?
He's finally learnt to spell properly. 😀
Perhaps a course on the correct use of apostrophes next?
😛

Brit's for Brit[ish citizen]s or maybe it's supposed to be Brit'sh for British. Not sure.

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

Jeff Moden (9/16/2010)
Paul White NZ (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
What's humour? You hanging out with Brit's in TN?
He's finally learnt to spell properly. 😀
Perhaps a course on the correct use of apostrophes next?
😛
Heh... on that subject... how many people think that apostrophies should be used only to show possession or as a method of contraction?

Why do I think I'm gonna regret this? That'd be me under that heading.

- 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

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

Steve Jones - SSC Editor

SSC Guru

Points: 736270

September 16, 2010 at 2:54 pm

#1222636

'postro-fees are also used to show a bit o' an accent.

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

Jeff Moden (9/16/2010)
Paul White NZ (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
What's humour? You hanging out with Brit's in TN?
He's finally learnt to spell properly. 😀
Perhaps a course on the correct use of apostrophes next?
😛
Heh... on that subject... how many people think that apostrophies should be used only to show possession or as a method of contraction?

Can you give an example of an apostrophy used for something else?

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 15

Alvin Ramard (9/16/2010)
Jeff Moden (9/16/2010)
Paul White NZ (9/16/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
What's humour? You hanging out with Brit's in TN?
He's finally learnt to spell properly. 😀
Perhaps a course on the correct use of apostrophes next?
😛
Heh... on that subject... how many people think that apostrophies should be used only to show possession or as a method of contraction?
Can you give an example of an apostrophy used for something else?

Select 'this is another use for an a-pos trophy'

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