Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 45,241 through 45,255 (of 66,712 total)

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

EL Jerry SSCertifiable Points: 7063 More actions · Answer 1

Ed Wagner (8/15/2014)
Ed Wagner (8/13/2014)
rodjkidd (8/13/2014)
Ed and Jason,
Some serious rain there. Glad to hear you are all OK.
Rodders...
Thanks for all the well wishes, everyone. Things are starting to dry out around here; there's only one freeway that's still closed due to about 13 feet of water. :w00t: I heard that Long Island, NY is being hit by the same system today.
Well, now that the roads are open and we've dried out a big, the next storm is now hitting us.
1. We got record rainfall Monday and a followup on Tuesday. Roads closed (14 feet was the maximum I heard) and basements flooded all over the Detroit metro area. People actually helped each other.
2. As soon as the water on the roads was shallow enough, the tow trucks cleared the roads. Starting Wednesday, the local news was reporting that the impound lots were charging motorists extra-high fees to get the water-soaked cars out of the impound lots. Let the gouging begin.
3. Now the scams have started. The "I can fix your home, but I need money up-front only to never be seen again" crowd has already started to hit the flood victims. We hear about this type of activity too much here, but with a natural disaster like this, it'll be more than usual. The news will swarm all over it for a few days, nothing will be done to stop it, then we won't hear much about it any more.
This people of this city hurt themselves more than the natural disaster.

People also need to watch out for flooded cars which will be for sale in a couple weeks or later, as I have read those cars are repaired "only to be sold", and naive customers won't find out the car really needs bigger and more expensive repairs, specifically upholstery and interiors.

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

To better understand your help request, please follow these best practices.[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

EL Jerry (8/15/2014)
Ed Wagner (8/15/2014)
Ed Wagner (8/13/2014)
rodjkidd (8/13/2014)
Ed and Jason,
Some serious rain there. Glad to hear you are all OK.
Rodders...
Thanks for all the well wishes, everyone. Things are starting to dry out around here; there's only one freeway that's still closed due to about 13 feet of water. :w00t: I heard that Long Island, NY is being hit by the same system today.
Well, now that the roads are open and we've dried out a big, the next storm is now hitting us.
1. We got record rainfall Monday and a followup on Tuesday. Roads closed (14 feet was the maximum I heard) and basements flooded all over the Detroit metro area. People actually helped each other.
2. As soon as the water on the roads was shallow enough, the tow trucks cleared the roads. Starting Wednesday, the local news was reporting that the impound lots were charging motorists extra-high fees to get the water-soaked cars out of the impound lots. Let the gouging begin.
3. Now the scams have started. The "I can fix your home, but I need money up-front only to never be seen again" crowd has already started to hit the flood victims. We hear about this type of activity too much here, but with a natural disaster like this, it'll be more than usual. The news will swarm all over it for a few days, nothing will be done to stop it, then we won't hear much about it any more.
This people of this city hurt themselves more than the natural disaster.
People also need to watch out for flooded cars which will be for sale in a couple weeks or later, as I have read those cars are repaired "only to be sold", and naive customers won't find out the car really needs bigger and more expensive repairs, specifically upholstery and interiors.

We expect some behavior like that. But behavior like that on a large scale by many people in society in a single community is bothersome.

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Luis Cazares (8/14/2014)
Grant Fritchey (8/14/2014)
Evil Kraig F (8/14/2014)
djj (8/14/2014)
ChrisM@Work (8/14/2014)
remember '76/'77
Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me from a company picnic. 🙂
Good lord, I'm surrounded by fogies! I was 1 years old for most of '77.
Mean old fogies. Never forget that.
I was 14 in 77.
I was -7 :hehe:

Ha! I didn't know we had the same age 😀

Luckily we are here to take the age average down in this thread 😎 :hehe:

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 4

Koen Verbeeck (8/16/2014)
Luis Cazares (8/14/2014)
Grant Fritchey (8/14/2014)
Evil Kraig F (8/14/2014)
djj (8/14/2014)
ChrisM@Work (8/14/2014)
remember '76/'77
Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me from a company picnic. 🙂
Good lord, I'm surrounded by fogies! I was 1 years old for most of '77.
Mean old fogies. Never forget that.
I was 14 in 77.
I was -7 :hehe:
Ha! I didn't know we had the same age 😀
Luckily we are here to take the age average down in this thread 😎 :hehe:

Hopefully only the age:w00t:

😎

Dwain Camps SSC Guru Points: 86948 More actions · Answer 5

Steve Jones - SSC Editor (8/12/2014)
Koen Verbeeck (8/11/2014)
GilaMonster (8/11/2014)
LutzM (8/10/2014)
b) block that spammer (mominbd) and all its variations using a filter
Maybe a throttle on posting new threads. A human can't post multiple threads in a very short time, the bots can (this mornings were around a minute apart)
1 minute between 1st and 2nd threads, 2 minutes between 2nd and 3rd, etc. Like with increasing delays for failed logins (which is recommended a security idea), it's unlikely to bother real users (other than the ones cross posting their stuff everywhere).
+1 seems effective.
I have sent some of these ideas to our developers. Fingers are crossed they'll do something.

You let your developers decide what needs doing? That's the scariest thought I've seen today.

Of course, the day is young.

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

higgim SSCarpal Tunnel Points: 4090 More actions · Answer 6

Not a happy chap with some of the help being offered! Go figure 🙂

Qira (8/18/2014)
Dear Mr Higgam,
You're helping me sir. Thanks to you. But no thanks to other one.

http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

higgim (8/18/2014)
Not a happy chap with some of the help being offered! Go figure 🙂
Qira (8/18/2014)
Dear Mr Higgam,
You're helping me sir. Thanks to you. But no thanks to other one.
http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx

Very interesting

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 8

Help! I was asked by my DBA to optimize the following query because it has a high cost.

DELETE MySchema.Facttable

WHERE datecol = @Date;

It's part of a stored procedure and hasn't been implemented so we don't have performance problems so far, it just has a high cost.

And that is just part of everything that makes me want to facepalm. I just love when the dbas ask everyone to optimize their queries without giving a hint on how to do it (other than using nolock hints everywhere).

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

higgim (8/18/2014)
Not a happy chap with some of the help being offered! Go figure 🙂
Qira (8/18/2014)
Dear Mr Higgam,
You're helping me sir. Thanks to you. But no thanks to other one.
http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx

What an attitude...

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182912 More actions · Answer 10

Luis Cazares (8/18/2014)
Help! I was asked by my DBA to optimize the following query because it has a high cost.
DELETE MySchema.Facttable
WHERE datecol = @Date;
It's part of a stored procedure and hasn't been implemented so we don't have performance problems so far, it just has a high cost.
And that is just part of everything that makes me want to facepalm. I just love when the dbas ask everyone to optimize their queries without giving a hint on how to do it (other than using nolock hints everywhere).

Why not suggest to partition the table on the datecol:-P

😎

David Burrows SSC Guru Points: 65142 More actions · Answer 11

Koen Verbeeck (8/19/2014)
higgim (8/18/2014)
Not a happy chap with some of the help being offered! Go figure 🙂
Qira (8/18/2014)
Dear Mr Higgam,
You're helping me sir. Thanks to you. But no thanks to other one.
http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx
What an attitude...

Yes. And I resisted to post, polite or otherwise 🙂

Far away is close at hand in the images of elsewhere.
Anon.

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

Luis Cazares (8/18/2014)
Help! I was asked by my DBA to optimize the following query because it has a high cost.
DELETE MySchema.Facttable
WHERE datecol = @Date;
It's part of a stored procedure and hasn't been implemented so we don't have performance problems so far, it just has a high cost.
And that is just part of everything that makes me want to facepalm. I just love when the dbas ask everyone to optimize their queries without giving a hint on how to do it (other than using nolock hints everywhere).

I really need to finish editing the article on premature optimisation...

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 13

David Burrows (8/19/2014)
Koen Verbeeck (8/19/2014)
higgim (8/18/2014)
Not a happy chap with some of the help being offered! Go figure 🙂
Qira (8/18/2014)
Dear Mr Higgam,
You're helping me sir. Thanks to you. But no thanks to other one.
http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx
What an attitude...
Yes. And I resisted to post, polite or otherwise 🙂

Yeah, me too. Sometimes it's best to just walk away. If they don't want help to begin with, why post at all?

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 14

David Burrows (8/19/2014)
Koen Verbeeck (8/19/2014)
higgim (8/18/2014)
Not a happy chap with some of the help being offered! Go figure 🙂
Qira (8/18/2014)
Dear Mr Higgam,
You're helping me sir. Thanks to you. But no thanks to other one.
http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx
What an attitude...
Yes. And I resisted to post, polite or otherwise 🙂

I couldn't restrain myself. Poor discipline 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

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

Koen Verbeeck (8/19/2014)
David Burrows (8/19/2014)
Koen Verbeeck (8/19/2014)
higgim (8/18/2014)
Not a happy chap with some of the help being offered! Go figure 🙂
Qira (8/18/2014)
Dear Mr Higgam,
You're helping me sir. Thanks to you. But no thanks to other one.
http://www.sqlservercentral.com/Forums/Topic1604205-392-2.aspx
What an attitude...
Yes. And I resisted to post, polite or otherwise 🙂
I couldn't restrain myself. Poor discipline 😀

It appeared to me that the OP only gave part of the picture.

I check data before submitting for an insert.

Sound advice was given, although they didn't see the real intent.

So in a roundabout way, they could be asking the wrong question.