Concatenation

Question

Post reply

Concatenation

Viewing 8 posts - 16 through 22 (of 22 total)

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

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 1

Whenever a poster omits 'important' details about their problems and purposes with their queries (like 'this is a derived de-normalized table for reporting purposes only drawn from another system'), sidetracks and comments like this thread are very likely to happen

The point is, it's always better to describe something in more detail than less, though discussing is always fun , sometimes it's a bit frustrating when an original poster kills a thread by stating some facts that contradicts the original question asked.

/Kenneth

YSLGuru SSC-Insane Points: 21569 More actions · Answer 2

Keneth,

I couldn't agree with your post about the right tool. I work for a software company where too often the right tool is not used for the right job. Too often people look to one tool as the do it all magic tool and there ain't no such tool. That being said I ope you didn't miss my point because I'm not disagreeing with anything you have said. Regardless of how things should be done DBA's developers and others are often stuck working with things they have no control over and when that happens we should always try and help that person salavage what they can and never critique them, informing them that they have not set up their data correctly. I mention this not because I'm saying this has happened in this thread but because I have seen Relational DB Purist do just that in other posts and it really ticks me off.

So bottonline is that we often can't do everything based on an ideal world because those that make the decisions and leave us with the results don't always follow the best tool mentality. I don;t remember who said it or the exact phrase but someone once said that persons in a company are promoted to incompetence meaning they keep moving up the ladder until they get to a level they are not qualilfied to handle. Unfortunately they tend to stay there and those under that person pay the price.

Kindest Regards,

Just say No to Facebook!

Kenneth Wilhelmsson SSC-Dedicated Points: 30043 More actions · Answer 3

I agree as well.

In the academic world everything can be made perfect, though in the real world everything ultimately has to be a tradeoff.. because it always depends

I do belive (and hope I do as well) to always motivate comments when I say I think something is 'bad', and also try to provide or suggest an alternative, and the reasoning behind it.

/Kenneth

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Hey, 500 posts from Sweden here. Not bad for someone who doesn't like webfora.

Hm, when I have read this all correct, may I throw in another solution?

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Michael Du Bois SSCertifiable Points: 5143 More actions · Answer 5

Frank the link you posted is broken, or at least on my machine it is broken.

Ed your quote is adapted from the Peter Principal by L. Peters from a book titled The Peter Principal. Which is a vrey funny book one of those sad but true stories. The original quote is: in a hierarchically structured administration, people tend to be promoted up to their level of incompetence.

Mike