Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 19,186 through 19,200 (of 66,712 total)

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

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

GilaMonster (9/23/2010)
Paul White NZ (9/22/2010)
Oh - that one! I must admit I had to walk away and do something else for half an hour before replying to his "It won't effect any thing" response.
I edited my response 4 times before actually posting it. And had coffee and a few minutes playing a game between reading and trying to formulate a reply.

I'm glad it wasn't just me. Thanks for the amusing mental imagery.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 2

But his results did get better after removing 90% of the data.

Clear Sky SQL
My Blog[/url]

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

I'll suggest that when performance degrades.

I'm sure at least one of my co-workers would say "Why not?" :w00t:

-- Gianluca Sartori

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

Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.

Yeah, surprising that. (not)

I must add that to my optimisation advice. "Try adding this index. If it doesn't work (or you think it won't work), delete 90% of the data from the table"

Hmm....

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

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 5

GilaMonster (9/23/2010)
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Yeah, surprising that. (not)
I must add that to my optimisation advice. "Try adding this index. If it doesn't work (or you think it won't work), delete 90% of the data from the table"
Hmm....

Working on a new presentation , "Table truncation for optimization" . Its got a nice ring to it 🙂

Clear Sky SQL
My Blog[/url]

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

It really kills me when someone's first response to a performance question is "Add another index."

Granted, I haven't read the rest of the thread (I shall go back and do that now), but the idea of overloading a table with indexes because one query is slow makes me cringe.

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.

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

does anyone see a use for dbcc timewarp here:

http://www.sqlservercentral.com/Forums/Topic991811-146-1.aspx

or maybe sp_configure 'go faster',1

which reminds, the article on what we would like to see in SQL, a go faster button is a definite must.

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

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

george sibbald (9/23/2010)
does anyone see a use for dbcc timewarp here:
http://www.sqlservercentral.com/Forums/Topic991811-146-1.aspx
or maybe sp_configure 'go faster',1

I was really tempted to reply to that with a link to my April Fools post. Decided it might be in bad taste though.

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: 150467 More actions · Answer 9

Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.

Thanks for reminding me of the other thing he said that made me want to chew my own arm off :hehe:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Brandie Tarvin (9/23/2010)
It really kills me when someone's first response to a performance question is "Add another index."
Granted, I haven't read the rest of the thread (I shall go back and do that now), but the idea of overloading a table with indexes because one query is slow makes me cringe.

I agree, especially with the last query they found slow.

I would have taken one of the wildcard selections an used it inside an exists statement.

I really did enjoy the deletion improved performance.

I'll have to keep that in mind when I run into a performance problem.

Greg E

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

Dave Ballantyne (9/23/2010)
GilaMonster (9/23/2010)
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Yeah, surprising that. (not)
I must add that to my optimisation advice. "Try adding this index. If it doesn't work (or you think it won't work), delete 90% of the data from the table"
Hmm....
Working on a new presentation , "Table truncation for optimization" . Its got a nice ring to it 🙂

SQL Chop Shop?

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

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

Dave Ballantyne (9/23/2010)
GilaMonster (9/23/2010)
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
Yeah, surprising that. (not)
I must add that to my optimisation advice. "Try adding this index. If it doesn't work (or you think it won't work), delete 90% of the data from the table"
Hmm....
Working on a new presentation , "Table truncation for optimization" . Its got a nice ring to it 🙂

Don't forget that after truncation, setting the DB to read only will help you maintain that performance boost. 😎

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]

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 13

Alvin Ramard (9/23/2010)
Dave Ballantyne (9/23/2010)
GilaMonster (9/23/2010)
Dave Ballantyne (9/23/2010)
But his results did get better after removing 90% of the data.
I must add that to my optimisation advice. "Try adding this index. If it doesn't work (or you think it won't work), delete 90% of the data from the table"
Working on a new presentation , "Table truncation for optimization" . Its got a nice ring to it 🙂
Don't forget that after truncation, setting the DB to read only will help you maintain that performance boost. 😎

Better yet, give all the users db_owner or sysadmin access. That will speed everything up because then you won't have to worry about queries that fail for lack of permission. @=)

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.

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 14

Paul White NZ (9/22/2010)
GilaMonster (9/22/2010)
Sometimes I wonder if people think we're posting for our health or something.
<several people>: Change the index thusly
OP: That won't help.
<couple people>: Did you try it?
OP: That helped a lot.
http://www.sqlservercentral.com/Forums/FindPost990881.aspx
Oh - that one! I must admit I had to walk away and do something else for half an hour before replying to his "It won't effect any thing" response. :blink: :angry: :crazy: :doze: :rolleyes: :satisfied:

Reminds me of an OP that blew off a suggestion I had made. Last I heard from him after calling him on it (iirc) was that he had to wait for permission to try it.

Guess I'll check back on that thread (if I can find it) tonight.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

GilaMonster (9/22/2010)
Sometimes I wonder if people think we're posting for our health or something.
<several people>: Change the index thusly
OP: That won't help.
<couple people>: Did you try it?
OP: That helped a lot.
http://www.sqlservercentral.com/Forums/FindPost990881.aspx

Yup - just like we talk just to hear the sound of our own voice

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