Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 21,751 through 21,765 (of 66,712 total)

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

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

Jeff Moden (11/22/2010)
Hmmm... reminds me... why did I work 71 hours last week? :blink:

I've been wondering much the same recently...

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 2

GilaMonster (11/23/2010)
Anyone up for a challenge?
http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx
I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of NOLOCK to start with.

I would help, but am temporarily (I hope) blind having glanced at the stored procedure in question.

AWE not enabled on an x86 machine with 32GB RAM was another highlight.

Honestly, this place terrifies me sometimes.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

Unfortunately, for him, he doesent know sargable.

Clear Sky SQL
My Blog[/url]

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

All of us began our SQL Server lives knowing nothing at all about it and we didn't learn what we now know overnight 😉

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

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

Paul White NZ (11/23/2010)
I would help, but am temporarily (I hope) blind having glanced at the stored procedure in question.

Same here. Plus I neither have the time nor the inclination for wading through that mess.

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

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 6

Paul White NZ (11/23/2010)
GilaMonster (11/23/2010)
Anyone up for a challenge?
http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx
I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of NOLOCK to start with.
I would help, but am temporarily (I hope) blind having glanced at the stored procedure in question.
AWE not enabled on an x86 machine with 32GB RAM was another highlight.
Honestly, this place terrifies me sometimes.

I see how you consultants keep making money though. Seems like these shops are mushrooms. They're springing up all over the place.

There was so much low hanging fruit in that query, I just glanced around and picked out a few. I'm sure not wasting much time on it. Those guys have just tons of fundamental work to do.

"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

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

Grant Fritchey (11/23/2010)
I see how you consultants keep making money though.

Yup, but a lot of the 'get it done now, we don't care' companies won't call in competent consultants (they're too expensive).

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

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

Paul White NZ (11/23/2010)
GilaMonster (11/23/2010)
Anyone up for a challenge?
http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx
I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of NOLOCK to start with.
I would help, but am temporarily (I hope) blind having glanced at the stored procedure in question.
AWE not enabled on an x86 machine with 32GB RAM was another highlight.
Honestly, this place terrifies me sometimes.

I hope your blindness has passed.:-D

I personally liked all the select distincts.

That usually seems to indicate a missing join, or you might need to review the design of the db.

This place sometimes terrifies you? Some of the OP's might be terrified to step in the door at work in the morning.

It's always interesting to wonder if they were part of creating the mess they're in, or they just got stuck with it.

Greg E

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

Greg Edwards-268690 (11/23/2010)
I personally liked all the select distincts.
That usually seems to indicate a missing join, or you might need to review the design of the db.

Or that someone's doing a one-to-many JOIN without realizing the consequences. There are legitimate reasons to use SELECT DISTINCT. But there are also ways to filter that information in an ON or WHERE clause, or with a sub-query, so that a DISTINCT doesn't have to be used.

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.

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

Grant Fritchey (11/23/2010)
I see how you consultants keep making money though. Seems like these shops are mushrooms. They're springing up all over the place.

There are stories I could tell, but not in public. Ask me next time we're in the same city, same time.

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

grahamc SSCertifiable Points: 6762 More actions · Answer 11

GilaMonster (11/23/2010)
Paul White NZ (11/23/2010)
I would help, but am temporarily (I hope) blind having glanced at the stored procedure in question.
Same here. Plus I neither have the time nor the inclination for wading through that mess.

hence my response of "get a professional" when I saw the procedures... so fun for someone though 😉

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

Thanks again for all the well-wishes, thoughts, and prayers. I got out of the hospital yesterday and get to spend the morning making follow-up appointments.

Totally no evidence of a heart attack, but some other issues like cholesterol and high liver enzymes that need to be monitored and controlled. Going to have a stress test in a couple of weeks (still need to schedule) to make sure the high cholesterol hasn't already caused blockages. Then need to have a scope to check out digestive system.

One of the issues with acid reflux is that you can get the same symptoms as a heart attack.

Back in the office today because it is less stressful than being home with the kids all day (they get the whole week off from school).

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

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

Glad you're out of the hospital, Jack. I hope you're feeling better.

Try to have a little fun at work if it's less stressful then the kids. And if you need me to drive down and whack some sense into someone, let me know. I'm only a hop-skip-jump away. @=)

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.

Kit G SSCrazy Points: 2888 More actions · Answer 14

Jack Corbett (11/23/2010)
Thanks again for all the well-wishes, thoughts, and prayers. I got out of the hospital yesterday and get to spend the morning making follow-up appointments.
Totally no evidence of a heart attack, but some other issues like cholesterol and high liver enzymes that need to be monitored and controlled. Going to have a stress test in a couple of weeks (still need to schedule) to make sure the high cholesterol hasn't already caused blockages. Then need to have a scope to check out digestive system.
One of the issues with acid reflux is that you can get the same symptoms as a heart attack.
Back in the office today because it is less stressful than being home with the kids all day (they get the whole week off from school).

Glad to hear it wasn't a heart attack! Hope the other tests come back with minimal stuff (if anything).

-- Kit

SQLRNNR SSC Guru Points: 281334 More actions · Answer 15

Grant Fritchey (11/23/2010)
Paul White NZ (11/23/2010)
GilaMonster (11/23/2010)
Anyone up for a challenge?
http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx
I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and lots of NOLOCK to start with.
I would help, but am temporarily (I hope) blind having glanced at the stored procedure in question.
AWE not enabled on an x86 machine with 32GB RAM was another highlight.
Honestly, this place terrifies me sometimes.
I see how you consultants keep making money though. Seems like these shops are mushrooms. They're springing up all over the place.
There was so much low hanging fruit in that query...

It sure makes the jump to consulting look appetizing. If, as a consultant, one only needs to pick out the low hanging fruit to provide performance gains, you could be busy all the time just making the little changes.

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