No reason for controversy except the inflammatory title (and if publicity is your goal, then even that's well done).

Your point is that the generalist programmer often doesn't understand working in...

FYI, moving (non-trivial) data from ASE to SQL Server in an automated fashion isn't particularly easy, at least without fairly expensive 3rd party tools. In general, you'll need to...

CirquedeSQLeil (11/2/2010)

---

One side of me wants to say this should no longer be an issue. The realist side of me realizes that there are so many SQL installs out...

Sure - didn't know it at the time because it wasn't important - we weren't running MS servers at all. But I know the history.

Whether it...

It turned out to be a great day in history - had it not happened, would SQL Server and Windows Server be so good today?

It didn't affect us....

I like it - certainly not a magic bullet, but for those of us who inherit complex databases without FKs defined, this is a nice productivity booster. Obviously, the...

BTW, there's no actually no database in that diagram, although there's a box labeled "database". If you only individual tables, and only allow so-called "CRUD" operations, you've lost...

Another silver bullet for "what's wrong with software development".

The development of mass production techniques and technology - a difficult, endless evolution - is a far better analogy than mass production...

First, see http://techcrunch.com/2010/08/28/silicon-valley%E2%80%99s-dark-secret-it%E2%80%99s-all-about-age/ - that's for real.

If you're over 45, and still a programmer, you'd better be one of the top ten in the world.

Where...

You are correct in that the example is too simplistic - the compiler will easily find all the plans before running out of time. In fact, there aren't many...

I'm going to respectfully offer different advice - what you are trying to do is logically and theoretically correct. It wasn't real practical in the past, but may be...

Thanks for posting. It's a difficult problem at times; I was hoping I could borrow your approach for my own situation. But doing the True General Proc for...

A nice improvement on the original, Timothy. So many developers never get past the point you started at.

May I recommend picking up "The Art of SQL" by Stephane Faroult?...

Steve said:

But is overusing of identity a big problem? I tend to see most people building databases as beginning to intermediate data modelers. I'd probably include myself in that group...

Actually, given that it's not a relational problem, a procedural solution is likely correct, unless there's another way that I'm mostly ignorant on (e.g. functional) to solve it .

Now this...