Jeff Moden (11/18/2008)
consider the answer that one wiz kid gave..."You should be using derived column transformation, and use substring or available string functions. This would help." ... and that's ALL that was given as an answer.
Technically correct and, yet, totally useless.
Those are irritating, along with times where people post a badly rephrased copy of an answer one or two posts above.
What really gets to me are the answers that aren't just wrong, but are extremely dangerous. Like the one I saw at another forum where the OP had a problem with a full transaction log. The suggestion someone gave was to stop SQL and delete the tran log file...
I get more frustrated and upset with bad (dangerous) answers than with basic questions. I know the people are trying to help, but....
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