Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,5234,5244,5254,5264,527»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Friday, August 15, 2014 7:55 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 3,806, Visits: 1,235
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. 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.
Post #1603717
Posted Friday, August 15, 2014 7:58 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
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. 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
Post #1603721
Posted Saturday, August 16, 2014 6:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
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


Ha! I didn't know we had the same age
Luckily we are here to take the age average down in this thread




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1604080
Posted Saturday, August 16, 2014 7:23 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 2,532, Visits: 7,086
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


Ha! I didn't know we had the same age
Luckily we are here to take the age average down in this thread


Hopefully only the age
Post #1604082
Posted Sunday, August 17, 2014 6:55 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:53 PM
Points: 3,438, Visits: 5,390
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!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1604251
Posted Monday, August 18, 2014 2:47 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:51 AM
Points: 491, Visits: 1,466
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
Post #1604692
Posted Monday, August 18, 2014 2:56 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 3:20 PM
Points: 18,064, Visits: 16,099
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
Post #1604695
Posted Monday, August 18, 2014 3:53 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:55 PM
Points: 4,046, Visits: 9,200
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.
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?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1604708
Posted Tuesday, August 19, 2014 12:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 12:52 PM
Points: 13,636, Visits: 11,509
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...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1604757
Posted Tuesday, August 19, 2014 12:56 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 2,532, Visits: 7,086
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
Post #1604766
« Prev Topic | Next Topic »

Add to briefcase «««4,5234,5244,5254,5264,527»»»

Permissions Expand / Collapse